The Burst function has two input tables:
- input_table
- time_table [Optional]
If you omit time_table, you must specify either the TimeInterval or NumPoints argument.
Each row of input_table contains a time interval to be burst. The following table describes the input_table columns that you can specify in function arguments.
Column | Data Type | Description |
---|---|---|
start_time_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) | Contains the start time of the time interval to be burst, specified by the TimeColumn argument. |
end_time_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) | Contains the end time of the time interval to be burst, specified by the TimeColumn argument. |
value_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), CHARACTER, CHARACTER(n), CHARACTER VARYING, CHARACTER VARYING(n), or VARCHAR | Column to be copied to the output table, specified by the ValueColumns argument. |
accumulate_column | Any | Optional. Column to be copied to the output table, specified by the Accumulate argument. Typically, one accumulate_column is a row identifier, such as 'id'. |
Each row of time_table contains the start and end times of a burst interval. The following table describes the columns of time_table.
Column | Data Type | Description |
---|---|---|
id | Any | Contains the identifier of the input_table row with the time interval to be burst. If input_table row i is to be burst into n burst intervals, time_table has n rows with the id value i. |
burst_start_time | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) | Contains the start time of a burst interval. |
burst_end_time | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) | Contains the end time of a burst interval. |