Description
<boolean test> ::=
<boolean primary> [ IS [ NOT ] <truth value> ]
<truth value> ::=
TRUE
| FALSE
| UNKNOWN
Currently, the following DBMSs support the syntax:
- PostgreSQL: https://www.postgresql.org/docs/9.1/functions-comparison.html
- Hive: https://issues.apache.org/jira/browse/HIVE-13583
- Redshift: https://docs.aws.amazon.com/redshift/latest/dg/r_Boolean_type.html
- Vertica: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Predicates/Boolean-predicate.htm
Issue resolved by pull request 25074
https://github.com/apache/spark/pull/25074