Supported Window Types | User-Defined Aggregate Functions | Teradata Vantage - Supported Window Types - Analytics Database - Teradata Vantage

SQL External Routine Programming
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantage™

You can apply a window specification to an aggregate function. The following window types are supported for user-defined aggregate functions.

Window Type Aggregation Group Supported Partitioning Strategy
Reporting window ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING Hash partitioning
Cumulative window
  • ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
  • ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
 Hash partitioning
Moving window
  • ROWS BETWEEN value PRECEDING AND CURRENT ROW
  • ROWS BETWEEN CURRENT ROW AND value FOLLOWING
  • ROWS BETWEEN value PRECEDING AND value FOLLOWING
  • ROWS BETWEEN value PRECEDING AND value PRECEDING
  • ROWS BETWEEN value FOLLOWING AND value FOLLOWING
 Hash partitioning and range partitioning