How to create an external table in Hive?

[matthiasgomolka]

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]

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.