question Re: Truncate hive external table using NiFi in Support Questions

Truncate hive external table using NiFi

NagendraKumar — Mon, 16 Sep 2024 13:55:25 GMT

Hi Experts,

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

Re: Truncate hive external table using NiFi

smruti — Tue, 24 Sep 2024 08:14:54 GMT

@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

Re: Truncate hive external table using NiFi

caio_contente — Wed, 02 Oct 2024 13:56:20 GMT

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

Re: Truncate hive external table using NiFi

NagendraKumar — Mon, 07 Oct 2024 10:46:36 GMT

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!

Re: Truncate hive external table using NiFi

caio_contente — Wed, 16 Oct 2024 15:00:51 GMT

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