Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

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?