CREATE COMPUTE GROUP Examples | VantageCloud Lake - CREATE COMPUTE GROUP Examples - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Compute Group is Created Successfully

This statement creates the Shipping compute group using the Standard query strategy. 

CREATE COMPUTE GROUP Shipping
  USING 
    Query_Strategy ('STANDARD');

Compute Group Statements Fail

This statement fails due to duplicate names in the custom clause list.

CREATE COMPUTE GROUP ShippingAnalytics
USING Query_Strategy('STANDARD')
Query_Strategy('ANALYTICS');
*** Failure 9900 Duplicated names specified in custom clause list.

This statement fails due to invalid group-level policy.

CREATE COMPUTE GROUP ShippingAnalytics
USING Query_Strategy('STANDARD2');
*** Failure 4825: Compute Manager error 400: Invalid Compute Group-level policy.

This statement fails because it tries to create a compute group that already exists.

CREATE COMPUTE GROUP Shipping
USING 
    Query_Strategy('STANDARD');
*** Failure 4822 Compute Group 'Shipping' already exists.