[
https://issues.apache.org/jira/browse/SENTRY-2555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17242176#comment-17242176
]
Zhihua Deng commented on SENTRY-2555:
-------------------------------------
In our case, there are 99k privileges in table SENTRY_DB_PRIVILEGE, and about
19k public privileges. I will file a patch to this Jira latter today.
> 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
> Attachments: image-2020-04-20-17-17-54-251.png
>
>
> 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)
