Is it possible to get Role information via Hive QL?

hadoop, hive

Solution

to view roles : `SHOW ROLE GRANT principal_specification`

to view privilages : `SHOW GRANT principal_specification [ON object_type priv_level [(column_list)]]`

where : `principal_specification : USER user | GROUP group | ROLE role `

For more details look here

Problem

I understand the concept of a role that Hive uses for security. Is it possible to find this information via Hive QL using a statement like `DISPLAY ROLES`? Bonus: Is it possible to get Hadoop user information via Hive QL?

Original source