Skip to main content

Categories: Boolean, Datatype

IS [NOT] FALSE

Tests whether the input expression is either false or not false. If true in either case, returns a value of true. Alias for the function ISFALSE/ISNOTFALSE.

Syntax​

IS [NOT] FALSE(boolean_expression boolean) → boolean​

  • boolean_expression: The input expression, which must be of type BOOLEAN.

Examples

Create a table containing one column of boolean data type 
CREATE TABLE <catalog-name>.test_table 
  (
    test_column BOOLEAN
  )
-- true, Table created
Create two rows containing boolean values 
INSERT INTO <catalog-name>.test_table 
VALUES  (true), 
        (false)
-- Fragment, Records, Path, Metadata, Partition, FileSize, IcebergMetadata, fileschema, PartitionData
-- 0_0, 1, s3://<s3-bucket-path>, , 0, <file-size>, <iceberg-metadata>, <file-schema>, null
Run the ISFALSE query 
SELECT ISFALSE(test_column)
FROM <catalog-name>.test_table
-- false 
-- true
Run the ISNOTFALSE query 
SELECT ISNOTFALSE(test_column)
FROM <catalog-name>.test_table
-- true 
-- false