MAP_CONTAINS_KEY

描述

判断给定 map 中是否包含特定的键 key

语法

MAP_CONTAINS_KEY(<map>, <key>)

参数

参数	说明
<map>	输入的 map 内容
<key>	需要检索的key

返回值

判断给定 map 中是否包含特定的键 key,存在返回 1 ,不存在返回 0 。

举例

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 |
+-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+