Truncate hive external table using NiFi

[#1]

Hi Experts,

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

[#2]

@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

[#3]

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!

[#4]

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

[#5]

hi @NagendraKumar , You can use puthiveql as described in this article
https://community.cloudera.com/t5/Support-Questions/how-to-use-puthiveql-in-NIFI/td-p/204542