The folder exists: just not the file. I tried both of Daniel's suggestions and they ended up with same error afterwards.
2015-03-22 2:07 GMT-07:00 Wollert, Fabian <fabian.woll...@zalando.de>: > can you create the specified folder (just leave it empty) and then delete > again? > > Cheers > Fabian > > 2015-03-22 3:15 GMT+01:00 Stephen Boesch <java...@gmail.com>: > >> >> 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 >> > > > > -- > *Fabian Wollert* > Business Intelligence > > > > *POSTANSCHRIFT* > Zalando SE > 11501 Berlin > > *STANDORT* > Zalando SE > Mollstraße 1 > 10178 Berlin > Germany > > Phone: +49 30 20968 1819 > Fax: +49 30 27594 693 > E-Mail: fabian.woll...@zalando.de > Web: www.zalando.de > Jobs: jobs.zalando.de > > Zalando SE, Tamara-Danz-Straße 1, 10243 Berlin > Handelsregister: Amtsgericht Charlottenburg, HRB 158855 B > Steuer-Nr. 29/560/00596 * USt-ID-Nr. DE 260543043 > Vorstand: Robert Gentz, David Schneider, Rubin Ritter > Vorsitzende des Aufsichtsrates: Cristina Stenbeck > Sitz der Gesellschaft: Berlin >