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
