[FLINK-26947] Add ARRAY_CONTAINS supported in SQL & Table API

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: Table SQL / API
• Assignee: Timo Walther
• Reporter: dalongliu
• Created: 31/Mar/22 07:32
• Updated: 03/May/22 12:30
• Resolved: 02/May/22 07:14

Description

Returns true if array contains value.

Syntax:

array_contains(array, value) 

Arguments:

• array: An ARRAY to be searched.

• value: An expression with a type sharing a least common type with the array elements.

Returns:

A BOOLEAN. If value is NULL, the result is NULL. If any element in array is NULL, the result is NULL if value is not matched to any other element.

Examples:

> SELECT array_contains(array(1, 2, 3), 2);
 true
> SELECT array_contains(array(1, NULL, 3), 2);
 NULL
> SELECT array_conatins(array(1, 2, 3), NULL);
 NULL 

See more:

• Spark
• Hive