hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Haviv <daniel.ha...@veracity-group.com>
Subject Re: How to clean up a table for which the underlying hdfs file no longer exists
Date Sun, 22 Mar 2015 04:47:19 GMT
You can (as a workaround) just create it's directory and then drop it

Daniel

> On 22 במרץ 2015, at 04:15, Stephen Boesch <javadba@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

Mime
View raw message