I am unable to create external hive table after manually deleting underlying hdfs location files of the table.
when table desc is statement is issued, it gives the describe of the table, but when select is performed on the table, then we are getting table doesn't exists. So we issued drop statement.
After issuing drop statement, then we again tried to create the table, but we are getting table already exists. Do we need to manually do a delete from the hive metastore ? or is there any way to forcefully re-create the table ? Please let me know.
We even ran the MSCK repair table, but still no luck. Any other options ?
Could you try performing the "Validate hivemetastore schema " from Cloudera manager - > Hive service then
Let us know if you are able to create the same table.