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

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: CBO
    • Labels:
      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

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

                Dates

                • Created:
                  Updated: