17.05 - Analytic Functions on Advanced SQL Engine and Aster Database - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K

The following table summarizes the differences between analytic functions on Advanced SQL Engine and Aster Database.

Advanced SQL Engine 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.