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

Fix for statistics annotation in nested AND expressions

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

    Description

      Discovered while working on HIVE-21867. Having predicates with nested AND expressions may result in different stats, even if predicates are basically similar (from stats estimation standpoint).
      For instance, stats for AND(x=5, true, true) are different from x=5.

      Attachments

        1. HIVE-21928.02.patch
          667 kB
          jcamachorodriguez
        2. HIVE-21928.01.patch
          592 kB
          jcamachorodriguez
        3. HIVE-21928.01.patch
          592 kB
          jcamachorodriguez
        4. HIVE-21928.patch
          3 kB
          jcamachorodriguez

        Issue Links

        relates to

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-20260 NDV of a column shouldn't be scaled when row count is changed by filter on another column

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

        Web Link GitHub Pull Request #700

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

          People

            jcamacho Jesús Camacho Rodríguez Assign to me
            jcamacho Jesús Camacho Rodríguez
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 20m
              20m

              Slack

                Issue deployment