[jira] [Updated] (HIVE-27892) Hive "insert overwrite table" for multiple partition table issue

["Sai Hemanth Gantasala (Jira)" <ji...@apache.org>]

     [ 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)