Teradata Database Message 5957 - 17.10 - 5957 - 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
Warning: An existing partitioning expression is nondeterministic.
Explanation
During an ALTER TABLE that defines new partitioning expressions using DROP/ADD ranges or an ALTER TABLE with REVALIDATE PRIMARY option, an existing partition expression was found to be nondeterministic. If so, queries that are executed with partition elimination may get wrong results and rows may be improperly partitioned. This warning indicates the table was created in an earlier release with a partitioned primary index where one or more of the partitioning expressions were nondeter- ministic. Note that nondeterministic partitioning expressions are not supported (a partitioning expression must be deterministic) but an error was not reported in all cases in earlier releases.
Generated By
Opt.
For Whom
End User and System Support Representative.
Notes
This is a warning but it is important to follow the instructions in the following remedy to make sure the rows are correctly partitioned.
Remedy
It is recommended that you contact your System Support Representative to assist in applying this remedy. Recreate the table with deterministic partitioning and repopulate. The rows for the original table can be insert-selected from the original table into the new table or if there is not enough space on the system, the new table may be repopulated from a backup. If you run all maintenance, queries, and ALTER TABLE statements for this table in the same session time zone, session collation and session mode (ANSI or BT/ET), rows may be okay in the table and you may decide to delay applying this remedy; however, it is highly recommended to apply the remedy at the soonest opportunity.