Dremio Cloud
Dremio Software
 
On this page

    Categories: Semistructured Data

    ARRAY_CONTAINS

    Returns whether a list contains a given value.

    Syntax

    ARRAY_CONTAINS(list LIST, value any) → boolean

    • list: The list to search.
    • value: An expression of a type that is comparable with the LIST.

    Examples

    ARRAY_CONTAINS example 
    SELECT ARRAY_CONTAINS(CONVERT_FROM('["apple", "pear", "banana"]', 'json'), NULL)
-- null
    ARRAY_CONTAINS example 
    SELECT ARRAY_CONTAINS(CONVERT_FROM('["apple", "pear", "banana"]', 'json'), 'pear')
-- true
    ARRAY_CONTAINS example 
    SELECT ARRAY_CONTAINS(CONVERT_FROM('["apple", "pear", "banana"]', 'json'), 'grape')
-- false

    Usage Notes

    If value is NULL, the result is NULL. If NULL is in list and value is not in list, the result is NULL. If value is present in the list, the result is TRUE. Otherwise, the result is FALSE.