Support Questions

Find answers, ask questions, and share your expertise

Truncate hive external table using NiFi

avatar
Rising Star

Hi Experts,

Please let us know if we can use any NiFi processors for truncating hive table data. Thanks!

4 REPLIES 4

avatar
Master Collaborator

@NagendraKumar TRUNCATE is basically a DDL operation which you can run using PutHiveQL processor.

For info on the classification of a Hive command, refer to  https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL

avatar
Rising Star

Hi @smruti  / @caio_contente ,

Thanks a lot for your response!

I am new to NiFi and still exploring various options here. I am unable to find the correct way to pass the query to the PutHiveQL processor. Please help me by providing some steps to configure the PutHiveQL processor to perform the DDL operation. Thanks!

avatar
Contributor

@NagendraKumar  were you able to truncate the data with the processor that my colleague Smruti mentioned?

avatar
Contributor