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.
  • time_in_seconds is an integer between 1 and 999999. You can set the attribute to 0 to disable the limit.

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',
 QUERY_TIMEOUT = 60,
 IDLE_TIMEOUT = 3600;
ALTER CONSUMER GROUP CEO SET
 PRECEDENCE = '1000',
 CPU_WEIGHT = '800';
 
ALTER CONSUMER GROUP BI_TEAM SET
 PRECEDENCE = '800',
 CPU_WEIGHT = '500',
 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',
 QUERY_TIMEOUT = 60,
 IDLE_TIMEOUT = 3600;
DROP CONSUMER GROUP CEO;
 
DROP CONSUMER GROUP BI_TEAM;
 
DROP CONSUMER GROUP TEST_TEAM;