[SENTRY-826] TRUNCATE on empty partitioned table in Hive fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.7.0
• Component/s: Hive Plugin
• Assignee: Li Li
• Reporter: Lenni Kuff
• Created: 01/Aug/15 15:28
• Updated: 10/Jan/16 08:09
• Resolved: 10/Jan/16 08:06

Description

TRUNCATE on empty partitioned table in Hive fails. If the table contains at least one partition, the operation will succeed:

CREATE ROLE admin;
GRANT ALL ON SERVER server1 TO ROLE admin;
GRANT ROLE ADMIN TO GROUP <current group>;

CREATE TABLE Foo(i int) PARTITIONED BY (j int);
-- Fails
TRUNCATE TABLE Foo;

Error: Error while compiling statement: FAILED: SemanticException No valid privileges
 Required privileges for this query: (state=42000,code=40000)

-- Now add a partition
ALTER TABLE FOO ADD PARTITION (j=1);

-- Succeeds
TRUNCATE TABLE Foo;

Issue Links

• links to: code review