Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Drop table skiptrash?

Copy link to this message
Re: Drop table skiptrash?
set fs.trash.interval=0;

hadoop dfs -rmr --skipTrash <datapath>
drop table
On Mon, Dec 24, 2012 at 1:16 PM, Periya.Data <[EMAIL PROTECTED]> 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.
Nitin Pawar