Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5369 Annotate hive operator tree with statistics from metastore
  3. HIVE-7836

Ease-out denominator for multi-attribute join case in statistics annotation

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.14.0
    • 0.14.0
    • Query Processor, Statistics
    • None

    Description

      In cases where number of relations involved in join is less than the number of join attributes the denominator of join rule can get larger resulting in aggressive row count estimation.

      Attachments

        1. HIVE-7836.1.patch
          4 kB
          Prasanth Jayachandran

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-7666 Join selectivity calculation should use exponential back-off for conjunction predicates

        • Major - Major loss of function.
        • Closed
        links to

        Web Link Review Board

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

          People

            prasanth_j Prasanth Jayachandran Assign to me
            prasanth_j Prasanth Jayachandran
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment