Reading Arrays

Columns in the Parquet format can contain complex data types. One complex data type is the array, which stores an ordered list of elements of the same type. For example, an address column could use an array of strings to store multiple addresses that an individual may have, such as [668 SW New Lane, 518 Main Ave, 7040 Campfire Dr]. Vertica supports reading arrays of primitive types only for external tables backed by data in the Parquet format.