MAP_CONTAINS_KEY

Description

Determines whether the given map contains a specific key key

Syntax

MAP_CONTAINS_KEY(<map>, <key>)

Parameters

Parameter	Description
<map>	Input map content
<key>	The key to be retrieved

Return Value

Determines whether the given map contains a specific key key, and returns 1 if it exists, otherwise returns 0.

Example

select map_contains_key(map(null, 1, 2, null), null),map_contains_key(map(1, "100", 0.1, 2), 0.11);

+-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| map_contains_key(map(NULL, 1, 2, NULL), NULL) | map_contains_key(cast(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)) as MAP<DECIMALV3(3, 2),VARCHAR(3)>), cast(0.11 as DECIMALV3(3, 2))) |
+-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|                                             1 |                                                                                                                                                                               0 |
+-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+