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::=
alter_consumer_group::=
memory_size::=
drop_consumer_group::=
alter_user_set_consumer_group::=
alter_role_set_consumer_group::=
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';