[
https://issues.apache.org/jira/browse/SENTRY-2555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17242149#comment-17242149
]
Eiley Choi edited comment on SENTRY-2555 at 12/2/20, 8:29 AM:
--------------------------------------------------------------
[~dengzh] Have you forked the project and made the change to the code directly?
I'm facing the same issue and I wonder if I need to make changes to the code to
use SQL directly.. I'm new to Sentry and thank you for your insight.
+ how many privileges do you have in your `SENTRY_DB_PRIVILEGE` table? I have
over 40k and I wonder if it's large enough to justify the slow query by ORM..
was (Author: gogetteryoungun):
[~dengzh] Have you forked the project and made the change to the code directly?
I'm facing the same issue and I wonder if I need to make changes to the code to
use SQL directly.. I'm new to Sentry and thank you for your insight.
> 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)
