Each row of the output table contains a burst interval. The following table describes the columns of the output table. Columns copied from input_table appear in the same order in the output table.
| 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) | Copied from input_table. |
| 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) | Copied from input_table. |
| 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 | Copied from input_table. |
| burst_start | 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 burst interval. |
| burst_end | 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 burst interval. |
| burst_duration | DOUBLE PRECISION | Contains the duration of the burst interval: burst_end - burst_start |
| accumulate_column | Any | Copied from input_table only if specified by the Accumulate argument. Typically, one accumulate_column is a row identifier, such as 'id'. |