[HIVE-6204] The result of show grant / show role should be tabular format

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Component/s: Authorization
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 15/Jan/14 05:46
• Updated: 09/Dec/14 07:26
• Resolved: 06/Feb/14 23:12

Description

hive> show grant role role1 on all;
OK
database	default
table	src
principalName	role1
principalType	ROLE
privilege	Create
grantTime	Wed Dec 18 14:17:56 KST 2013
grantor	navis
database	default
table	srcpart
principalName	role1
principalType	ROLE
privilege	Update
grantTime	Wed Dec 18 14:18:28 KST 2013
grantor	navis

This should be something like below, especially for JDBC clients.

hive> show grant role role1 on all;
OK
default	src			role1	ROLE	Create	false	1387343876000	navis
default	srcpart			role1	ROLE	Update	false	1387343908000	navis

Issue Links

• is blocked by: HIVE-6122 Implement show grant on <resource>
• is related to: HIVE-6387 hive testing - remove duplicate test mode config - hive.in.test
• is related to: HIVE-9018 SHOW GRANT ROLE in Hive should return "grant_time" in human readable format
• links to: review board