ENTRIES

ENTRIES converts a map into a list of key–value pairs.

Syntax

ENTRIES(map)

Parameters

• map – Map expression to convert.

Examples

SELECT ENTRIES(CAST('{"name":"GlueSQL"}' AS MAP));

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

Notes

ENTRIES requires a map argument.