Table Aliases and Syntax Elements in Function Error Messages | Teradata Vantage - Table Aliases and Syntax Elements in Error Messages - 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 (_).