[ https://issues.apache.org/jira/browse/SENTRY-2437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16667767#comment-16667767 ]
Arjun Mishra edited comment on SENTRY-2437 at 10/29/18 9:06 PM: ---------------------------------------------------------------- Also with the current change revoke takes only 48.458 seconds for the above example with _REVOKE SELECT(col1, col2, .... col1800) ON TABLE_ was (Author: arjunmishra13): Also with the current change revoke takes only 48.458 seconds for the above example with REVOKE SELECT(col1, col2, .... col1800) ON TABLE > When granting privileges a single transaction per grant causes long delays > -------------------------------------------------------------------------- > > Key: SENTRY-2437 > URL: https://issues.apache.org/jira/browse/SENTRY-2437 > Project: Sentry > Issue Type: Bug > Components: Sentry > Reporter: Arjun Mishra > Assignee: Arjun Mishra > Priority: Major > Attachments: SENTRY-2437.01.patch > > > Currently sentry creates a transaction for each TSentryPrivilege object it > needs to grant. If the list of privileges is very large creating a single > transaction for each significantly affects performance. This is particularly > impactful for tables with large columns and if a user grants privileges to > many of those columns -- This message was sent by Atlassian JIRA (v7.6.3#76005)