Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E643F175AB for ; Wed, 25 Feb 2015 22:59:05 +0000 (UTC) Received: (qmail 42865 invoked by uid 500); 25 Feb 2015 22:59:05 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 42842 invoked by uid 500); 25 Feb 2015 22:59:05 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 42824 invoked by uid 99); 25 Feb 2015 22:59:05 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Feb 2015 22:59:05 +0000 Date: Wed, 25 Feb 2015 22:59:05 +0000 (UTC) From: "Lefty Leverenz (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-7100) Users of hive should be able to specify skipTrash when dropping tables. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-7100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14337403#comment-14337403 ] Lefty Leverenz commented on HIVE-7100: -------------------------------------- The syntax for PURGE in a drop partition statement is under discussion in HIVE-9086. The question is whether PURGE belongs after or before the partition specification. I'm bringing it up here because this jira has more watchers who might want to voice their opinions. > Users of hive should be able to specify skipTrash when dropping tables. > ----------------------------------------------------------------------- > > Key: HIVE-7100 > URL: https://issues.apache.org/jira/browse/HIVE-7100 > Project: Hive > Issue Type: Improvement > Components: Query Processor > Affects Versions: 0.13.0 > Reporter: Ravi Prakash > Assignee: david serafini > Fix For: 0.14.0 > > Attachments: HIVE-7100.1.patch, HIVE-7100.10.patch, HIVE-7100.11.patch, HIVE-7100.2.patch, HIVE-7100.3.patch, HIVE-7100.4.patch, HIVE-7100.5.patch, HIVE-7100.8.patch, HIVE-7100.9.patch, HIVE-7100.patch > > > Users of our clusters are often running up against their quota limits because of Hive tables. When they drop tables, they have to then manually delete the files from HDFS using skipTrash. This is cumbersome and unnecessary. We should enable users to skipTrash directly when dropping tables. > We should also be able to provide this functionality without polluting SQL syntax. -- This message was sent by Atlassian JIRA (v6.3.4#6332)