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

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

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.11.0
    • Query Processor
    • None
    • 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.6.patch
          402 kB
          Namit Jain
        2. hive.4146.5.patch
          390 kB
          Namit Jain
        3. hive.4146.4.patch
          308 kB
          Namit Jain
        4. hive.4146.3.patch
          308 kB
          Namit Jain
        5. hive.4146.2.patch
          12 kB
          Namit Jain
        6. hive.4146.1.patch
          3 kB
          Namit Jain

        Issue Links

        Activity

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

          People

            namit Namit Jain Assign to me
            namit Namit Jain
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment