Syntax Elements
- COLUMNS
- The output columns of the response wavelets or ART (analytic result table) created by the analytic function. Most columns can be renamed, however the output series row index is always named ROW_I. Matrix row and column are always named ROW_I and COLUMN_I, respectively. The format is as follows:
COLUMNS ( original-name1 AS new-name1 [ , original-name2 AS new-name2 ... ] )
- INTO VOLATILE ART
- The INTO VOLATILE ART clause creates a non-permanent (volatile) ART and places the result series or result matrices in the table.
- INTO ART
- The INTO ART clause creates a permanent ART and puts result series or result matrices in the table.
- analytic-function-name
- The analytic function to run.
- logical_data_type_reference_list
- The type data and specifications for the analytic function, such as series, matrix or ART.
- FUNC_PARAMS
- The input parameters that are specific to the analytic function.
- INPUT_FMT
- INPUT_FMT controls how input logical data types are handled by the function. Not available for all functions. Valid parameters are ONE2ONE, MANY2ONE, and MATCH.
- [Optional] OUTPUT_FMT
- OUTPUT_FMT controls the number of primary series and the number of secondary series, and determines how the series are matched together. It is not available for all functions.
- MAP
- The name of a Teradata sparse map to apply to an output ART table or output spool file created during the query.