1.1 - Common Analytic Functions in ML Engine and Advanced SQL Engine - Teradata Vantage

Teradata Vantage™ User Guide

prodname
Teradata Vantage
vrm_release
1.1
created_date
May 2020
category
User Guide
featnum
B700-4002-079K
These analytic functions are available on both ML Engine and Advanced SQL Engine:
  • Antiselect
  • Attribution
  • DecisionForestPredict
  • DecisionTreePredict
  • GLMPredict
  • MovingAvg
  • NaivebayesPredict
  • NaiveBayesTextClassifierPredict
  • NGramSplitter
  • nPath
  • Pack
  • Sessionize
  • StringSimilarity
  • SVMSparsePredict
  • Unpack

They have common syntax and generate similar results. The analytic functions in Advanced SQL Engine are expected to run with better performance because they are native to the database.

To run a function on Advanced SQL Engine, use this syntax:
SELECT * FROM function_name ( ...

See Teradata Vantage™ - Advanced SQL Engine Analytic Functions, B035-1206.

To run a function on ML Engine, you must append "_MLE" to the ML Engine function name specified in ML Engine Analytic Function Mapping:
SELECT * FROM function_name_MLE ( ...
NTree and nPath are exceptions. You must append "@coprocessor" to these function names:
SELECT * FROM nPath@coprocessor ( ...

See Teradata Vantage™ Machine Learning Engine Analytic Function Reference, B700-4003.