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

Improve plans for correlated subqueries with non-equi predicate

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • Query Planning
    • None

    Description

      HIVE-17767 optimized plan to not generate value generator (i.e. an extra join with outer query to fetch correlated columns) for EQUAL and NOT EQUAL predicates e.g.

      select * from src b where b.key in (select key from src a where b.value <> a.value)
      

      This should be improved and implemented for rest of the predicates e.g. LESS THAN etc

      Attachments

        1. HIVE-18173.8.patch
          121 kB
          Vineet Garg
        2. HIVE-18173.7.patch
          344 kB
          Vineet Garg
        3. HIVE-18173.6.patch
          1.08 MB
          Vineet Garg
        4. HIVE-18173.5.patch
          1.26 MB
          Vineet Garg
        5. HIVE-18173.4.patch
          1.25 MB
          Vineet Garg
        6. HIVE-18173.3.patch
          1.25 MB
          Vineet Garg
        7. HIVE-18173.2.patch
          1.25 MB
          Vineet Garg
        8. HIVE-18173.1.patch
          442 kB
          Vineet Garg

        Activity

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

          People

            vgarg Vineet Garg Assign to me
            vgarg Vineet Garg
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment