Teradata Database Message 9242 - 9242 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
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.