You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Gopal V (JIRA)" <ji...@apache.org> on 2016/03/01 20:33:18 UTC
[jira] [Commented] (HIVE-13191) DummyTable map joins mix up columns
between tables
[ https://issues.apache.org/jira/browse/HIVE-13191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15174270#comment-15174270 ]
Gopal V commented on HIVE-13191:
--------------------------------
With real tables, this isn't a problem.
{code}
hive> create temporary table x as select 11 as key, 1 confuse_you, 1 one, 0 zero;
hive> select a.key, a.one, b.one, a.zero, b.zero from x a left join x b on a.key = b.key;
11 1 1 0 0
Time taken: 0.922 seconds, Fetched: 1 row(s)
{code}
> 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
>
> {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)