how to skip trash when using INSERT OVERWRITE in hive

[#1]

Application has multiple jobs with ‘insert overwrite’ route and that is filling up the trash dir (under home dir, by default) with deleted records. As quotas are implemented, this is causing to exceed the threshold size. do we have any option to skip trash in hive per session basis, or , any option to change the trash dir location per session.

[#2]

Hi Vidya

I am unable to put forward new thread. I dont see an option for that. I have marked this thread as new as it is most related to my current issue.Also I have replied to Paras for that post.

[#3]

@AnjaliRocks , I have sent you a PM for further details.