Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Error: Error while compiling statement: FAILED: SemanticException Unable to fetch table testDB.TestTable. null (state=42000,code=40000)

avatar
Explorer

0: jdbc:hive2://zaplncb00009q39-hs.qa.hadoop.> drop table testDB.TestTable; Error: Error while compiling statement: FAILED: SemanticException Unable to fetch table testDB.TestTable. null (state=42000,code=40000)

While performing any query on this table, I'm getting this error. Not able to delete database as well.

4 REPLIES 4

avatar
New Contributor

Were you able to resolve this? We are getting similar errors

avatar
New Contributor

Is this issue resolved?

avatar
Explorer

@Mayank Bhatt @sundeep dande We had to contact Hortonworks support to fix it. As per them the metadata was corrupted. I don't have the steps to fix that.

P.S.One of the reasons why the metadata was getting corrupted was someone had created many managed table pointing external hdfs location. Though the table in question was not one of those tables.

avatar
New Contributor

@Mayank Bhatt @sundeep dande I faced the same issue too. When I changed the engine from tez to mr(mapreduce) it worked!