Reading Complex Types from ORC Files

ORC files can contain complex types, including structs, arrays, maps, and unions. Vertica handles ORC complex types in the following ways:

• Structs are supported in external tables if all fields are primitive types or other structs of primitive types.
• One-dimensional arrays of primitive types are supported for external and internal tables.
• Maps, multi-dimensional arrays, and arrays and structs containing complex types can be defined in external tables but cannot be queried.
• Unions are not supported.

Your table definition must account for all of the columns in the ORC data, even if you cannot query those columns.