Mayank Kunwar created HIVE-27892:
------------------------------------
Summary: Hive "insert overwrite table" for multiple partition
table issue
Key: HIVE-27892
URL: https://issues.apache.org/jira/browse/HIVE-27892
Project: Hive
Issue Type: Bug
Reporter: Mayank Kunwar
Assignee: Mayank Kunwar
Authorization is not working for Hive "insert overwrite table" for multiple
partition table.
Steps to reproduce the issue:
1) CREATE EXTERNAL TABLE Part (eid int, name int)
PARTITIONED BY (position int, dept int);
2) SET hive.exec.dynamic.partition.mode=nonstrict;
3) INSERT INTO TABLE PART PARTITION (position,DEPT)
SELECT 1,1,1,1;
4) select * from part;
create a test user test123, and grant test123 only Select permission for db
default, table Part and column * .
1) insert overwrite table part partition(position=2,DEPT=2) select 2,2;
This will failed as expected.
2) insert overwrite table part partition(position,DEPT) select 2,2,2,2;
This will failed as expected.
3) insert overwrite table part partition(position=2,DEPT) select 2,2,2;
But this will succeed and no audit in Ranger, which means no authorization
happened when this query was executed.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
