Repair hive table partition

To repair if partitions present in a table
hive> MSCK REPAIR TABLE <tablename>;
OK
If msck throws error:
hive> MSCK REPAIR TABLE <tablename>;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Then
hive> set hive.msck.path.validation=ignore;
hive> MSCK REPAIR TABLE <tablename>;
OK
0 Comments

There are no comments yet

Leave a comment

Your email address will not be published. Required fields are marked *