Help Center/ MapReduce Service/ Troubleshooting/ Using Hive/ An Error Is Reported When msck repair table Is Executed on Hive
Updated on 2024-12-18 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.
Parent topic: Using Hive
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.