Teradata Database Message 5690 - 5690 - Analytics Database - Teradata Vantage

Message

LOBs are not allowed to be hashed.

Explanation

LOBs are not allowed to be hashed. Some of the scenarios where hashing is required on the selected columns are distinct set operations (UNION, INTERSECT and MINUS), queries with DISTINCT or NORMALIZE clause, etc.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Remove the LOB column and resubmit.