MAP

Represents map data in external tables in the Parquet format only. Maps must use only primitive types and may not contain other complex types.

You can define maps in order to read Parquet files that contain them, but you cannot query map columns.

Syntax

In column definitions:

MAP<key,value>

Map Input Format for Column Definition

In a column definition in an external table, a MAP consists of a key-value pair, specified as types. The table in the following example defines a map of product IDs to names.

=> CREATE EXTERNAL TABLE store (storeID INT, inventory MAP<INT,VARCHAR(100)>) 
    AS COPY FROM '...' PARQUET;