Teradata Database Message 5730 - 17.10 - 5730 - 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
Invalid DROP RANGE WHERE partition condition for level %VSTR.
Explanation
For an ALTER TABLE statement with a DROP RANGE[#Ln] WHERE clause and a single-level partitioned primary index, a partition conditional expression must be a conditional expression that references the system-derived column PARTITION or PARTITION#L1 (but not both) and no other columns. If the table includes an explicit column named PARTITION, PARTITION may not be used in the conditional expression. If the table includes an explicit column named PARTITION#L1, PARTITION#L1 may not be used in the conditional expression. If the table includes explicit columns named PARTITION and PARTITION#L1, this WHERE form may not be specified. For a multi-level partitioned primary index, a partition conditional expression must be a conditional expression that references the system-derived column PARTITION#Ln where n is the default or specified level of the corresponding DROP RANGE[#Ln] and no other columns. If the table includes an explicit column named PARTITION#Ln, this WHERE form may not be used. Note that the system-derived column PARTITION may not be used in the conditional ex-pression.
Generated By
RES modules.
For Whom
End User.
Notes
None
Remedy
Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the partitioned primary index rules and resubmit the request.