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

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

     [ https://issues.apache.org/jira/browse/HIVE-8888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Prasanth Jayachandran updated HIVE-8888:
----------------------------------------
    Attachment: HIVE-8888-branch.5.patch

HIVE-8707 fixed ordering issues in hashmap between JDK8 vs older version. The test diff changes in .5 patch is not required for the branch. Attaching patch for the branch 0.14.1 which is same as Gunther's .5 patch but without test diff changes.

> 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.0, 0.14.0, 0.13.1, 0.15.0
>            Reporter: Prasanth Jayachandran
>            Assignee: Prasanth Jayachandran
>             Fix For: 0.14.1
>
>         Attachments: HIVE-8888-branch.5.patch, HIVE-8888.1.patch, HIVE-8888.2.patch, HIVE-8888.3.patch, HIVE-8888.4.patch, HIVE-8888.5.patch
>
>
> 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)