[ 
https://issues.apache.org/jira/browse/IMPALA-12554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17948776#comment-17948776
 ] 

ASF subversion and git services commented on IMPALA-12554:
----------------------------------------------------------

Commit 8f7d2246ec356334c28cb616c4c335d3a8d686fa in impala's branch 
refs/heads/master from Fang-Yu Rao
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=8f7d2246e ]

IMPALA-12554: (Addendum) Add a flag to not consolidate requests by default

This patch adds a startup flag so that by default the catalog server
will not consolidate the grant/revoke requests sent to the Ranger server
when there are multiple columns involved in the GRANT/REVOKE statement.

Testing:
 - Added 2 end-to-end tests to make sure the grant/revoke requests
   sent to the Ranger server would be consolidated only when the flag
   is explicitly added when we start the catalog server.

Change-Id: I4defc59c048be1112380c3a7254ffa8655eee0af
Reviewed-on: http://gerrit.cloudera.org:8080/22833
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> Create only one Ranger policy for GRANT statement
> -------------------------------------------------
>
>                 Key: IMPALA-12554
>                 URL: https://issues.apache.org/jira/browse/IMPALA-12554
>             Project: IMPALA
>          Issue Type: Improvement
>            Reporter: Fang-Yu Rao
>            Assignee: Fang-Yu Rao
>            Priority: Major
>             Fix For: Impala 4.5.0
>
>
> Currently Impala would create a Ranger policy for each column specified in a 
> GRANT statement. For instance, after the following query, 3 Ranger policies 
> would be created on the Ranger server. This could result in a lot of policies 
> created when there are many columns specified and it may result in Impala's 
> Ranger plug-in taking a long time to download the policies from the Ranger 
> server. It would be great if Impala only creates one single policy for 
> columns in the same table.
> {code:java}
> [localhost:21050] default> grant select(id, bool_col, tinyint_col) on table 
> functional.alltypes to user non_owner;
> Query: grant select(id, bool_col, tinyint_col) on table functional.alltypes 
> to user non_owner
> Query submitted at: 2023-11-10 09:38:58 (Coordinator: http://fangyu:25000)
> Query progress can be monitored at: 
> http://fangyu:25000/query_plan?query_id=bc4fa1cdefe5881b:413d9a6900000000
> +---------------------------------+
> | summary                         |
> +---------------------------------+
> | Privilege(s) have been granted. |
> +---------------------------------+
> Fetched 1 row(s) in 0.67s
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to