[
https://issues.apache.org/jira/browse/HIVE-27892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mayank Kunwar updated HIVE-27892:
---------------------------------
Status: Patch Available (was: Open)
> 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
> Priority: Major
> Labels: pull-request-available
>
> 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)
