snowflake.snowpark.functions.bitor_agg¶

snowflake.snowpark.functions.bitor_agg(e: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.40.0/src/snowflake/snowpark/_functions/scalar_functions.py#L149-L161)¶

Returns the bitwise OR of all non-NULL records in a group. If all records inside a group are NULL, a NULL is returned.

Example:

CopyExpand

>>> df = session.create_dataframe([[15], [26], [12], [14], [8]], schema=["a"])
>>> df.select(bitor_agg("a").alias("result")).collect()
[Row(RESULT=31)]

Show lessSee more

Scroll to top