Help Center/ MapReduce Service/ User Guide (Kuala Lumpur Region)/ Troubleshooting/ Using Hive/ An Error Is Reported When msck repair table table_name Is Run on Hive
Updated on 2022-12-14 GMT+08:00

An Error Is Reported When msck repair table table_name Is Run on Hive

Symptom

When msck repair table table_name is run on Hive, the error message "FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=08S01,code=1)" is displayed.

Possible Causes

A directory in the HiveServer log file /var/log/Bigdata/hive/hiveserver/hive.log does not comply with the partition format.

Procedure

  • Method 1: Delete the incorrect file or directory.
  • Method 2: Run the set hive.msck.path.validation=skip command to skip invalid directories.