Created 09-16-2024 06:55 AM
Hi Experts,
Please let us know if we can use any NiFi processors for truncating hive table data. Thanks!
Created 09-24-2024 01:14 AM
@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
Created 10-07-2024 03:46 AM
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!
Created 10-02-2024 06:56 AM
@NagendraKumar were you able to truncate the data with the processor that my colleague Smruti mentioned?
Created 10-16-2024 08:00 AM
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