[
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
