You are viewing documentation about an older version (1.40.0). View latest version

snowflake.snowpark.functions.bitand_agg¶

snowflake.snowpark.functions.bitand_agg(e: 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:

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