Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-9132 CBO: Calcite Operator To Hive Operator (Calcite Return Path)
  3. HIVE-14522

CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix test failure for auto_join_filters

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.3.0
    • CBO
    • None

    Description

      CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS; 
      CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS; 
      LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1;
      LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1;
      LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2;
      LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2;
      
      SET hive.optimize.bucketmapjoin = true;
      SET hive.optimize.bucketmapjoin.sortedmerge = true;
      SET hive.input.format = org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;
      
      SET hive.outerjoin.supports.filters = false;
      
       SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value; 
       Expected result: 3078400 Actual result: 4937935 

      Attachments

        1. HIVE-14522.1.patch
          17 kB
          Vineet Garg
        2. HIVE-14522.2.patch
          104 kB
          Vineet Garg

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            vgarg Vineet Garg Assign to me
            vgarg Vineet Garg
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment