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 <periya.d...@gmail.com> 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 .Trash..as 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. > > >