map()

Creates a map from a set of keys and values

Arguments & returns

Scalar

Overload link	… Varargs	Returns
#01	`ANY`	`MAP`

… accepts a variable number of arguments of the type shown.

SELECT map(['key1', 'key2'], ['val1', 'val2']);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

MAP(a, b)

In DuckDB

MAP([a], [b])

MAP_FROM_ARRAYS(ARRAY(1), c)

In DuckDB

MAP([1], c)

CAST(MAP(ARRAY['key'], ARRAY[1]) AS MAP(VARCHAR, INT))

In DuckDB

CAST(MAP(['key'], [1]) AS MAP(TEXT, INT))

SELECT MAP('a', 1, 'b', 2)

In DuckDB

SELECT MAP(['a', 'b'], [1, 2])

Used in larger rewrites 1

These examples use map as one part of a larger SQL translation.

SELECT GET(col::MAP(INTEGER, VARCHAR), 1)

In DuckDB

SELECT CAST(col AS MAP(INT, TEXT))[1]