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

    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

            People

              vgarg Vineet Garg
              vgarg Vineet Garg
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: