Workload management entity data in sys

From the Hive sys database, you can get information about workload management and other Hive entities.

Workload Management Views

Hive has a special database named sys, which is similar to a system catalog or information catalog. The sys database is part of the Hive Metastore. In the sys database you can query for views of all Hive entities, including workload management entities. The following workload management views are available:
  • SYS.WM_RESOURCEPLANS (NAME string, STATUS string, QUERY_PARALLELISM int, DEFAULT_POOL_PATH string)
  • SYS.WM_POOLS (RP_NAME string, PATH string, ALLOC_FRACTION double, QUERY_PARALLELISM int, SCHEDULING_POLICY string)
  • SYS.WM_MAPPINGS (RP_NAME string, ENTITY_TYPE string, ENTITY_NAME string, POOL_PATH string, ORDERING int)
  • SYS.WM_TRIGGERS (RP_NAME string, NAME string, TRIGGER_EXPRESSION string, ACTION_EXPRESSION string)
  • SYS.WM_POOLS_TO_TRIGGERS (RP_NAME string, POOL_PATH string, TRIGGER_NAME string)