16.20 - Teradata Analytic Functions for Release 16.20 Update 2 - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Release Notes

Teradata analytic functions analyze ordered data. Ordered data is time series data, such as clickstreams, financial transactions, and online user interactions. The following Teradata analytic functions are new for Teradata Database 16.20 Feature Update 2:

Function Description
Antiselect Returns all columns except those specified.
MovingAverage Computes average values in a series.
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.
Pack Compresses data in multiple columns into a single packed data column.
StringSimilarity Calculates the similarity between two strings, using the specified comparison method.
Unpack Expands data from a single packed column to multiple unpacked columns.

Additional Information

Teradata Vantageā„¢ - NewSQL Engine Analytic Functions, B035-1206.