Rules for the MODIFY Options for Character Partitioning - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

The rules for the MODIFY options for non-character partitioning in General Rules for the MODIFY PRIMARY Clause and Rules for the MODIFY For Multilevel Partitioning 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:
  • You can specify a partitioning expression that involves character or graphic comparisons such as =, >, ≤, BETWEEN, or LIKE.
  • A character row partitioning expression cannot specify Kanji1 or 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#L n
    • Set operators
    • Subqueries