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

Teradata Vantage™ User Guide

Product
Teradata Vantage
Release Number
1.1
Published
May 2020
Language
English (United States)
Last Update
2020-05-28
dita:mapPath
ioz1543440393126.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4002
lifecycle
previous
Product Category
Teradata Vantage
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.