CREATE RESOURCE PLAN

Using this command, you create a resource plan in the disabled state.

CREATE RESOURCE PLAN syntax

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

    The name of a new resource plan

  • number

    An integer

  • name

    The name of a resource plan you want to copy to create the new plan

CREATE RESOURCE PLAN example

CREATE RESOURCE PLAN plan2 LIKE plan1

This command makes a copy of plan1 named plan2.

CREATE RESOURCE PLAN description

You can use query parallelism settings to validate that the resource plan executes queries using parallel processing. When the resource plan is applied to the cluster, Hive validates the sum of all query parallelism values specified for all the pools included in the plan. As administrator, you can use the fixed, total query parallelism figure, as determined by physical cluster size or other limitations, without manually verifying the sum of the pools. If the hive.metastore.wm.default.pool.size configuration value is greater than 0 (the default is 4), a pool named default is created in the new plan. All queries go to the default pool. The pool is set to take 100% of the cluster, and query parallelism is set to plan parallelism (if specified) or to the configuration value.