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;