[HIVE-24365] SWO should not create complex and redundant filter expressions

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Labels: pull-request-available
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 10/Nov/20 17:01
• Updated: 13/Nov/20 10:23
• Resolved: 13/Nov/20 10:12

Description

for q88 we have complex and mostly unreadable filter expressions; because before merging 2 branches the TS filterexpression is pushed into a FIL operator.

consider 3 scans with filters: (A,B,C)
initially we have

 
T(A)
T(B)
T(C)

after merging A,B

T(A || B) -> FIL(A)
          -> FIL(B)
T(C)

right now if we merge C as well:

T(A || B || C) -> FIL(A AND (A || B))
               -> FIL(B AND (A || B))
               -> FIL(C)

Issue Links

• relates to: HIVE-24357 Exchange SWO table/algorithm strategy
• links to: GitHub Pull Request #1661
• links to: j1661