split_chunk()

Split a large chunk at a specific point in time.

Since 2.18.0

Split a large at a specific point in time. If you do not specify the timestamp to split at, the 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 in two:

  For example, If the duration is, 24 hours, the following command splits chunk_1 into two s 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 to split.
split_at	”any”	NULL	✖	The point at which to split the . Accepts TIMESTAMPTZ for time-based dimensions or INTEGER for integer-based dimensions. If not specified, the is split in half.

Returns

This function returns void.