Skip to main content

MAP_CONTAINS_VALUE

Description

Determines whether a given map contains a specific value value

Syntax

MAP_CONTAINS_VALUE(<map>, <value>)

Parameters

  • <map> MAP type, the input map content.
  • <value> supports multiple types, the value to be searched.

Return Value

Determines whether a given map contains a specific value value. Returns 1 if exists, 0 if not exists.

Usage Notes

  1. If parameter <map> is NULL, returns NULL.
  2. <value> can be NULL. The comparison for NULL is null-safe-equal, which means NULL is considered equal to NULL.

Examples

  1. Regular parameters
    select map_contains_value(map(1, "100", 0.1, 2), 100), map_contains_value(map(1, "100", 0.1, 2), 101);
    +------------------------------------------------+------------------------------------------------+
    | map_contains_value(map(1, "100", 0.1, 2), 100) | map_contains_value(map(1, "100", 0.1, 2), 101) |
    +------------------------------------------------+------------------------------------------------+
    | 1 | 0 |
    +------------------------------------------------+------------------------------------------------+
  2. NULL parameters
    select map_contains_value(NULL, 100);
    +-------------------------------+
    | map_contains_value(NULL, 100) |
    +-------------------------------+
    | NULL |
    +-------------------------------+
    select map_contains_value(map(null, null), null), map_contains_value(map(null, 100), null);
    +-------------------------------------------+------------------------------------------+
    | map_contains_value(map(null, null), null) | map_contains_value(map(null, 100), null) |
    +-------------------------------------------+------------------------------------------+
    | 1 | 0 |
    +-------------------------------------------+------------------------------------------+