1.0 - 8.00 - Column Names - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

The ML Engine does not preserve case when storing identifiers. For example, 'mixedCaseIdentifier' is stored as 'mixedcaseidentifier'. Therefore, when creating tables to input to the ML Engine functions, or specifying names for output columns, give columns names that use only lowercase letters, digits, and underscore (_).

If column names in an existing table have uppercase letters or special characters other than underscore, give those columns aliases that use only lowercase letters, digits, and underscore (_), and use the aliases in the function arguments. For example:

SELECT * FROM DWT (
  ON (SELECT city, period, temp_F AS temp_f, pressure_mbar,
        dewpoint_F AS dewpoint_f FROM ville_climatedata
      ) AS InputTable PARTITION BY 1
  OUT TABLE OutputTable (dwt_coef_table)
  OUT TABLE MetaTable (dwt_meta_table)
  USING
  TargetColumns ('temp_f','pressure_mbar','dewpoint_f')
  SortColumn ('period')
  PartitionColumns ('city')
  Wavelet ('db2')
  WaveletTransformLevel (2)
) AS dwtout;