16.20 - Analytic Functions on Teradata Database and Aster Database - 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)

The following table summarizes the differences between analytic functions on Teradata Database and Aster Database.

Teradata Database Analytic Function Aster Database Analytic Function
PARTITION BY clause lets you specify a column by its position, an integer. PARTITION BY 1 partitions rows by column 1. PARTITION BY clause accepts only column names. PARTITION BY 1 causes the function to process all rows on a single worker node.
For table operator output, an alias is required. For function output, an alias is optional.
To specify function syntax elements, you must use a USING clause. Function syntax does not include USING clause.
Function syntax elements do not support column ranges. Function syntax elements support column ranges.