hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Boesch <java...@gmail.com>
Subject Re: How to clean up a table for which the underlying hdfs file no longer exists
Date Sun, 22 Mar 2015 15:36:03 GMT
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.wollert@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 <javadba@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.wollert@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
>

Mime
View raw message