Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13191

DummyTable map joins mix up columns between tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0, 2.1.0
    • 1.3.0, 2.1.1, 2.2.0
    • None
    • None

    Description

      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
      

      This should be 11, 1, 1, 0, 0 instead.

      Disabling map-joins & using shuffle-joins returns the right result.

      Attachments

        1. tez.q
          0.5 kB
          Vikram Dixit K
        2. HIVE-13191.patch
          13 kB
          Jesus Camacho Rodriguez
        3. HIVE-13191.01.patch
          12 kB
          Jesus Camacho Rodriguez
        4. HIVE-13191.02.patch
          12 kB
          Jesus Camacho Rodriguez
        5. HIVE-13191.03.patch
          13 kB
          Jesus Camacho Rodriguez

        Activity

          People

            jcamachorodriguez Jesus Camacho Rodriguez
            gopalv Gopal Vijayaraghavan
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: