Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Periya.Data 2012-12-24, 07:46
Copy link to this message
-
Re: Drop table skiptrash?
option1:
set fs.trash.interval=0;

option2:
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
+
Edward Capriolo 2012-12-24, 13:37
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB