You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Gopal V (JIRA)" <ji...@apache.org> on 2016/03/01 20:30:18 UTC

[jira] [Created] (HIVE-13191) DummyTable map joins mix up columns between tables

Gopal V created HIVE-13191:
------------------------------

             Summary: 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)