[IMPALA-1767] Boolean type does not include ISO-SQL is true, unknown or false predicate

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.1.1
• Fix Version/s: Impala 2.11.0
• Component/s: Frontend
• Labels: ansi-sql newbie sql-language
• Target Version: Product Backlog
• Assignee: Vuk Ercegovac
• Reporter: Henry Robinson
• Created: 13/Feb/15 23:32
• Updated: 15/Mar/18 20:09
• Resolved: 25/Sep/17 16:32

Description

Statements like the following are not supported by Impala. This would mainly effect users migrating hand-written SQL to Impala:

select 1 from cert.tversion where (1 > 1) is false
Status: fail
Operation: execute
Errors:
AnalysisException: Syntax error at:
select 1 from cert.tversion where (1 > 1) is false