1.1 - 8.10 - Table Aliases and Syntax Elements in Error Messages - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

The names of input table aliases (also called correlation names) and output table and other syntax elements in some error messages differ from those in function syntax. For example, the following function call uses the syntax element Dimensions, but the error message calls that syntax element NumDimensions:

SELECT * FROM FFT (
  ON fft_input2 AS InputTable PARTITION BY id1 ORDER BY timestep
  USING
  TargetColumns ('value1')
  Dimensions ('abc')
) AS dt;

Executed as Single statement.  Failed [9134 : HY000] QGInitiatorExportContract: 60104: (f3b61662-3dc3-4ab0-a45d-00000000010d) sdt20816 : ForeignFunctionMeta : MLE_ERR: [Teradata][ASTERJDBCDSII](34) ERROR: SQL-MR function FFT failed: FFT function failed during initialization. NumDimensions must be an integer

The following tables map the names in error messages to the names in function syntax.

Aliases in "Alias in Error Message" columns may differ from those in error messages with respect to case and use of the underscore character (_).