Complex Types

Complex types such as structures (also known as rows) and arrays are composed of primitive types and sometimes other complex types.

Arrays, rows, and maps can be used with external tables using Parquet data.

One-dimensional arrays and sets of primitive types can be used in Vertica-managed tables (ROS data).

All complex types can be created as literals, for example to use in query expressions.

In This Section