1.1 - 8.10 - Functions with Both ML Engine and Advanced SQL Engine Versions - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
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