Field 5 - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Variable length.

Maximum length: 56,350 bytes.

Contains the following table column descriptors:
  • Internal ID of the first column in the table.
  • Number of varying length columns in the table.
  • Number of presence bits in each row. The upper limit for the number of presence and compress bits per row is 89,991.
  • Flag to indicate whether the table header is thin or fat. Used to determine whether the compressed value offsets list contains actual addresses or must be left-shifted to extract actual addresses.
  • Compression flag. Specifies whether the table has compressible columns or not.
  • Offset in the row to the presence bit array. Presence octet locations are determined by dividing the presence bit position by 8.
  • Offset in the row to the first byte past the presence bit array.
  • Number of columns in the table.
  • Index into the field descriptor array to the first compressible column. If no columns are compressed, then the value points to the first varying length column in the row.
  • Offset from the beginning of the row to the first optional (varying or compressible) data.
  • Index of the field descriptor for the first physical column in the row.
  • Field 5 type:
    • Table descriptor with row hash and unique rowID.
    • Index descriptor with row hash and unique rowID in the index.
    • Table descriptor with a partitioned rowID.
    • Index descriptor with a partitioned rowID in the index.
  • Row format. Specifies whether current environment is packed64 format or aligned row format.
  • Duplicate rows flag:
    • Dictionary and non-ANSI/ISO tables.
    • ANSI/ISO tables without unique indexes.
    • ANSI/ISO tables with unique indexes.
  • Offset to system code to build rows and to calculate PPI internal partition numbers.
  • Field descriptors array.
  • System code for building rows, including code to calculate partition numbers for the rows of row-partitioned tables. The row-partition-related system code is stored after the Field 5 descriptors, and immediately before the compressed values, if any have been defined.