1.1 - 8.10 - Functions with Both ML Engine and Advanced SQL Engine Versions - 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)

Some functions have both ML Engine and Advanced SQL Engine versions, which have different syntax.

If a function has both versions, a query that starts this way calls the Advanced SQL Engine version:

SELECT * FROM function_name ( ...

To call the ML Engine version instead of the Advanced SQL Engine version, append "_MLE" to the function name:

SELECT * FROM function_name_MLE ( ...
To call ML Engine functions nPath and NTree, use nPath@coprocessor and NTree@coprocessor. To call Advanced SQL Engine function nPath, use nPath.

More Information

Information Document
  • List of ML Engine functions that have Advanced SQL Engine versions
  • Data type mapping between Advanced SQL Engine and ML Engine
Teradata Vantage™ User Guide, B700-4002
  • Advanced SQL Engine syntax
  • Usage notes that apply if you use model tables created using a supported version of Aster Analytics on Aster Database as input to these functions:
    • DecisionTreePredict
    • DecisionForestPredict
    • GLMPredict
    • NaiveBayesPredict
    • NaiveBayesTextClassifierPredict
    • SVMSparsePredict
Teradata Vantage™ - Advanced SQL Engine Analytic Functions, B035-1206