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

Machine Learning Engine User Guide

Product
Teradata Vantage
Release Number
9.02
9.2.4
9.2.3
2.3.2
1.3
Published
May 2022
Language
English (United States)
Last Update
2022-05-04
dita:mapPath
kaz1597341649653.ditamap
dita:ditavalPath
ehs1594682156756.ditaval
dita:id
B700-4004
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.