Advanced SQL Engine | Teradata Vantage - 17.05 - Advanced SQL Engine Analytic Functions Overview - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K

Advanced SQL Engine (was NewSQL Engine) analytic functions are specifically for analyzing data. Data can include clickstreams, financial transaction data, and user interaction data.

Function Name Description
Antiselect (SQL Engine) AntiSelect returns all columns except those specified.
Attribution (SQL Engine) Calculates attributions with a wide range of distribution models. Often used in web-page analysis.
DecisionForestPredict (SQL Engine) Uses the model file output by Machine Learning Engine (ML Engine) DecisionForest function to analyze the input data and make predictions.
DecisionTreePredict (SQL Engine) Uses the model file output by ML Engine DecisionTree function to analyze the input data and make predictions.
GLMPredict (SQL Engine) Uses the model file output by ML Engine GLM function to analyze the input data and make predictions.
MovingAverage (SQL Engine) Computes average values in a series.
NaiveBayesPredict (SQL Engine) Uses the model file output by ML Engine Naive Bayes Classifier function to analyze the input data and make predictions.
NaiveBayesTextClassifierPredict (SQL Engine) Uses the model file output by ML Engine NaiveBayesTextClassifierTrainer function to analyze the input data and make predictions.
NGramSplitter (SQL Engine) Tokenizes (splits) an input stream and emits n multigrams, based on specified delimiter and reset parameters. Useful for sentiment analysis, topic identification, and document classification.
nPath® (SQL Engine) Performs regular pattern matching over a sequence of rows from one or more inputs.
Pack (SQL Engine) Compresses data in multiple columns into a single packed data column.
Sessionize (SQL Engine) Maps each click in a clickstream to a unique session identifier.
StringSimilarity (SQL Engine) Calculates the similarity between two strings, using the specified comparison method.
SVMSparsePredict (SQL Engine) Uses the model file output by ML Engine SVMSparse function to analyze the input data and make predictions.
Unpack (SQL Engine) Expands data from a single packed column to multiple unpacked columns.

Advanced SQL Engine analytic functions have corresponding ML Engine functions. The syntax of corresponding functions may differ, but given the same inputs and syntax element values, they produce the same results (with the minor exceptions noted in specific functions).

Most Advanced SQL Engine analytic functions do not support column ranges, as many of their corresponding ML Engine functions do.

To execute ML Engine functions on Teradata Vantage™ , contact your Teradata Support representative.

More Information

Topic Reference
ML Engine functions Teradata Vantage™ Machine Learning Engine Analytic Function Reference, B700-4003
Aster Analytics functions Teradata Aster® Analytics Foundation User Guide, B700-1022
Installing model files output by ML Engine functions on Advanced SQL Engine Teradata Vantage™ User Guide, B700-4002