Table Aliases and Syntax Elements in Error Messages - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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 (_).