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

handle skewed keys for a join in a separate job

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
    • 0.6.0
    • Query Processor
    • None
    • Reviewed

    Description

      The skewed keys can be written to a temporary table or file, and a followup conditional task can be used to perform the join on those keys.
      As a first step, JDBM can be used for those keys

      Attachments

        1. hive-964-2009-12-17.txt
          59 kB
          He Yongqiang
        2. hive-964-2009-12-28-2.patch
          621 kB
          He Yongqiang
        3. hive-964-2009-12-29-4.patch
          639 kB
          He Yongqiang
        4. hive-964-2010-01-08.patch
          293 kB
          He Yongqiang
        5. hive-964-2010-01-13-2.patch
          221 kB
          He Yongqiang
        6. hive-964-2010-01-14-3.patch
          2.26 MB
          He Yongqiang
        7. hive-964-2010-01-15-4.patch
          2.24 MB
          He Yongqiang

        Issue Links

        is depended upon by

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-562 join does not work well if there is a very large skew in keys

        • Major - Major loss of function.
        • Open
        is related to

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-10159 HashTableSinkDesc and MapJoinDesc keyTblDesc can be replaced by JoinDesc.keyTableDesc

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Resolved
        relates to

        New Feature - A new feature of the product, which has yet to be developed. HIVE-20222 Enable Skew Join Optimization For Outer Joins

        • Major - Major loss of function.
        • Open

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

          People

            he yongqiang He Yongqiang Assign to me
            namit Namit Jain
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment