snowflake.snowpark.functions.boolor_agg¶
- snowflake.snowpark.functions.boolor_agg(e: Union[snowflake.snowpark.column.Column, str]) Column [source]¶
Returns the logical OR of all non-NULL records in a group. If all records are NULL, returns NULL.
- Parameters:
e (ColumnOrName) – Boolean values to aggregate.
- Returns:
The logical OR aggregation result.
- Return type:
Example:
>>> 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)]