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.