Spark SQL "<=>" operator

Checkout the Section "Supported Hive Feature on Spark SQL Programming guide link and you will find it in the list of Hive Operators supported by Spark.

Here is what it does:

• Returns same result with EQUAL(=) operator for non-null operands

however:

• it returns TRUE if both are NULL

• it returns FALSE if one of them is NULL