SparkR (version 3.1.2)

not: !

Description

Inversion of boolean expression.

Inversion of boolean expression.

Usage

not(x)
# S4 method for Column
!(x)
# S4 method for Column
not(x)

Arguments

x

Column to compute on

Details

not and ! cannot be applied directly to numerical column. To achieve R-like truthiness column has to be casted to BooleanType.

See Also

Other non-aggregate functions: column_nonaggregate_functions, column()

Examples

# NOT RUN {
df <- createDataFrame(data.frame(x = c(-1, 0, 1)))

head(select(df, !column("x") > 0))
# }
# NOT RUN {
df <- createDataFrame(data.frame(
  is_true = c(TRUE, FALSE, NA),
  flag = c(1, 0,  1)
))

head(select(df, not(df$is_true)))

# Explicit cast is required when working with numeric column
head(select(df, not(cast(df$flag, "boolean"))))
# }