Row Structure for Subrows (ROW Format) - Teradata VantageCloud Lake

A column partition that has ROW format is represented as a series of subrows, where each subrow contains a single column partition value of the column partition. Subrows have the same format as regular rows with the following exceptions:

• A regular row contains all the column values of a table row, while a subrow contains only a subset of the column values of a table row (that is, a column value for each of the columns in the column partition).
• The internal partition number of the row ID of a regular row does not indicate a column partition because regular rows are not column-partitioned.

  The internal partition number of the row ID of a subrow indicates its column partition number.