You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zoltan Haindrich (Jira)" <ji...@apache.org> on 2021/12/20 08:37:00 UTC
[jira] [Assigned] (HIVE-25823) Incorrect false positive results for outer join using non-satisfiable residual filters
[ https://issues.apache.org/jira/browse/HIVE-25823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltan Haindrich reassigned HIVE-25823:
---------------------------------------
Assignee: Zoltan Haindrich
> Incorrect false positive results for outer join using non-satisfiable residual filters
> --------------------------------------------------------------------------------------
>
> Key: HIVE-25823
> URL: https://issues.apache.org/jira/browse/HIVE-25823
> Project: Hive
> Issue Type: Bug
> Reporter: Zoltan Haindrich
> Assignee: Zoltan Haindrich
> Priority: Major
>
> similar to HIVE-25822
> {code}
> create table t_y (id integer,s string);
> create table t_xy (id integer,s string);
> insert into t_y values(0,'a'),(1,'y'),(1,'x');
> insert into t_xy values(1,'x'),(1,'y');
> select * from t_xy l full outer join t_y r on (l.id=r.id and l.s='y' and l.id+2*r.id=1);
> {code}
> the rows with full of NULLs are incorrect
> {code}
> +-------+-------+-------+-------+
> | l.id | l.s | r.id | r.s |
> +-------+-------+-------+-------+
> | NULL | NULL | 0 | a |
> | NULL | NULL | NULL | NULL |
> | 1 | y | NULL | NULL |
> | NULL | NULL | NULL | NULL |
> | NULL | NULL | 1 | y |
> | NULL | NULL | 1 | x |
> +-------+-------+-------+-------+
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)