Example: Using an IN List that Contains Multiple Columns with an Incompatible Data Type - Teradata VantageCloud Lake

In this example, the star1p table is altered to contain a new column Q401Sales with a VARCHAR(20) data type. The Q101Sales column is an INTEGER data type, and the Q401Sales is VARCHAR.

The INTEGER and VARCHAR data types are not compatible.

SELECT *
FROM star1p UNPIVOT (measure_value  FOR  yr_qtr_measure IN
(Q101Sales, Q401Sales)) Tmp;

Error 9134 Failure in TD_Unpivot contract function. Error determining column type of value columns.