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

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

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;