[jira] [Comment Edited] (SENTRY-2555) Slow list_sentry_privileges_for_provider request in heavy load

["Zhihua Deng (Jira)" <ji...@apache.org>]

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

Zhihua Deng edited comment on SENTRY-2555 at 4/20/20, 9:16 AM:
---------------------------------------------------------------

Can we use direct sql to retrieve the privileges?  Some tests show that we can gain about 3.0X faster if we do like this. 


was (Author: dengzh):
Can we remove the transaction or provide someway to ignore it?  Some tests show that we can gain about 3.0X faster if we remove the transaction on our hive cluster.

> Slow list_sentry_privileges_for_provider request in heavy load
> --------------------------------------------------------------
>
>                 Key: SENTRY-2555
>                 URL: https://issues.apache.org/jira/browse/SENTRY-2555
>             Project: Sentry
>          Issue Type: Improvement
>          Components: sentrystore
>    Affects Versions: 1.7.1
>         Environment: Hive 1.2.1
>            Reporter: Zhihua Deng
>            Priority: Major
>
> Hive uses list_sentry_privileges_for_provider to retrieve privileges of the current user.  ORM will  cause poor performance on the cluster with heavy load.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)