[HIVE-16960] Hive throws an ugly error exception when HDFS sticky bit is set

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Labels: newbie
• Target Version/s: 3.0.0
• Assignee: Janaki Lahorani
• Reporter: Janaki Lahorani
• Created: 26/Jun/17 16:28
• Updated: 22/May/18 23:58
• Resolved: 19/Jul/17 18:12

Description

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.

Issue Links

• links to: RB