hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Haviv <>
Subject Re: How to clean up a table for which the underlying hdfs file no longer exists
Date Sun, 22 Mar 2015 04:48:27 GMT
You can also use
And then drop it


> On 22 במרץ 2015, at 04:15, Stephen Boesch <> wrote:
> There is a hive table for which the metadata points to a non-existing hdfs file.  Simply
>     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

View raw message