Considerations - Teradata Vantage
Teradata® Vantage User Guide
- Product
- Teradata Vantage
- Release Number
- 1.0
- Published
- January 2019
- Language
- English (United States)
- Last Update
- 2020-03-11
- dita:mapPath
- hfp1506029122470.ditamap
- dita:ditavalPath
- hfp1506029122470.ditaval
- dita:id
- B700-4002
- lifecycle
- previous
- Product Category
- Teradata Vantage
- An alias name is required for the overall function invocation. For details, see Query Output Alias in Limitations.
- Table alias names are required for table_input when there are multiple ON clauses.
- Function alias names must correspond to the documented input name for the function. For more information, see
Teradata® Vantage Machine Learning Engine Analytic Function Reference, B700-4003 and Function Alias.
- The USING keyword is required at the start of the function argument section.
- Output tables must be prefaced with OUT TABLE and the alias as required by the syntax of the specific function. For specific function syntax, see
Teradata® Vantage Machine Learning Engine Analytic Function Reference, B700-4003.
- Input specified with an ON clause must include any required PARTITION BY, DIMENSION, or ORDER BY clause. For specific function syntax, see
Teradata® Vantage Machine Learning Engine Analytic Function Reference, B700-4003.
- The SQL identifier must not be a Teradata SQL Engine reserved word. Teradata SQL Engine restricted words can be located by using the SELECT * FROM SYSLIB.SQLRestrictedWords command. For information on this command, see
Teradata® Database SQL Fundamentals, B035-1141. If an identifier is a reserved keyword, it must be enclosed in double quotes.
- Some Teradata ML Engine functions create temporary tables for internal processing. The distribution key (partition key) column of such tables is decided based on function arguments specified by the user. The data type of such columns must belong to SQL group DISTRIBUTIONTYPE. The following data types belong to this group:
- INTEGER
- SMALLINT
- BIGINT
- NUMERIC(p,s)
- DECIMAL(p,s)
- VARCHAR(n)