hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13191) DummyTable map joins mix up columns between tables
Date Sun, 17 Jul 2016 17:16:20 GMT

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

Jesus Camacho Rodriguez updated HIVE-13191:
-------------------------------------------
       Resolution: Fixed
    Fix Version/s: 2.1.1
                   2.2.0
                   1.3.0
           Status: Resolved  (was: Patch Available)

Pushed to master, branch-2.1, branch-1. Thanks for the review [~ashutoshc]!

> DummyTable map joins mix up columns between tables
> --------------------------------------------------
>
>                 Key: HIVE-13191
>                 URL: https://issues.apache.org/jira/browse/HIVE-13191
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 2.0.0, 2.1.0
>            Reporter: Gopal V
>            Assignee: Jesus Camacho Rodriguez
>             Fix For: 1.3.0, 2.2.0, 2.1.1
>
>         Attachments: HIVE-13191.01.patch, HIVE-13191.02.patch, HIVE-13191.03.patch, HIVE-13191.patch,
tez.q
>
>
> {code}
> SELECT
>   a.key,
>   a.a_one,
>   b.b_one,
>   a.a_zero,
>   b.b_zero
> FROM
> (
>     SELECT
>       11 key,
>       0 confuse_you,
>       1 a_one,
>       0 a_zero
> ) a
> LEFT JOIN
> (
>     SELECT
>       11 key,
>       0 confuse_you,
>       1 b_one,
>       0 b_zero
> ) b
> ON a.key = b.key
> ;
> 11      1       0       0       1
> {code}
> This should be 11, 1, 1, 0, 0 instead. 
> Disabling map-joins & using shuffle-joins returns the right result.



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

Mime
View raw message