You can (as a workaround) just create it's directory and then drop it Daniel
> On 22 במרץ 2015, at 04:15, Stephen Boesch <java...@gmail.com> wrote: > > > 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
