question MSCK hive external table using NiFi in Support Questions

MSCK hive external table using NiFi

NagendraKumar — Fri, 20 Sep 2024 14:01:45 GMT

Hi Experts,

Please let us know if we can use any NiFi processors for performing MSCK repair on the hive table to reflect the data that are updated by NiFi to HDFS. Thanks!

Command :

MSCK REPAIR TABLE tblName;

Re: MSCK hive external table using NiFi

smruti — Tue, 24 Sep 2024 08:16:13 GMT

@NagendraKumar MSCK Repair which is a DDL operation can be run through PutHiveQL processor.

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

Re: MSCK hive external table using NiFi

caio_contente — Wed, 02 Oct 2024 14:12:19 GMT

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