15.00 - Rules for the MODIFY and MODIFY PRIMARY INDEX Options for Character Partitioning - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Rules for the MODIFY and MODIFY PRIMARY INDEX Options for Character Partitioning

The rules for the MODIFY and MODIFY PRIMARY INDEX options for non‑character partitioning is documented in “General Rules for the MODIFY and MODIFY PRIMARY INDEX Clauses” on page 85) and “Rules for the MODIFY, MODIFY PRIMARY INDEX, and MODIFY Partitioning Option For Multilevel Partitioning” on page 106 also apply to character partitioning and to the character row partitioning levels of a column‑partitioned table or join index.

The following rules are specific to character row partitioning levels in both row‑partitioned and column‑partitioned tables and join indexes. In the case of column‑partitioned tables and join indexes, the rules only apply to the character row partitioning levels of a multilevel partitioning expression.

  • You can specify a partitioning expression that involves character or graphic comparisons such as =, >, <=, BETWEEN, or LIKE.
  • A character row partitioning expression cannot specify Kanji1or KanjiSJIS columns or constant expressions.
  • A character row partitioning expression must be based on one or more columns from the table or deterministic expressions based on the columns from the table or join index the partitioning expression is written for.
  • The expressions and referenced columns in the specification of the character partitioning expression must not have CLOB data types.
  • The expressions specified in a character row partitioning expression must not contain any of the following functions.
  • Aggregate functions
  • Built‑in functions
  • Grouped row OLAP functions
  • UDFs of any kind
  • HASHAMP function
  • HASHBAKAMP function
  • RANDOM function
  • The expressions specified in a row partitioning expression must not contain any of the following system‑derived columns, operators, or SELECT subqueries.
  • ROWID
  • PARTITION
  • PARTITION#Ln
  • Set operators
  • Subqueries