title: How to delete table entry from hive metastore when underlying hdfs file disappeared
body: <p>There is a table for which the backing hdfs file no longer exists. Now the problem is that the "drop table" command fails:</p>
  
  <pre><code>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:// ..
  </code></pre>