split_chunk()

Since 2.18.0

Split a large chunk at a specific point in time. If you do not specify the timestamp to split at, the chunk is split equally.

Samples

• Split a chunk at a specific time:

  CALL split_chunk('chunk_1', split_at => '2025-03-01 00:00');

• Split a chunk in two:

  For example, If the chunk duration is, 24 hours, the following command splits chunk_1 into two chunks of 12 hours each.

  CALL split_chunk('chunk_1');

Arguments

The syntax is:

CALL split_chunk(
    chunk = '<chunk_name>',
    split_at = <split_point>
);

Name	Type	Default	Required	Description
chunk	REGCLASS	-	✔	Name of the chunk to split.
split_at	”any”	NULL	✖	The point at which to split the chunk. Accepts TIMESTAMPTZ for time-based dimensions or INTEGER for integer-based dimensions. If not specified, the chunk is split in half.

Returns

This function returns void.