Teradata Database Message 5746 - 17.10 - 5746 - 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 for level %VSTR is not valid; partitioning expressions for multi-level partitioning must be RANGE_N or CASE_N functions.
Explanation
For a CREATE TABLE or ALTER TABLE statement, if more than one parti-tioning expression is specified in the PARTITION BY clause, each such partitioning expression must consist solely of either a RANGE_N or CASE_N function. The partitioning expression at the specified level is neither solely a RANGE_N nor CASE_N function. Note that it is not required that the parti-tioning expressions be all of one form or the other (some could be RANGE_N functions and others CASE_N functions).
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 multi-level partitioned primary index rules and re-submit the request.