17.05 - column_partition_definition - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The format to be used for the storage of a column partition. A column partition consists either of a series of containers or a series of subrows.

You can only specify this option for a column-partitioned table.

If you do not specify either COLUMN or ROW, then Vantage determines which format to use based on the width of the column partition value.

As a general rule, Vantage assigns COLUMN format to narrow column-valued partitions and ROW format to wide column-valued partitions.

The system autocompresses data as physical rows that are inserted into a column partition of a column-partitioned table unless there are no applicable autocompression methods that reduce the size of the physical row or you specify NO AUTO COMPRESS.