Supported Data Types

Arrays and Maps for External Tables Using Parquet Data

When working with Parquet files containing complex types, you can now define tables using arrays and maps of primitive types, allowing you to read a larger range of existing data:

• You can query arrays, use them in joins and other operations, and use Array Functions on both array columns and literals. See Reading Arrays and the ARRAY data type for more information.
• You can define maps, which allows you to read files containing them, but you cannot query them. See Reading Maps and the MAP data type for more information.

Arrays and maps can contain only primitive types. They cannot contain rows, arrays, or maps.