1.0 - 8.00 - Functions with Both ML Engine and Teradata SQL Engine Versions - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
May 2019
Content Type
Programming Reference
Publication ID
English (United States)

Some functions have both ML Engine and SQL Engine (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 "@coprocessor" to the function name:

SELECT * FROM function_name@coprocessor ( ...

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
Teradata Vantage™ - Advanced SQL Engine Analytic Functions, B035-1206