TD_Unpivoting Usage Notes - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
The following are usage considerations for the TD_Unpivoting function:
  • TD_Unpivoting function is aimed to be used in conjunction with other inDB analytic functions, in contrast to SQLE Unpivot.
  • The function returns N*M output rows, if there are N rows in the input table and M features (columns). Due to this large output size, expect the query to run longer as the number of rows increases in the InputTable. The output size is limited by the user spool space, which in turn, limits the size or scalability of the input.
  • With InputTypes as false, do note combine BLOB/CLOB data type columns with any other data type columns.