Limitations - Teradata Vantage

The following are ML Engine function execution limitations:

• The length of a query output alias must not exceed 25 characters. For example, this alias causes an error:

  SELECT * FROM KMeans (
    ON (SELECT * FROM kmeansample) as InputTable
    USING
    OutputTable ('kmeanssample_centroid')
    NumberK ('3')
    Threshold ('0.01')
    MaxIterNum ('10')
  ) AS Long_Function_Name_Alias_Example;

• In the output_table clause (see output_table in ML Engine Analytic Function Execution SQL Syntax), table_name must not have an embedded double quote or an embedded period.