15.00 - 5715 PARTITION BY CASE_N defines more than 2147483647 partitions. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5715 PARTITION BY CASE_N defines more than 2147483647 partitions.

Explanation:

For a CREATE TABLE or ALTER TABLE statement, a partitioning expression that is the CASE_N function must not define more than 2147483647 partitions.

Generated By:

RES modules.

For Whom:

End User. DR62813-bessc

Notes:

Other limits will be exceeded (such as the request text size limit) before this limit is exceeded.

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.