ALTER RESOURCE PLAN
You alter the resource plan status, validate the plan, or change plan properties using this command.
ALTER RESOURCE PLAN syntax
ALTER RESOURCE PLAN name [ DISABLE | ENABLE | ACTIVATE [WITH REPLACE]
ALTER RESOURCE PLAN name [VALIDATE]
ALTER RESOURCE PLAN name [ RENAME TO name2 | SET {property=value, ... } | UNSET {property, ... } ]
- name
The name of the resource plan
- property
The name of the property to remove from the plan or to assign a value
- value
The property setting
- name2
The new name of a plan
ALTER RESOURCE PLAN examples
ALTER RESOURCE PLAN high_concurr_rp RENAME TO name2
ALTER RESOURCE PLAN high_concurr_rp SET DEFAULT POOL=etl_pool, QUERY_PARALLELISM=3
ALTER RESOURCE PLAN high_concurr_rp UNSET QUERY_PARALLELISM=3, DEFAULT POOL = etl_pool
ALTER RESOURCE PLAN description
After you activate a resource plan you altered, Hive minimizes the impact on existing queries. Hive alters the plan properties, triggers, and so on without stopping the cluster. Queued queries might be re-queued.
Hive puts pools having the same path in the old and new plan into the same pool when making the transition. If you delete some pools that were in the old plan from the new plan or if you reduce query parallelism, the queries that are currently running in the affected pools might be killed. If you add new pools, these pools immediately apply to corresponding queries and can result in queries being killed if they exceed the new limits.