Getting started
User guides
Administration guides
Reference guides
Resources
Updated May 13, 2022
Send us feedback
forall
Tests whether func holds for all elements in the array.
func
forall(expr, func)
expr: An ARRAY expression.
expr
func: A lambda function returning a BOOLEAN.
A BOOLEAN.
The lambda function uses one parameter passing an element of the array.
> SELECT forall(array(1, 2, 3), x -> x % 2 == 0); false > SELECT forall(array(2, 4, 8), x -> x % 2 == 0); true > SELECT forall(array(1, NULL, 3), x -> x % 2 == 0); false > SELECT forall(array(2, NULL, 8), x -> x % 2 == 0); NULL
filter function (Databricks SQL)
exists function (Databricks SQL)