- TimeColumn
- Specify the names of the InputTable columns that contain the start and end times of the time interval to be burst.
- TimeInterval
- [Optional] Specify exactly one of TimeIntervalTable, TimeInterval, or NumPoints.
- TargetColumns
- Specify the names of InputTable columns to copy to the output table.
- TimeDataType
- [Optional] Specify the data type of the output columns that correspond to the input table columns that TimeColumn specifies (start_time_column and end_time_column).
If you omit this syntax element, the function infers the data type of start_time_column and end_time_column from the input table and uses the inferred data type for the corresponding output table columns.
If you specify this syntax element, the function can transform the input data to the specified output data type only if both the input column data type and the specified output column data type are in this list:- INTEGER
- BIGINT
- SMALLINT
- DOUBLE PRECISION
- NUMERIC
- NUMERIC(n[,m])
- ValueDataType
- [Optional] Specify the data types of the output columns that correspond to the input table columns that TargetColumns specifies.
If you omit this syntax element, the function infers the data type of each target_column from the input table and uses the inferred data type for the corresponding output table column.
If you specify ValueDataType, it must be the same size as TargetColumns. That is, if TargetColumns specifies n columns, ValueDataType must specify n data types. For i in [1, n], value_column_i has value_type_i. However, value_type_i can be empty; for example:
TargetColumns ('c1', 'c2', 'c3') ValueDataType (INTEGER, ,VARCHAR)
If you specify this syntax element, the function can transform the input data to the specified output data type only if both the input column data type and the specified output column data type are in this list:- INTEGER
- BIGINT
- SMALLINT
- DOUBLE PRECISION
- NUMERIC
- NUMERIC(n[,m])
- StartTime
- [Optional] Specify the start time for the time interval to be burst.
- EndTime
- [Optional] Specify the end time for the time interval to be burst.
- NumPoints
- [Optional] Specify exactly one of TimeIntervalTable, TimeInterval, or NumPoints.
Specify the number of data points in each burst time interval. This value must be an INTEGER.
- ValuesBeforeFirst
- [Optional] Specify the values to use if start_time is before start_time_column. Each of these values must have the same data type as its corresponding target_column. Values of data type VARCHAR are case-insensitive.
- ValuesAfterLast
- [Optional] Specify the values to use if end_time is after end_time_column. Each of these values must have the same data type as its corresponding target_column. Values of data type VARCHAR are case-insensitive.
- SplitCriteria
- [Optional] Specify how to split target_column values into subintervals:
Option Description 'nosplit' (Default) The function assigns to each subinterval the sum of the values in the rows in that interval. See Burst Example: TimeInterval, SplitCriteria ('nosplit') and Burst Example: TimeIntervalTable File (where SplitCriteria defaults to 'nosplit'). 'proportional' The function does the following: - Determines the number of subintervals for each row.
- Divides the target_column values evenly across all subintervals.
- Adds the contributions from all rows to each subinterval.
See Burst Example: TimeInterval, SplitCriteria ('proportional').
'random' The function does the following: - Determines the number of subintervals for each row.
- Draws xi for each subinterval i.
The distribution is uniform on (0,1). The value assigned to each subinterval except the last is:
where Value is the value of the input table for that row.
The value assigned to the last subinterval is:
- Adds the contributions from all rows to each subinterval.
'gaussian' The function does the following: - Determines the number of subintervals for each row.
- Draws xi for each subinterval i.
The distribution is a standard normal distribution. The value assigned to each subinterval except the last, and the value assigned to the last subinterval, are calculated with the equations shown for 'random'.
- Adds the contributions from all rows to each subinterval.
See Burst Example: TimeInterval, SplitCriteria ('gaussian').
'poisson' Use 'poisson' only if the means of each target_column is nonnegative. For data sets with an expected mean value greater than 40, Teradata recommends selecting 'gaussian' instead of 'poisson'. The performance of the 'poisson' option decreases as the mean of the data set increases.
The function does the following:- Determines the number of subintervals for each row.
- Draws xi for each subinterval i.
The distribution is a Poisson distribution with mean:
Value / number_of_subintervals
Each subinterval is assigned this value:
- Adds the contributions from all rows to each subinterval.
- Seed
- [Optional] Use only if SplitCriteria is 'random' or 'gaussian'. Specify the value for initializing the random number generator the algorithm uses for repeatable results.For repeatable results, use both the Seed and UniqueID syntax elements. For more information, see Nondeterministic Results and UniqueID Syntax Element.
Default: 0
- Accumulate
- [Optional] Specify the names of InputTable columns (other than those specified by TimeColumn and TargetColumns) to copy to the output table.