How can I insert the SHOW statements results into a HIVE table please?
Something like:
CREATE TABLE Capture_Previliges AS SHOW GRANT ROLE <ROLE_NAME>;
I want to capture this information into a table to further process and perform some audits please. If there isn't a simple way then what would be my options?
Want this below kind of info in a table:
0: jdbc:hive2://localhost:10000> show grant user ashutosh on table hivejiratable;
+-----------+----------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
| database | table | partition | column | principal_name | principal_type | privilege | grant_option | grant_time | grantor |
+-----------+----------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
| default | hivejiratable | | | ashutosh | USER | DELETE | false | 1398303419000 | thejas |
| default | hivejiratable | | | ashutosh | USER | SELECT | false | 1398303407000 | thejas |
+-----------+----------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+