[
https://issues.apache.org/jira/browse/HIVE-27892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sai Hemanth Gantasala updated HIVE-27892:
-----------------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Status: Resolved (was: Patch Available)
[~mkunwar] - Thank you for your contribution. The patch has been merged to the
master branch.
> 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
> Fix For: 4.0.0
>
>
> 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)
