Support Questions

Find answers, ask questions, and share your expertise

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

avatar
New Member

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

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

avatar
New Member

Is this issue resolved?

avatar
New Member

@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 Member

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