Teradata Database Message 5748 - 5748 - 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 number of partitions for level %VSTR is less than two.
Explanation
For a CREATE TABLE, if more than one partitioning expression is specified in the PARTITION BY clause, the number of partitions at each level must be at least two. For an ALTER TABLE statement, if more than one new partitioning expression is specified in the PARTITION BY clause or partitioning expressions of a multi-level partitioned table are altered, the number of resulting partitions at each level must be at least two.
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 re-quest.