Teradata Database Message 5715 - 5715 - Analytics Database - Teradata Vantage

Message

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.

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.