16.10 - Teradata Analytic Functions - Teradata Database

Teradata Analytic Functions

prodname
Teradata Database
vrm_release
15.10
16.10
created_date
November 2017
category
Programming Reference
featnum
B035-1206-151K
Use Teradata analytic functions to analyze ordered data. Ordered data is time series data, such as clickstreams, financial transactions, and online user interactions. Teradata provides the following functions specifically for analyzing ordered data.
Teradata System Analytic Functions
Function Name Description
nPath Performs regular pattern matching over a sequence of rows from one or more inputs.
SESSIONIZE Maps each click in a clickstream to a unique session identifier.

To make these functions accessible, contact your Teradata Support representative.

Online help is available for each of the functions. For more detailed information, type HELP 'function_name' , for example, HELP 'SQL NPATH'.