Skip to content

KEYS

KEYS returns the keys of a map as a list.

Syntax

KEYS(map)

Parameters

  • map – Map expression.

Examples

SELECT KEYS(CAST('{"id":1, "name":"alice"}' AS MAP));

This returns ["id", "name"].

Notes

A non-map value will cause an error.