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