[ https://issues.apache.org/jira/browse/HIVE-24365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltan Haindrich updated HIVE-24365: ------------------------------------ Parent: HIVE-24384 Issue Type: Sub-task (was: Improvement) > SWO should not create complex and redundant filter expressions > -------------------------------------------------------------- > > Key: HIVE-24365 > URL: https://issues.apache.org/jira/browse/HIVE-24365 > Project: Hive > Issue Type: Sub-task > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 40m > Remaining Estimate: 0h > > 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 > {code} > T(A) > T(B) > T(C) > {code} > after merging A,B > {code} > T(A || B) -> FIL(A) > -> FIL(B) > T(C) > {code} > right now if we merge C as well: > {code} > T(A || B || C) -> FIL(A AND (A || B)) > -> FIL(B AND (A || B)) > -> FIL(C) > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)