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

Hive should report a warning about missing table/column statistics to user.

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

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 2.2.0
    • Query Processor
    • hive.cbo.show.warnings (default false) is added to control display of cost-based-optimizer compiler warnings, like missing stats.

    Description

      Many Hive performance issues are due to missing statistics. Either all, table or column statistics are missing. Potentially a new partition has been added and customer forgot to gather stats for that partition.
      A simple warning about a table or column missing statistics can be very helpful and makes hive more user friendly. Hive already has this information, its a matter of printing it out.

      Attachments

        1. HIVE-15723.05.patch
          1 kB
          Remus Rusanu
        2. HIVE-15723.04.patch
          12 kB
          Remus Rusanu
        3. HIVE-15723.03.patch
          12 kB
          Remus Rusanu
        4. HIVE-15723.02.patch
          22 kB
          Remus Rusanu
        5. HIVE-15723.01.patch
          5 kB
          Remus Rusanu

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

          People

            rusanu Remus Rusanu Assign to me
            rusanu Remus Rusanu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment