16.20 - Unsupported Data Types - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Ordered analytical functions do not operate on the following data types:

  • CLOB or BLOB data types
  • UDT data types

Note that CLOB, BLOB, or UDT data types are usable inside an expression if the result is a supported data type. For example:

   SELECT
   RANK() OVER 
   (PARTITION BY(CASE WHEN b IS NULL THEN 1 ELSE 0 END) ORDER BY id) 
   FROM btab;

However, the following example results in an error because the function cannot sort by BLOB:

   SELECT
   RANK() OVER 
   (PARTITION BY b ORDER BY id) 
   FROM btab;