[ https://issues.apache.org/jira/browse/IMPALA-2738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alex Rodoni updated IMPALA-2738: -------------------------------- Docs Text: (was: John, we should document this inconsistency in the KIs.) > Hive/Impala inconsistency in GRANT syntax > ----------------------------------------- > > Key: IMPALA-2738 > URL: https://issues.apache.org/jira/browse/IMPALA-2738 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 2.3.0 > Reporter: Mariano Dominguez > Assignee: Thomas Tauber-Marshall > Priority: Critical > Labels: ramp-up > Fix For: Impala 2.6.0 > > > There is an inconsistency between Hive and Impala when it comes to Sentry's > "GRANT ALL ON SERVER" statement: > {noformat} > [localhost.localdomain:21000] > GRANT ALL ON SERVER server1 TO ROLE etl; > Query: grant ALL ON SERVER server1 TO ROLE etl > ERROR: AnalysisException: Syntax error in line 1: > grant ALL ON SERVER server1 TO ROLE etl > ^ > Encountered: IDENTIFIER > Expected: FROM, TO > CAUSED BY: Exception: Syntax error > [localhost.localdomain:21000] > > {noformat} > The following is equivalent: > *Hive > GRANT ALL ON SERVER server1 TO ROLE <role>; > REVOKE ALL ON SERVER server1 FROM ROLE <role>; > *Impala > GRANT ALL ON SERVER TO ROLE <role>; > REVOKE ALL ON SERVER FROM ROLE <role>; -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org