16.20 - Column Partition Definition - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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 Teradata Database determines which format to use based on the width of the column partition value.

As a general rule, Teradata Database 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.