Created 01-08-2019 06:51 AM
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.
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.