Table | Description |
---|---|
input_table | Contains time intervals to burst. |
time_table | [Optional] Contains start and end times of burst intervals. This table lets you use different time intervals and partitions the data accordingly. If you omit this table, you must specify either the TimeInterval or NumPoints argument. |
input_table Schema
Each row contains a time interval to burst.
Column | Data Type | Description |
---|---|---|
start_time_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP | Interval start time. |
end_time_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION,NUMERIC, DATE, TIME, TIME(n), TIMESTAMP, TIMESTAMP(n) | Interval end time. |
target_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, CHARACTER, CHARACTER(n), VARCHAR |
Column to copy to output table.
If SplitCriteria is not 'nosplit', ValueDataType must be DOUBLE PRECISION. |
accumulate_column | Any | [Optional] Column to copy to output table.
Typically, one accumulate_column is a row identifier, such as 'id'. |
time_table Schema
Each row contains the start and end times of a burst interval.
Column | Data Type | Description |
---|---|---|
id | Any | Row identifier. If input_table row i is to be burst into n intervals, time_table has n rows with id value i. |
burst_start_time | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP, TIMESTAMP(n) | Interval start time. |
burst_end_time | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP | Interval end time. |