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 BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.2.0
    • Component/s: Query Processor
    • Labels:
    • Target Version/s:
    • Release Note:
      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
          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              rusanu Remus Rusanu Assign to me
              Reporter:
              rusanu Remus Rusanu

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment