JinsuKim created HIVE-13623:
-------------------------------
Summary: Hive on tez produce wrong results when withClause and
(outer) joins
Key: HIVE-13623
URL: https://issues.apache.org/jira/browse/HIVE-13623
Project: Hive
Issue Type: Bug
Affects Versions: 2.0.0, 1.1.0
Reporter: JinsuKim
Priority: Trivial
Hive on mr produce correct results when (outer) joins and withClause. But tez
produce wrong results
{code:sql|title=Case1}
with a as (
select 1 as c1
union all
select 2 as c1
union all
select 3 as c1
),
b as (
select 1 as c1
)
select *
from ( select a.c1 as ac1, b.c1 as bc1
from a left outer join b
on a.c1 = b.c1
) c;
where c.bc1 is null
{code}
{code:title=case1 result}
mr :
+--------+--------+--+
| c.ac1 | c.bc1 |
+--------+--------+--+
| 2 | NULL |
| 3 | NULL |
+--------+--------+--+
tez :
+--------+--------+--+
| c.ac1 | c.bc1 |
+--------+--------+--+
+--------+--------+--+
{code}
Case2 as similar to Case1 produces same results.
{code:sql|title=Case2}
with a as (
select * from j1
),
b as (
select * from j2
)
select *
from ( select a.c1 as ac1, b.c1 as bc1
from a left outer join b
on a.c1 = b.c1
) c
where c.bc1 is null;
drop table j1;
create table j1 as select c1 from
( select 1 as c1 from default.dual
union all
select 2 as c1 from default.dual
union all
select 3 as c1 from default.dual
) t1;
drop table j2;
create table j2 as
select 1 as c1 from default.dual;
{code}
{code:title=case2 result}
mr :
+--------+--------+--+
| c.ac1 | c.bc1 |
+--------+--------+--+
| 2 | NULL |
| 3 | NULL |
+--------+--------+--+
tez :
+--------+--------+--+
| c.ac1 | c.bc1 |
+--------+--------+--+
| 2 | NULL |
| 3 | NULL |
+--------+--------+--+
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
