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 | +-----------+----------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+   ... View more