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

Teradata Vantageā„¢ NewSQL Engine Release Summary

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Release Notes
Publication ID
English (United States)
Last Update

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.