!

Description

Inversion of boolean expression.

Inversion of boolean expression.

Usage

not(x)

## S4 method for signature 'Column'
!x

## S4 method for signature 'Column'
not(x)

Arguments

Details

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

Note

! since 2.3.0

not since 2.3.0

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))

## End(Not run)
## 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"))))

## End(Not run)