Teradata Database Message 5747 - 5747 - Analytics Database - Teradata Vantage

Message

The product of the number of partitions at each level exceeds %VSTR.

Explanation

For a CREATE TABLE, if more than one partitioning expression is specified in the PARTITION BY clause, the product of the number of partitions defined by each partitioning expression must not exceed 9223372036854775807. 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 product of the number of partitions defined by each new partitioning expression must not exceed 65535 if the table has a 2-byte partitioning and 9223372036854775807 if the table has 8-byte partitioning.

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.