hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <>
Subject Re: Drop table skiptrash?
Date Mon, 24 Dec 2012 13:37:15 GMT
Well in hive you can set hadoop variables so you can use the set command to
explicitly disable trash on the client

set x=y

If that does not work it is possible to run dfs commands from hive. Just do
your normal hadoop dfs command without specifying hadoop.

hive > dfs -rmr /user/hive/warehouse

On Mon, Dec 24, 2012 at 2:46 AM, Periya.Data <> wrote:

> Hi,
>    Is there a way to drop a table such that the contents do not go to the
> .Trash dir? I have limited diskQuota in hadoop and am running large Hive
> jobs in sequence. I would like to drop tables as and when they become
> unnecessary and also they must not end up in they occupy lot of
> space.
> Before I begin my Hive job, I do clean out  (hadoop fs -rmr -skipTrash
> ...). I would like to know if there something like this to add in my hql
> file.
> Thanks,
> PD.

View raw message