Query sys database for plan data
You query the sys database in the Hive Metastore to retrieve information about workload management entities, such as a resource plan.
- You established a connection to HiveServer on the cluster you want to manage, and you started Hive from the Beeline shell, for example.
- A resource plan for managing a workload on your cluster was created.
Get views of the query pools for the resource plan, for example.
SELECT * FROM SYS.WM_POOLS WHERE RP_NAME = 'high_concurr_rp';
Get information about a trigger named slow_query in the pool named etl_pool pool of the plan.
SELECT TRIGGER_NAME.slow_query FROM SYS.WM_POOLS_TO_TRIGGERS WHERE RP_NAME = 'high_concurr_rp';