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

MetadataUpdater: provide a mechanism to edit the statistics of a column in a table (or a partition of a table)

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 0.14.0
    • Statistics

    Description

      Two motivations:

      (1) Cost-based Optimizer (CBO) depends heavily on the statistics of a column in a table (or a partition of a table). If we would like to test whether CBO chooses the best plan under different statistics, it would be time consuming if we load the whole table and create the statistics from ground up.

      (2) As database runs, the statistics of a column in a table (or a partition of a table) may change. We need a way or a mechanism to synchronize.

      We propose the following command to achieve that:

      ALTER TABLE table_name PARTITION partition_spec [COLUMN col_name] UPDATE STATISTICS col_statistics [COMMENT col_comment]

      Attachments

        1. HIVE-7506.patch
          1.16 MB
          Pengcheng Xiong
        2. HIVE-7506.1.patch
          56 kB
          Pengcheng Xiong
        3. HIVE-7506.3.patch
          51 kB
          Pengcheng Xiong
        4. HIVE-7506.4.patch
          44 kB
          Pengcheng Xiong
        5. HIVE-7506.5.patch
          61 kB
          Pengcheng Xiong
        6. HIVE-7506.6.patch
          62 kB
          Pengcheng Xiong
        7. HIVE-7506.7.patch
          62 kB
          Pengcheng Xiong
        8. HIVE-7506.8.patch
          63 kB
          Pengcheng Xiong

        Issue Links

          Activity

            People

              pxiong Pengcheng Xiong
              pxiong Pengcheng Xiong
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 252h
                  252h
                  Remaining:
                  Remaining Estimate - 252h
                  252h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified