Teradata Database Message 9373 - 17.10 - 9373 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Specified uniqueness/primary key constraint requires a system-defined join index. Constraint is not allowed on the table.
Explanation
Currently join indexes cannot be created on volatile and temporary tables. Thus a system-defined join index cannot be created on such temporal tables.
Generated By
RES modules.
For Whom
End User.
Notes
None
Remedy
Correct the statement by removing the constraint and resubmit the request.