Teradata Database Message 9242 - 17.10 - 9242 - 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
The partitioning expression references a column that is not defined for this table.
Explanation
This error occurs when an attempt is made to CREATE or ALTER a PPI table with referential integrity, and the partitioning expression includes a column belonging to the parent table.
Generated By
OPT modules.
For Whom
System Support Representative.
Notes
None
Remedy
Rewrite the table definition so that the partitioning expression only references columns defined in the table. Partitioning on columns defined in parent tables of referential integrity references is not supported.