map()

Creates a map from a set of keys and values

Arguments & returns

2 overloads

Scalar

Overload link	Returns
#01	`MAP("NULL", "NULL")`

Scalar

Overload link	`keys`	`values`	Returns
#02	`K[]`	`V[]`	`MAP(K, V)`

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 Haybarn

MAP([a], [b])

MAP_FROM_ARRAYS(ARRAY(1), c)

In Haybarn

MAP([1], c)

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

In Haybarn

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

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

In Haybarn

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 Haybarn

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