CONSUMER GROUP

Purpose

Use these statements to create, alter, or drop consumer groups.

Prerequisite

You need to have the system privilege MANAGE CONSUMER GROUPS.

Syntax

create_consumer_group::=

CREATE CONSUMER GROUP syntax diagram

alter_consumer_group::=

ALTER CONSUMER GROUP syntax diagram

memory_size::=

memory size

drop_consumer_group::=

DROP CONSUMER GROUP syntax diagram

alter_user_set_consumer_group::=

ALTER USER SET CONSUMER GROUP syntax diagram

alter_role_set_consumer_group::=

ALTER ROLE SET CONSUMER GROUP syntax diagram

Usage Notes

  • Details about consumer groups is available in Resource Manager section.
  • memory_size can be either an unsigned integer or a string literal with an unsigned integer, optionally followed by a single-character unit symbol M (megabyte), G (gigabyte), or T (terabyte). There must be no space between the value and the unit symbol. For example: '10G' is valid, but not '10GB' or '10 G'. If a unit is not specified, the value is interpreted as megabyte. To disable the limit, set the attribute to 'OFF'.
  • The weight of a consumer group has to be between 1 and 1000.

Examples

 

CREATE CONSUMER GROUP CEO WITH
 PRECEDENCE = 1000,
 CPU_WEIGHT = 900;
 
CREATE CONSUMER GROUP BI_TEAM WITH
 PRECEDENCE = 900,
 CPU_WEIGHT = 500,
 GROUP_TEMP_DB_RAM_LIMIT = '200G',
 USER_TEMP_DB_RAM_LIMIT = '100G';
 
CREATE CONSUMER GROUP TEST_TEAM WITH
 PRECEDENCE = 800,
 CPU_WEIGHT = 100,
 GROUP_TEMP_DB_RAM_LIMIT = '10G',
 SESSION_TEMP_DB_RAM_LIMIT = '5G';
ALTER CONSUMER GROUP CEO SET
 PRECEDENCE = 1000,
 CPU_WEIGHT = 800;
 
ALTER CONSUMER GROUP BI_TEAM SET
 PRECEDENCE = 900,
 CPU_WEIGHT = 400,
 GROUP_TEMP_DB_RAM_LIMIT = '200G',
 USER_TEMP_DB_RAM_LIMIT = '100G';
 
ALTER CONSUMER GROUP TEST_TEAM SET
 PRECEDENCE = 800,
 CPU_WEIGHT = 150,
 GROUP_TEMP_DB_RAM_LIMIT = '10G',
 SESSION_TEMP_DB_RAM_LIMIT = '5G';
DROP CONSUMER GROUP CEO;
 
DROP CONSUMER GROUP BI_TEAM;
 
DROP CONSUMER GROUP TEST_TEAM;