snowflake.snowpark.functions.bitxor_agg

snowflake.snowpark.functions.bitxor_agg(expr: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.44.0/src/snowflake/snowpark/_functions/scalar_functions.py#L164-L176)

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

Example:

>>> df = session.create_dataframe([[15], [26], [12]], schema=["a"])
>>> df.select(bitxor_agg("a")).collect()
[Row(BITXOR_AGG("A")=25)]
Copy
Language: English