There is a hive table for which the metadata points to a non-existing hdfs
file. Simply calling
drop table <mytable>
results in:
Failed to load metadata for table: db.mytable
Caused by TAbleLoadingException: Failed to load metadata for table: db.mytable
File does not exist: hdfs://....
Caused by FileNotFoundException: File does not exist: hdfs:// ..
So: the file does not exist in hdfs , and it is not possible to remove the
metadata for it directly. Is the next step going to be: "run some sql
commands against the metastore to manually delete the associated rows"? If
so, what are those delete commands?
thanks
