[jira] [Created] (HIVE-8888) Mapjoin with LateralViewJoin generates wrong plan in Tez

["Prasanth J (JIRA)" <ji...@apache.org>]

Prasanth J created HIVE-8888:
--------------------------------

             Summary: Mapjoin with LateralViewJoin generates wrong plan in Tez
                 Key: HIVE-8888
                 URL: https://issues.apache.org/jira/browse/HIVE-8888
             Project: Hive
          Issue Type: Bug
    Affects Versions: 0.13.1, 0.13.0, 0.14.0, 0.15.0
            Reporter: Prasanth J
            Assignee: Prasanth J


Queries like these 
{code}
with sub1 as
(select aid, avalue from expod1 lateral view explode(av) avs as avalue ),
sub2 as
(select bid, bvalue from expod2 lateral view explode(bv) bvs as bvalue)
select sub1.aid, sub1.avalue, sub2.bvalue
from sub1,sub2
where sub1.aid=sub2.bid;
{code}

generates twice the number of rows in Tez when compared to MR.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)