snowflake.snowpark.functions.bitxor¶

snowflake.snowpark.functions.bitxor(expr1: Union[snowflake.snowpark.column.Column, str], expr2: Union[snowflake.snowpark.column.Column, str], padside: Optional[str] = None) → Column[source]¶

Returns the bitwise XOR of two numeric expressions.

Parameters:

• expr1 – The first numeric expression.

• expr2 – The second numeric expression.

• padside – Optional padding side specification.

Example:

>>> df = session.create_dataframe([[1, 1], [2, 4], [4, 2], [16, 24]], schema=["bit1", "bit2"])
>>> df.select(bitxor("bit1", "bit2")).collect()
[Row(BITXOR("BIT1", "BIT2")=0), Row(BITXOR("BIT1", "BIT2")=6), Row(BITXOR("BIT1", "BIT2")=6), Row(BITXOR("BIT1", "BIT2")=8)]

Copy

Additional Example with padside parameter::

>>> from snowflake.snowpark.functions import to_binary
>>> df = session.create_dataframe([['1110', '1011']], schema=["a", "b"])
>>> result = df.select(bitxor(to_binary("a"), to_binary("b"), padside="LEFT").alias("RESULT")).collect()
>>> expected = b'

'
>>> actual = result[0]["RESULT"]
>>> assert  isinstance(actual, bytearray)
>>> assert actual == expected

Copy