StreamSQL Array Functions

Array functions are used for handling array data.

ARRAY_LENGTH - Array Length Function

Syntax: array_length(array)
Description: Returns the length of an array.

ARRAY_CONTAINS - Array Contains Function

Syntax: array_contains(array, value)
Description: Checks if an array contains a specified value.

ARRAY_POSITION - Array Position Function

Syntax: array_position(array, value)
Description: Returns the position of a value in an array.

ARRAY_REMOVE - Array Remove Function

Syntax: array_remove(array, value)
Description: Removes a specified value from an array.

ARRAY_DISTINCT - Array Distinct Function

Syntax: array_distinct(array)
Description: Returns the deduplicated result of an array.

ARRAY_INTERSECT - Array Intersection Function

Syntax: array_intersect(array1, array2)
Description: Returns the intersection of two arrays.

ARRAY_UNION - Array Union Function

Syntax: array_union(array1, array2)
Description: Returns the union of two arrays.

ARRAY_EXCEPT - Array Except Function

Syntax: array_except(array1, array2)
Description: Returns the difference of two arrays.

📚 Related Documentation

• Hash Functions - Learn detailed usage of hash functions
• Type Check Functions - Learn detailed usage of type check functions
• SQL Reference - View complete SQL syntax reference