Error Conditions - Analytics Database - Teradata Vantage

SQL Date and Time Functions and Expressions
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
cpk1628111786971.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
pxz1544241488545
lifecycle
latest
Product Category
Teradata Vantage™

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.