snowflake.snowpark.functions.bitand_agg¶

snowflake.snowpark.functions.bitand_agg(expr: Union[snowflake.snowpark.column.Column, str]) → Column[source]¶

Returns the bitwise AND of all non-NULL records in a group. If all records inside a group are NULL, returns NULL.

Example:

CopyExpand

>>> df = session.create_dataframe([[15], [26], [12], [14], [8]], schema=["a"])
>>> df.select(bitand_agg("a")).collect()
[Row(BITAND_AGG("A")=8)]

Show lessSee more

Scroll to top