use write in db tool to create hive external tables

[sid]

hello,

As per this thread,

http://community.alteryx.com/t5/Data-Sources/Writing-into-Partitioned-tables-in-Hive-using-In-databa...

It seems like there is a way to use the write-in db tool to write to hive external tables. We are using hortonworks hive odbc driver 2.1.2

Can you shed more light on which hive driver will help us achieve this?

In my situation, I want to write to a hive external table refers to a file in a custom location ( and not to /apps/hive/warehouse)

Thanks

Sid

[JuanAlvarez1]

I have tried creating external tables with the dynamic input in DB tool but no success.

Where you able to create hive external tables?

[simonaubert_bd]

Hello @sid and @JuanAlvarez1 

It's still impossible but you can vote for this idea :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-DB-or-output-Data-Choose-if-table-is-exte...

Best regards,

Simon