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

Stats: create materialized view should also collect stats

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • Statistics
    • None

    Description

      not having basic stats on the materialized view may cause it to be "ruled out" as a viable alternative by the cbo.

      repro set set hive.stats.deserialization.factor=10.0 in ql/src/test/queries/clientpositive/materialized_view_create_rewrite.q

      blocks: HIVE-18149

      Attachments

        1. HIVE-18163.03.patch
          69 kB
          Zoltan Haindrich
        2. HIVE-18163.02.patch
          69 kB
          Zoltan Haindrich
        3. HIVE-18163.01.patch
          57 kB
          Zoltan Haindrich

        Issue Links

          blocks

          Sub-task - The sub-task of the issue HIVE-18149 Stats: rownum estimation from datasize underestimates in most cases

          • Major - Major loss of function.
          • Closed
          links to

          Web Link rb

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: