Teradata Database Message 5714 - 17.10 - 5714 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Invalid partitioning expression for PARTITION BY.
Explanation
A partitioning expression must be deterministic and based on one or more columns in the table (these columns are called the partitioning columns). Conditional expressions in a partitioning expression which compare character data must not contain columns or expressions using CHARACTER SET KANJI1 or KANIJSJIS. Expressions and columns referenced in a partitioning expression must not have BLOB, CLOB, or user-defined data types. It must not contain built-in functions (such as TIME, ACCOUNT, etc.) other than DATE, CURRENT_DATE, and CURRENT_TIMESTAMP. It must also not contain user-defined functions, the RANDOM function, aggregate functions (such as COUNT, AVERAGE, etc.), grouped-row OLAP functions (such as MAVG, MSUM, etc.), attribute functions (BYTES, CHARACTERS, FORMAT, etc.), HASHAMP function, or HASHBAKAMP function. ROWID system-derived columns, PARTITION[#Ln] system-derived columns , set operators, and subqueries are not allowed. Certain uses of EXTRACT, CAST, Teradata conversion, and AT clause are also not allowed when they are not deterministic. The partitioning expression may contain HASHROW and HASHBUCKET functions.
Generated By
RES/OPD/GEN 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.