Zoltan Haindrich created HIVE-25822: ---------------------------------------
Summary: Unexpected result rows in case of outer join contains conditions only affecting one side Key: HIVE-25822 URL: https://issues.apache.org/jira/browse/HIVE-25822 Project: Hive Issue Type: Improvement Reporter: Zoltan Haindrich Assignee: Zoltan Haindrich needed * outer join * on condition has at least one condition for one side of the join * in a single reducer: ** a right hand side only row outputted right before ** >=2 rows on LHS and 1 on RHS matching in the join keys but the first LHS doesn't satisfies the filter condition ** second LHS row with good filter condition {code} with t_y as (select col1 as id,col2 as s from (VALUES(0,'a'),(1,'y')) as c), t_xy as (select col1 as id,col2 as s from (VALUES(1,'x'),(1,'y')) as c) select * from t_xy l full outer join t_y r on (l.id=r.id and l.s='y'); {code} null,null,1,y is an unexpected result {code} +-------+-------+-------+-------+ | l.id | l.s | r.id | r.s | +-------+-------+-------+-------+ | NULL | NULL | 0 | a | | 1 | x | NULL | NULL | | NULL | NULL | 1 | y | | 1 | y | 1 | y | +-------+-------+-------+-------+ {code} -- This message was sent by Atlassian Jira (v8.20.1#820001)