ISFALSE
Tests whether the input expression is false. If it is, returns a value of true.
Syntax
ISFALSE(boolean_expression boolean) → boolean
boolean_expression: The input expression, which must be of type
BOOLEAN
.
Examples
CREATE TABLE $scratch.test_table
(
test_column BOOLEAN
)
-- true, Table created
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
SELECT ISFALSE(test_column)
FROM $scratch.test_table
-- false
-- true
Last updated
Was this helpful?