Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.2.0
-
None
Description
Transform:
(COALESCE(a, '') = '') OR (a = 'A' AND b = c) OR (a = 'B' AND b = d) OR (a = 'C' AND b = e) OR (a = 'D' AND b = f) OR (a = 'E' AND b = g) OR (a = 'F' AND b = h)
into:
(a='') OR (a is null) OR (a = 'A' AND b = c) OR (a = 'B' AND b = d) OR (a = 'C' AND b = e) OR (a = 'D' AND b = f) OR (a = 'E' AND b = g) OR (a = 'F' AND b = h)
With complex queries, this will lead us to factor more predicates that could be pushed to the TS.
Attachments
Attachments
Issue Links
- is blocked by
-
HIVE-20563 Vectorization: CASE WHEN expression fails when THEN/ELSE type and result type are different
- Closed