Teradata Database Message 5716 - 5716 - Analytics Database - Teradata Vantage

Message

PARTITION BY RANGE_N defines more than %VSTR partitions.

Explanation

For a CREATE TABLE or ALTER TABLE statement, a partitioning expression that is the RANGE_N function with INTEGER data type must not define more than 2147483647 partition (including the NO RANGE, UNKNOWN, and NO RANGE OR UNKNOWN partitions if specified). In this case, the value for VSTR is "2147483647". Note that, for 2-byte single-level partitioning, the RANGE_N function cannot not define more than 65533 range partitions (otherwise, it would be 8-byte partitioning). For 2-byte single-level partitioning, the total number of partitions defined can be up to 65535 if both the NO RANGE and UNKNOWN partitions are defined. For a CREATE TABLE or ALTER TABLE statement, a partitioning expression that is the RANGE_N function with BIGINT data type must not define more than 9223372036854775805 range partitions (not including the NO RANGE, UNKNOWN, and NO RANGE OR UNKNOWN partitions). In this case, the value for VSTR is "9223372036854775805 range". Note that, for single-level partitioning, the total number of partitions defined for such a partitioning expression can be up to 9223372036854775807 if both the NO RANGE and UNKNOWN partitions are specified.

Generated By

RES modules.

For Whom

End User.

Notes

Other limits may be exceeded (such as the limit on the number of combined partitions) 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.