WARM UP COMPUTE GROUP

Description

The WARM UP COMPUTE GROUP statement is used to warm up data in a compute group to improve query performance. The warming operation can either retrieve resources from another compute group or specify particular tables and partitions for warming. The warming operation returns a job ID that can be used to track the status of the warming job.

Syntax

WARM UP COMPUTE GROUP <destination_compute_group_name> WITH COMPUTE GROUP <source_compute_group_name>;

WARM UP COMPUTE GROUP <destination_compute_group_name> WITH <warm_up_list>;

warm_up_list ::= warm_up_item [AND warm_up_item...];

warm_up_item ::= TABLE <table_name> [PARTITION <partition_name>];

Parameters

• destination_compute_group_name: The name of the destination compute group that is to be warmed up.

• source_compute_group_name(Optional) The name of the source cluster from which resources will be warmed up.

• warm_up_list: (Optional) A list of specific items to warm up, which can include tables and partitions.

• table_name: The name of the table is used to warmup.

• partition_name: The name of the partition is used to warmup.

Return Values

• JobId: the id of warm-up job.

Example

1. Warm up a compute group named destination_group_name with a compute group named source_group_name.

   WARM UP COMPUTE GROUP destination_group_name WITH COMPUTE GROUP source_group_name;

2. Warm up a compute group named destination_group with table sales_data and customer_info and partition q1_2024 of table orders .

    WARM UP COMPUTE GROUP destination_group WITH 
        TABLE sales_data 
        AND TABLE customer_info 
        AND TABLE orders PARTITION q1_2024;

Keywords

WARM UP, COMPUTE GROUP, CACHE