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

wrong result in left semi join

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.9.0, 0.10.0
    • Fix Version/s: 0.11.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      wrong result in left semi join while hive.optimize.ppd=true
      for example:
      1、create table
      create table t1(c1 int,c2 int, c3 int, c4 int, c5 double,c6 int,c7 string) row format DELIMITED FIELDS TERMINATED BY '|';
      create table t2(c1 int) ;
      2、load data
      load data local inpath '/home/test/t1.txt' OVERWRITE into table t1;
      load data local inpath '/home/test/t2.txt' OVERWRITE into table t2;
      t1 data:
      1|3|10003|52|781.96|555|201203
      1|3|10003|39|782.96|555|201203
      1|3|10003|87|783.96|555|201203
      2|5|10004|24|789.96|555|201203
      2|5|10004|58|788.96|555|201203
      t2 data:
      555
      3、excute Query
      select t1.c1,t1.c2,t1.c3,t1.c4,t1.c5,t1.c6,t1.c7 from t1 left semi join t2 on t1.c6 = t2.c1 and t1.c1 = '1' and t1.c7 = '201203' ;
      can got result.
      select t1.c1,t1.c2,t1.c3,t1.c4,t1.c5,t1.c6,t1.c7 from t1 left semi join t2 on t1.c6 = t2.c1 where t1.c1 = '1' and t1.c7 = '201203' ;
      can't got result.

        Attachments

        1. HIVE-4365.D10341.1.patch
          7 kB
          Phabricator
        2. HIVE-4365.D10341.2.patch
          15 kB
          Phabricator

          Activity

            People

            • Assignee:
              navis Navis Ryu
              Reporter:
              ransom Zhiqiang He
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: