Unsupported Data Types - Teradata VantageCloud Lake

The specified 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 causes an error because the function cannot sort by BLOB:

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