Hi,
I am trying to append some data into a partitioned table in haoop impala.
When I attmept this using the 'write data in-db' tool I get the error message 'not enough partioned columns mentioned in query'
Does anyone know any ways of getting around this?
Thanks,
Naomi
Can someone respond to this question?
This tool will always remove CLUSTERING and PARTITION BY when writing out... so if the table had this in the db it, and the option to Overwrite is selected, it will remove these table features.
There is this idea to support partition in indb
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/In-database-and-output-tool-Partitio...
Best regards,
Simon