Array contains

Supported in: Batch, Streaming

Returns true if the array contains the value.

Expression categories: Array, Boolean

Declared arguments

• Array: The array to search within.
  Expression<Array<ComparableType>>
• Value: The value to search for within the array.
  Expression<ComparableType>

Output type: Boolean

Examples

Example 1: Base case

Argument values:

• Array: part_ids
• Value: BRR-123

---

Example 2: Base case

Description: Comparisons between different numeric types is allowed.

Argument values:

• Array: ids
• Value: 1

---

Example 3: Null case

Argument values:

• Array: array
• Value: value

---

Example 4: Edge case

Description: Float types should be cast to integers when checking for equality.

Argument values:

• Array: ids
• Value: 1.0

---

Example 5: Edge case

Description: Float types should not be rounded when checking for equality.

Argument values:

• Array: ids
• Value: 1.2

---