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

Incorrect result set for vectorized left outer join

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.14.0
    • Fix Version/s: 1.2.0
    • Component/s: SQL
    • Labels:
      None

      Description

      This query is supposed to return 3 rows and will when run without Tez but returns 2 rows when run with Tez.

      select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 )

      tjoin1.rnum tjoin1.c1 tjoin1.c2 c2j2
      1 20 25 <null>
      2 <null> 50 <null>

      instead of

      tjoin1.rnum tjoin1.c1 tjoin1.c2 c2j2
      0 10 15 <null>
      1 20 25 <null>
      2 <null> 50 <null>

      create table if not exists TJOIN1 (RNUM int , C1 int, C2 int)
      STORED AS orc ;

      0|10|15
      1|20|25
      2|\N|50

      create table if not exists TJOIN2 (RNUM int , C1 int, C2 char(2))
      ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
      STORED AS TEXTFILE ;

      0|10|BB
      1|15|DD
      2|\N|EE
      3|10|FF

        Attachments

        1. HIVE-9743.01.patch
          23 kB
          Matt McCline
        2. HIVE-9743.02.patch
          27 kB
          Matt McCline
        3. HIVE-9743.03.patch
          37 kB
          Matt McCline
        4. HIVE-9743.04.patch
          74 kB
          Matt McCline
        5. HIVE-9743.05.patch
          73 kB
          Matt McCline
        6. HIVE-9743.06.patch
          1.22 MB
          Matt McCline
        7. HIVE-9743.08.patch
          1.19 MB
          Matt McCline
        8. HIVE-9743.09.patch
          1.15 MB
          Matt McCline
        9. HIVE-9743.091.patch
          1.15 MB
          Matt McCline

          Activity

            People

            • Assignee:
              mmccline Matt McCline
              Reporter:
              the6campbells N Campbell
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: