[HIVE-20692] Enable folding of NOT x IS (NOT) [TRUE|FALSE] expressions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 05/Oct/18 09:15
• Updated: 17/Nov/22 08:55
• Resolved: 08/Oct/18 14:17

Description

Expressions like: not ((a>0) is not true) could be rewritten to (a>0) is true.

However currently this doesn't happen because some of these functions are not translated for Calcite.

create table t (a integer);
explain select not ((a>0) is not true) from t group by a;
[...]
expressions: (not (_col0 > 0) is not true) (type: boolean) |
[...]