Skip to content

Latest commit

 

History

History
47 lines (36 loc) · 1.08 KB

isfalse.md

File metadata and controls

47 lines (36 loc) · 1.08 KB
description
Tests whether the input expression is false. If it is, returns a value of true.

ISFALSE

Syntax

ISFALSE(boolean_expression boolean) → boolean

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

Examples

{% code title="Create a table containing one column of boolean data type" %}

CREATE TABLE $scratch.test_table 
  (
    test_column BOOLEAN
  )

-- true, Table created

{% endcode %}

{% code title="Create two rows containing boolean values" %}

INSERT INTO $scratch.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

{% endcode %}

{% code title="Run the ISFALSE query" %}

SELECT ISFALSE(test_column)
FROM $scratch.test_table

-- false 
-- true

{% endcode %}