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
Language: English