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

Partitioned tables statistics can go wrong in basic stats mixed case

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None
    • None

    Description

      suppose the following scenario:

      • part1 has basic stats RC=10,DS=1K
      • all other partition has no basic stats (and a bunch of rows)

      then this condition would be false; which in turn produces estimations for the whole partitioned table: RC=10,DS=1K

      Attachments

        1. HIVE-18140.01.patch
          736 kB
          Zoltan Haindrich
        2. HIVE-18140.01-branch-3.patch
          679 kB
          Zoltan Haindrich
        3. HIVE-18140.01wip01.patch
          32 kB
          Zoltan Haindrich
        4. HIVE-18140.01wip03.patch
          39 kB
          Zoltan Haindrich
        5. HIVE-18140.01wip04.patch
          96 kB
          Zoltan Haindrich
        6. HIVE-18140.02.patch
          668 kB
          Zoltan Haindrich
        7. HIVE-18140.02wip01.patch
          641 kB
          Zoltan Haindrich
        8. HIVE-18140.03.patch
          668 kB
          Zoltan Haindrich
        9. HIVE-18140.04.patch
          678 kB
          Zoltan Haindrich
        10. HIVE-18140.04.patch
          678 kB
          Zoltan Haindrich
        11. HIVE-18140.05.patch
          678 kB
          Zoltan Haindrich
        12. HIVE-19140.02wip02.patch
          641 kB
          Zoltan Haindrich
        13. HIVE-19727.02wip03.patch
          668 kB
          Zoltan Haindrich

        Issue Links

          Activity

            People

              kgyrtkirk Zoltan Haindrich
              kgyrtkirk Zoltan Haindrich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: