ALTER POOL
You can use ALTER POOL to modify query pool properties, add triggers, and remove triggers.
Syntax
ALTER POOL plan_name.path [ SET {property=value, ... } | UNSET { property, ... } ]
ALTER POOL plan_name.path [ ADD | DROP ] TRIGGER name- plan_name.path
- The resource plan name and hierarchy of query pool names, in dot notation
- plan_name.path
- The resource plan name and hierarchy of query pool names in dot notation
- property
- The name of a query pool property to remove or to assign a value
- value
- The property setting
- name
- The name of a trigger
Query pool properties
The ALTER POOL command supports the following properties:
- ALLOC_FRACTION
The proportion of the Hive LLAP cluster allocated to a pool. A decimal value.
- QUERY_PARALLELISM
The maximum parallel queries allowed in a pool. An integer value.
- SCHEDULING_POLICY
Determines the resource allocation of queries in a pool. Valid scheduling policy values are: 'default'; 'fair', which allocates an equal share of resources on the cluster to each query; or 'fcfs', which allocates all resources to the query started earliest.
Example
ALTER POOL rp1.pool1 ADD TRIGGER slow_query;