[IMPALA-7701] Grant option always shows as NULL in SHOW GRANT ROLE/USER for any HS2 clients

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 3.0, Impala 2.12.0
• Fix Version/s: Impala 3.1.0
• Component/s: Frontend
• Epic Color: ghx-label-1
• Assignee: Fredy Wijaya
• Reporter: Fredy Wijaya
• Created: 11/Oct/18 20:27
• Updated: 13/Oct/18 03:27
• Resolved: 12/Oct/18 21:05

Description

In Impala shell:

[localhost:21000] default> show grant user test_user;
Query: show grant user test_user
+----------------+----------------+----------+----------+-------+--------+-----+-----------+--------------+-------------------------------+
| principal_type | principal_name | scope    | database | table | column | uri | privilege | grant_option | create_time                   |
+----------------+----------------+----------+----------+-------+--------+-----+-----------+--------------+-------------------------------+
| USER           | test_user      | database | foo      |       |        |     | owner     | true         | Thu, Oct 11 2018 11:48:57.186 |
| ROLE           | admin          | server   |          |       |        |     | all       | false        | Thu, Oct 11 2018 11:48:48.203 |
+----------------+----------------+----------+----------+-------+--------+-----+-----------+--------------+-------------------------------+
Fetched 2 row(s) in 0.13s
[localhost:21000] default> show grant role admin;
Query: show grant role admin
+--------+----------+-------+--------+-----+-----------+--------------+-------------------------------+
| scope  | database | table | column | uri | privilege | grant_option | create_time                   |
+--------+----------+-------+--------+-----+-----------+--------------+-------------------------------+
| server |          |       |        |     | all       | false        | Thu, Oct 11 2018 11:48:48.203 |
+--------+----------+-------+--------+-----+-----------+--------------+-------------------------------+
Fetched 1 row(s) in 0.01s

Using Impyla (HS2 client):

>>> from impala.dbapi import connect
>>> conn = connect(host='localhost', port=21050)
>>> cursor = conn.cursor()
>>> cursor.execute('show grant user test_user')
>>> print(cursor.fetchall())
[('USER', 'test_user', 'database', 'foo', '', '', '', 'owner', None, 'Thu, Oct 11 2018 11:48:57.186'), ('ROLE', 'admin', 'server', '', '', '', '', 'all', None, 'Thu, Oct 11 2018 11:48:48.203')]
>>> cursor.execute('show grant role admin')
>>> print(cursor.fetchall())
[('server', '', '', '', '', 'all', None, 'Thu, Oct 11 2018 11:48:48.203')]