[IMPALA-2738] Hive/Impala inconsistency in GRANT syntax

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0
• Fix Version/s: Impala 2.6.0
• Component/s: Frontend
• Labels: ramp-up
• Target Version: Product Backlog
• Assignee: Thomas Tauber-Marshall
• Reporter: Mariano Dominguez
• Created: 03/Dec/15 19:09
• Updated: 01/May/18 21:25
• Resolved: 19/Mar/16 00:05

Description

There is an inconsistency between Hive and Impala when it comes to Sentry's "GRANT ALL ON SERVER" statement:

[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] >

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>;