[HIVE-6919] hive sql std auth select query fails on partitioned tables

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 0.13.1, 0.14.0
• Component/s: Authorization
• Assignee: Thejas Nair
• Reporter: Thejas Nair
• Created: 16/Apr/14 04:15
• Updated: 09/Jun/14 06:39
• Resolved: 17/Apr/14 19:55

Description

analyze table studentparttab30k partition (ds) compute statistics;
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied. Principal [name=hadoopqa, type=USER] does not have following privileges on Object [type=PARTITION, name=null] : [SELECT] (state=42000,code=40000)

Sql std auth is supposed to ignore partition level objects for privilege checks, but that is not working as intended.

Issue Links

• relates to: HIVE-5837 SQL standard based secure authorization for hive
• links to: review board