Documentation

SQL map functions

Use map functions to create and operate on Arrow maps in SQL queries.

element_at

Alias of map_extract.

make_map

Returns an Arrow map with the specified key and value.

make_map(key, value)

Arguments

  • key: Expression to use for the key. Can be a constant, column, function, or any combination of arithmetic or string operators.
  • value: Expression to use for the value. Can be a constant, column, function, or any combination of arithmetic or string operators.

View make_map query example

map

Returns an Arrow map with the specified key-value pairs. Keys are mapped to values by their positions in each respective list. Each key must be unique and non-null.

map(key_list, value_list)
-- or
map { key: value, ... }

Arguments

  • key_list: List of keys to use in the map. Each key must be unique and non-null.
  • value_list: List of values to map to the corresponding keys.

View map query example

View map query example with alternate syntax

map_extract

Returns a list containing the value for the given key or an empty list if the Returns a list containing the value for the given key, or an empty list if the key is not present in the map. The returned list will contain exactly one element (the value) when the key is found.

map_extract(map, key)

Arguments

  • map: Map expression. Can be a constant, column, or function, and any combination of map operators.
  • key: Key to extract from the map. Can be a constant, column, or function, any combination of arithmetic or string operators, or a named expression of the previously listed.

Aliases

  • element_at

get_field

View map_extract query example

map_keys

Returns a list of all keys in the map.

map_keys(map)

Arguments

  • map: Map expression. Can be a constant, column, or function, and any combination of map operators.

get_field

View map_keys query example

map_values

Returns a list of all values in the map.

map_values(map)

Arguments

  • map: Map expression. Can be a constant, column, or function, and any combination of map operators.

View map_values query example


Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.4

Key enhancements in InfluxDB 3.4 and the InfluxDB 3 Explorer 1.2.

See the Blog Post

InfluxDB 3.4 is now available for both Core and Enterprise, which introduces offline token generation for use in automated deployments and configurable license type selection that lets you bypass the interactive license prompt. InfluxDB 3 Explorer 1.2 is also available, which includes InfluxDB cache management and other new features.

For more information, check out: