hive_system Table
A pseudo-table called hive_system can be used to query for Hive cluster system environment information. The pseudo-table is under the pseudo-schema called hive_system. The table has two STRING type columns, envkey and envvalue. Standard SQL can be executed against the hive_system table. For example:
SELECT * FROM HIVE.hive_system.hive_system WHERE envkey LIKE '%hive%'
The above query returns all of the Hive system environment entries whose key contains the word "hive". A special query, set -v, is executed to fetch system environment information. Some versions of Hive do not support this query. For versions of Hive that do not support querying system environment information, the connector returns an empty result set.