Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 1A507200CB4 for ; Tue, 27 Jun 2017 18:33:05 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 18D8E160BDC; Tue, 27 Jun 2017 16:33:05 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 6016E160BE9 for ; Tue, 27 Jun 2017 18:33:04 +0200 (CEST) Received: (qmail 52685 invoked by uid 500); 27 Jun 2017 16:33:03 -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 52676 invoked by uid 99); 27 Jun 2017 16:33:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Jun 2017 16:33:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 1F6D41A05F5 for ; Tue, 27 Jun 2017 16:33:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id wDgxAOzpsTgH for ; Tue, 27 Jun 2017 16:33:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 1DF805F6BF for ; Tue, 27 Jun 2017 16:33:02 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 94A13E00A0 for ; Tue, 27 Jun 2017 16:33:01 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 1E6E32412C for ; Tue, 27 Jun 2017 16:33:00 +0000 (UTC) Date: Tue, 27 Jun 2017 16:33:00 +0000 (UTC) From: "Janaki Lahorani (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-16960) Hive throws an ugly error exception when HDFS sticky bit is set MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Tue, 27 Jun 2017 16:33:05 -0000 [ https://issues.apache.org/jira/browse/HIVE-16960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Janaki Lahorani updated HIVE-16960: ----------------------------------- Labels: newbie (was: ) Fix Version/s: 3.0.0 Affects Version/s: 3.0.0 Target Version/s: 3.0.0 Status: Patch Available (was: Open) Error from DFS results in ugly stack at the client. The fix returns hive errors for AccessControlException, *QuotaExceededException, UnresolvedPathException, FileNotFoundException and Invalid File Formats. First line from the DFS error message is included in the error returned to the client. SQL State values are defined with these error message and propagated to client. Internal error 29999 is introduced to handle any error that would require complete stack thrown to the client. > Hive throws an ugly error exception when HDFS sticky bit is set > --------------------------------------------------------------- > > Key: HIVE-16960 > URL: https://issues.apache.org/jira/browse/HIVE-16960 > Project: Hive > Issue Type: Bug > Affects Versions: 3.0.0 > Reporter: Janaki Lahorani > Assignee: Janaki Lahorani > Priority: Critical > Labels: newbie > Fix For: 3.0.0 > > > When calling LOAD DATA INPATH ... OVERWRITE INTO TABLE ... from a Hive user other than the HDFS file owner, and the HDFS sticky bit is set, then Hive will throw an error exception message that the file cannot be moved due to permission issues. > Caused by: org.apache.hadoop.security.AccessControlException: Permission denied by sticky bit setting: user=hive, inode=sasdata-2016-04-20-17-13-43-630-e-00001.dlv.bk > The permission denied is expected, but the error message does not make sense to users + the stack trace displayed is huge. We should display a better error message to users, and maybe provide with help information about how to fix it. -- This message was sent by Atlassian JIRA (v6.4.14#64029)