Community Articles

Find and share helpful community-sourced technical articles.
Labels (1)


Trying to run "msck repair table <tablename>" gives the below error

Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null


The above error occurs when, increasing the value of the parameter to 15 fixes the issue

This is a known bug


Would you mind adding Apache Jira link?


That bug link won't work unless one is a HW employee or contractor.

The real issues linked to this internal BUG are the following Apache issues:

Hope that helps!

Workaround if you have spark-sql: spark-sql -e "msck repair table <tablename>".

it works for me all the time.

hope this helps!

New Contributor

Using the console this worked:

user@sandbox:~$ hive --hiveconf hive.msck.path.validation=ignore
hive> use mydatabase;
hive> msck repair table mytable;

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎03-31-2017 10:20 PM
Updated by:
Top Kudoed Authors