Support Questions

Find answers, ask questions, and share your expertise

MSCK hive external table using NiFi

avatar
Rising Star

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;
2 REPLIES 2

avatar
Master Collaborator

@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

avatar
Contributor

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