[jira] [Commented] (HIVE-14181) DROP TABLE in hive doesn't Throw Error

["Zsombor Fedor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-14181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16868301#comment-16868301 ] 

Zsombor Fedor commented on HIVE-14181:
--------------------------------------

Hey Guys,

is there any news on this issue? We hit it also in CDH5.16.1 (1.1.0).

When you try to drop a table in Impala/Hive, of which path in the warehouse was enabled for HDFS snapshotting, and a snapshot was made, you get an HDFS exception, 
{code:java}
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.protocol.SnapshotException): The directory /user/hive/warehouse/test cannot be deleted since /user/hive/warehouse/test is snapshottable and already has snapshots
{code}
and then an IO exception:
{code:java}
Got exception: java.io.IOException Failed to move to trash: hdfs://snapshot-1.vpc.cloudera.com:8020/user/hive/warehouse/test
{code}
converted to a MetaException:
{code:java}
Failed to delete table directory: hdfs://snapshot-1.vpc.cloudera.com:8020/user/hive/warehouse/test Got exception: java.io.IOException Failed to move to trash: hdfs://snapshot-1.vpc.cloudera.com:8020/user/hive/warehouse/test
{code}
but neither of these are appearing on the client side, nor a warning, and drop table seems like succeeded, the table got deleted from the HMS, but the files on the HDFS are remaining. 

Thanks,

Zsombor

> DROP TABLE in hive doesn't Throw Error
> --------------------------------------
>
>                 Key: HIVE-14181
>                 URL: https://issues.apache.org/jira/browse/HIVE-14181
>             Project: Hive
>          Issue Type: Bug
>         Environment: Hive 1.1.0
> CDH 5.5.1-1
>            Reporter: Pranjal Singh
>            Assignee: Adam Szita
>            Priority: Major
>              Labels: easyfix
>         Attachments: HIVE-14181.1.patch, HIVE-14181.2.patch
>
>
> drop table table_name doen't throw an error if drop table fails.
> I was dropping a table and my trash didn't have enough space to hold the table but the drop table command showed success and the table wasn't deleted. But the hadoop fs -rm -r /hive/xyz.db/table_name/ gave an error "Failed to move to trash" because I didnot have enough space quota in my trash.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)