TD_SEQUENCED_COUNT Error Conditions - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
The table function returns an error in the following cases:
  • The function invocation does not include a LOCAL ORDER BY clause that includes all of the grouping columns and the Period column.
  • The function invocation does not include a HASH BY clause with at least one of the grouping columns.
  • The HASH BY clause includes the Period column or other columns that are not part of the grouping columns.
  • The function was invoked without a RETURNS clause or the columns specified in the RETURNS clause do not match the input columns or are not in the same order as the input columns.