Links

NOT

Returns true if the input is false, false if the input is true, null if the input is null and applies this same logic to each element of an array input.

Syntax

NOT(input)

Arguments

Name
Type
Description
Default Value
input
boolean

Returns

boolean

Examples

input
Output
true
false
null::boolean
null
false
true
array[false, true, false]
[true, false, true]

Transformation job example

SQL

CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT input,
NOT(input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET input = true
WHERE time_filter()
LIMIT 1;

Query result

input
Output
true
false