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

bug with hive.auto.convert.join.noconditionaltask with outer joins

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      Consider the following scenario:

      create table s1 as select * from src where key = 0;

      set hive.auto.convert.join.noconditionaltask=false;

      SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10);

      gives correct results

      0 val_0 NULL NULL
      0 val_0 NULL NULL
      0 val_0 NULL NULL

      whereas it gives no results with hive.auto.convert.join.noconditionaltask set
      to true

        Attachments

        1. hive.4146.1.patch
          3 kB
          Namit Jain
        2. hive.4146.2.patch
          12 kB
          Namit Jain
        3. hive.4146.3.patch
          308 kB
          Namit Jain
        4. hive.4146.4.patch
          308 kB
          Namit Jain
        5. hive.4146.5.patch
          390 kB
          Namit Jain
        6. hive.4146.6.patch
          402 kB
          Namit Jain

          Issue Links

            Activity

              People

              • Assignee:
                namit Namit Jain
                Reporter:
                namit Namit Jain
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: