Hive LLAP Workload Management commands

Workload management feature can be controlled and managed with the help of following Hive commands. These commands resemble the existing ALTER, CREATE, DROP, and SHOW statements.

Changes the routing of queries to a resource pool.

ALTER { USER | GROUP | APPLICATION } MAPPING 'entity_name' IN plan_name { TO pool_path | UNMANAGED } [ WITH ORDER num ]

ALTER USER MAPPING 'hive' IN demo_plan TO etl WITH ORDER 1;

Modifies query pool properties, adds triggers, and removes triggers.

ALTER POOL plan_name.pool_path [ SET {property=value, ... } | UNSET { property, ... } ];
ALTER POOL plan_name.pool_path [ ADD | DROP ] TRIGGER name;

ALTER POOL demo_plan.default ADD TRIGGER defaultToETL;

Enables, disables, activates, validates, or changes a plan.

ALTER RESOURCE PLAN name [ VALIDATE | DISABLE | ENABLE | ACTIVATE | RENAME TO another_name | SET {property=value, ... } | UNSET {property, ... } ];

ALTER RESOURCE PLAN demo_plan SET DEFAULT POOL=etl, QUERY_PARALLELISM=3;

Adds a trigger to or removes a trigger from a resource pool.

ALTER TRIGGER plan_name.name { ADD TO | DROP FROM } { POOL path | UNMANAGED };

ALTER TRIGGER demo_plan.ETLKill ADD TO POOL etl;

Routes queries to a resource pool.

CREATE { USER | GROUP | APPLICATION } MAPPING 'entity_name' IN plan_name { TO pool_path | UNMANAGED } [ WITH ORDER num ];

CREATE USER MAPPING 'hive' IN demo_plan TO sys_accounts WITH ORDER 1;

Creates and adds a query pool for a resource plan.

CREATE POOL plan_name.path WITH ALLOC_FRACTION = decimal, QUERY_PARALLELISM = num, [ SCHEDULING_POLICY = scheduling_value ];

CREATE POOL demo_plan.etl WITH ALLOC_FRACTION = 0.20, QUERY_PARALLELISM = 2;

Creates a resource plan

CREATE RESOURCE PLAN plan_name [ WITH QUERY PARALLELISM=number | LIKE name];

CREATE RESOURCE PLAN demo_plan;

Creates and adds a trigger to a resource plan.

CREATE TRIGGER plan_name.name WHEN condition DO action;

CREATE TRIGGER demo_plan.defaultToETL WHEN  ELAPSED_TIME > 20000 DO MOVE TO etl;

Deactivates the active resource plan.

DISABLE WORKLOAD MANAGEMENT;

DISABLE WORKLOAD MANAGEMENT

Removes a mapping from a resource plan.

DROP { USER | GROUP | APPLICATION } MAPPING 'entity_name' IN plan_name;

DROP USER MAPPING 'hive' IN demo_plan;

Removes a query pool from a resource plan.

DROP POOL plan_name.pool_path;

CREATE POOL demo_plan.etl;

Deletes a resource plan.

DROP RESOURCE PLAN plan_name;

DROP RESOURCE PLAN demo_plan;

Deletes a trigger from a resource plan.

DROP TRIGGER plan_name.trigger_name;

DROP TRIGGER demo_plan.defaultToETL;

Replaces the contents of one resource plan with the contents of another.

REPLACE RESOURCE PLAN name1 WITH name2; 
REPLACE ACTIVE RESOURCE PLAN name1 WITH name2;

REPLACE RESOURCE PLAN rp_plan1 WITH rp_plan2;

Lists plan contents.

SHOW RESOURCE PLAN plan_name;

SHOW RESOURCE PLAN demo_plan;

Lists all resource plans.

SHOW RESOURCE PLANS;

SHOW RESOURCE PLANS;