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

CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix wrong result in join_filters_overlap

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • CBO
    • None

    Description

      Setup

       create table a as SELECT 100 as key, a.value as value FROM src LATERAL VIEW explode(array(40, 50, 60)) a as value limit 3; 

      Query:

       select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60); 

      Expected Result:

      100	40	NULL	NULL	NULL	NULL
      100	50	100	50	NULL	NULL
      100	60	NULL	NULL	100	60
      

      Actual Result:

      100	40	NULL	50	NULL	60
      100	50	100	50	NULL	60
      100	60	NULL	50	100	60
      

      Attachments

        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

            Dates

              Created:
              Updated:

              Slack

                Issue deployment