snowflake.snowpark.functions.boolor_agg¶

snowflake.snowpark.functions.boolor_agg(expr: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.45.0/src/snowflake/snowpark/_functions/scalar_functions.py#L819-L846)¶

Returns the logical OR of all non-NULL records in a group. If all records are NULL, returns NULL.

Parameters:

expr (ColumnOrName) – Boolean values to aggregate.

Returns:

The logical OR aggregation result.

Return type:

Column

Example:

CopyExpand

>>> df = session.create_dataframe([
...     [True, False, True],
...     [False, False, False],
...     [True, True, False],
...     [False, True, True]
... ], schema=["a", "b", "c"])
>>> df.select(
...     boolor_agg(df["a"]).alias("boolor_a"),
...     boolor_agg(df["b"]).alias("boolor_b"),
...     boolor_agg(df["c"]).alias("boolor_c")
... ).collect()
[Row(BOOLOR_A=True, BOOLOR_B=True, BOOLOR_C=True)]

Show lessSee more

Scroll to top