search

r-dbi / dbi3

DBI revisited
https://r-dbi.github.io/dbi3
37 stars 2 forks source link

How to create an external table in Hive? #53

Open matthiasgomolka opened 2 years ago

matthiasgomolka commented 2 years ago

Hi again,

I haven't found anything about this topic, so I'm asking here.

I would like to use dbCreateTable() to create an external table in a Hive. However, I only found the option to create temporary tables (and "normal" tables, obviously).

Is there a possibility to create an external table using dbCreateTable()? I know that I can use dbExecute() to do so, but the user experience would be nicer if this was also possible with dbCreateTable.

krlmlr commented 2 years ago

Thanks. I think the best that works today is to use DBI::sqlCreateTable() and patch the result. Adding options to generated queries/statements is something that we should consider for the future.