| %<=>% {SparkR} | R Documentation |
Equality test that is safe for null values.
x %<=>% value ## S4 method for signature 'Column' x %<=>% value
x |
a Column |
value |
a value to compare |
Can be used, unlike standard equality operator, to perform null-safe joins.
Equivalent to Scala Column.<=> and Column.eqNullSafe.
%<=>% since 2.3.0
## Not run:
##D df1 <- createDataFrame(data.frame(
##D x = c(1, NA, 3, NA), y = c(2, 6, 3, NA)
##D ))
##D
##D head(select(df1, df1$x == df1$y, df1$x %<=>% df1$y))
##D
##D df2 <- createDataFrame(data.frame(y = c(3, NA)))
##D count(join(df1, df2, df1$y == df2$y))
##D
##D count(join(df1, df2, df1$y %<=>% df2$y))
## End(Not run)