Apache Hive workload management commands
Also available as:
PDF

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;