Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11160 Auto-gather column stats
  3. HIVE-18005

Improve size estimation for array() to be not 0

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
    • None
    • 3.0.0
    • Statistics
    • None

    Description

      happens only in case the array is not from a column; and the array contains no column references

      EXPLAIN
      SELECT sort_array(array("b", "d", "c", "a")),array("1","2") FROM t
      
      ...
                   Statistics: Num rows: 1 Data size: 0 Basic stats: COMPLETE Column stats: COMPLETE
                   ListSink
      

      Attachments

        1. HIVE-18005.01.patch
          14 kB
          Zoltan Haindrich
        2. HIVE-18005.01.patch
          14 kB
          Zoltan Haindrich
        3. HIVE-18005.02.patch
          39 kB
          Zoltan Haindrich

        Activity

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

          People

            kgyrtkirk Zoltan Haindrich Assign to me
            kgyrtkirk Zoltan Haindrich
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment