16.20 - Teradata Vantage NewSQL Engine Analytic Functions Overview - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

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

Function Name Description
Antiselect AntiSelect returns all columns except those specified.
Attribution Calculates attributions with a wide range of distribution models. Often used in web-page analysis.
DecisionForestPredict Uses the model file output by Teradata® Machine Learning Engine (ML Engine) DecisionForest function to analyze the input data and make predictions.
DecisionTreePredict Uses the model file output by ML Engine DecisionTree function to analyze the input data and make predictions.
GLMPredict Uses the model file output by ML Engine GLM function to analyze the input data and make predictions.
MovingAverage Computes average values in a series.
NaiveBayesPredict Uses the model file output by ML Engine Naive Bayes Classifier function to analyze the input data and make predictions.
NaiveBayesTextClassifierPredict Uses the model file output by ML Engine NaiveBayesTextClassifierTrainer function to analyze the input data and make predictions.
NGramSplitter

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® Performs regular pattern matching over a sequence of rows from one or more inputs.
Pack Compresses data in multiple columns into a single packed data column.
Sessionize Maps each click in a clickstream to a unique session identifier.
StringSimilarity

Calculates the similarity between two strings, using the specified comparison method.

SVMSparsePredict Uses the model file output by ML Engine SVMSparse function to analyze the input data and make predictions.
Unpack

Expands data from a single packed column to multiple unpacked columns.

NewSQL 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 NewSQL 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 NewSQL Teradata Vantage™ User Guide, B700-4002