16.20 - Unsupported Data Types - Advanced SQL Engine - Teradata Database

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;