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 an integer or a string literal with an integer, optionally followed by unit M (Megabyte), G (Gigabyte), or T (Terabyte). When a unit is not specified, the value is interpreted as Megabyte. You can set the attribute to 'OFF' to disable the limit.
  • 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;