⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
Map Functions
Name Description
cardinality(map) Return the size of the map (or the number of entries in the map).
element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown.
map_concat(maps...) Returns a map created from merging the input maps. On key collision the value is taken from the last map with that key.
map_contains(map, key) Checks if a map contains a given key.
map_contains_entry(map, key, value) Check if a map contains a given key-value pair.
map_contains_value(map, value) Checks if a map contains a given value.
map_entries(map) Return a list of struct(k, v) for each key-value pair in the map.
map_extract(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown.
map_extract_value(map, key) Returns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown.
map_from_entries(STRUCT(k, v)[]) Returns a map created from the entries of the array.
map_keys(map) Return a list of all keys in the map.
map_values(map) Return a list of all values in the map.
map() Returns an empty map.
map[entry] Returns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown.

cardinality(map)

Description Return the size of the map (or the number of entries in the map).
Example cardinality(map([4, 2], ['a', 'b']))
Result 2

element_at(map, key)

Description Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown.
Example element_at(map([100, 5], [42, 43]), 100)
Result [42]
Aliases map_extract(map, key)

map_concat(maps...)

Description Returns a map created from merging the input maps. On key collision the value is taken from the last map with that key.
Example map_concat(MAP {'key1': 10, 'key2': 20}, MAP {'key3': 30}, MAP {'key2': 5})
Result {key1=10, key2=5, key3=30}

map_contains(map, key)

Description Checks if a map contains a given key.
Example map_contains(MAP {'key1': 10, 'key2': 20, 'key3': 30}, 'key2')
Result true

map_contains_entry(map, key, value)

Description Check if a map contains a given key-value pair.
Example map_contains_entry(MAP {'key1': 10, 'key2': 20, 'key3': 30}, 'key2', 20)
Result true

map_contains_value(map, value)

Description Checks if a map contains a given value.
Example map_contains_value(MAP {'key1': 10, 'key2': 20, 'key3': 30}, 20)
Result true

map_entries(map)

Description Return a list of struct(k, v) for each key-value pair in the map.
Example map_entries(map([100, 5], [42, 43]))
Result [{'key': 100, 'value': 42}, {'key': 5, 'value': 43}]

map_extract(map, key)

Description Return the value for a given key as a list, or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys else an error is returned.
Example map_extract(map([100, 5], [42, 43]), 100)
Result [42]
Aliases element_at(map, key)

map_extract_value(map, key)

Description Returns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown.
Example map_extract_value(map([100, 5], [42, 43]), 100);
Result 42
Aliases map[key]

map_from_entries(STRUCT(k, v)[])

Description Returns a map created from the entries of the array.
Example map_from_entries([{k: 5, v: 'val1'}, {k: 3, v: 'val2'}])
Result {5=val1, 3=val2}

map_keys(map)

Description Return a list of all keys in the map.
Example map_keys(map([100, 5], [42,43]))
Result [100, 5]

map_values(map)

Description Return a list of all values in the map.
Example map_values(map([100, 5], [42, 43]))
Result [42, 43]

map()

Description Returns an empty map.
Example map()
Result {}

map[entry]

Description Returns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown.
Example map([100, 5], ['a', 'b'])[100]
Result a
Aliases map_extract_value(map, key)
About this page
© 2026 DuckDB Foundation, Amsterdam NL
DuckDB Home Code of Conduct Trademark Use Blog