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 $commit_time BETWEEN run_start_time() AND run_end_time()
    LIMIT 1;

Query result

input	Output
true	false