Write to Partitioned tables in Hive using In-database and drop partitions before

[aser]

Hi 

how I can write data direct to a partitioned tables in HIve?

The second question is how I can execute an drop partition statement to drop partitions which are inserted before?

like this one

ALTER TABLE pageviews DROP IF EXISTS PARTITION(datestamp = '2014-09-21');

[simonaubert_bd]

Hello @aser 

As of today, Alteryx does not support partition. But you can vote for this idea :
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/In-database-and-output-tool-Partitio...
Best regards,

Simon