Help Center/ MapReduce Service/ Troubleshooting/ Using Hive/ An Error Is Reported When msck repair table Is Executed on Hive
Updated on 2023-11-30 GMT+08:00

An Error Is Reported When msck repair table Is Executed on Hive

Symptom

The following error is reported when the msck repair table table_name command is executed on Hive:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=08S01,code=1).

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.