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

Support explain analyze in Hive

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0
    • 2.2.0
    • None
    • None

    Description

      Right now all the explain levels only support stats before query runs. We would like to have an explain analyze similar to Postgres for real stats after query runs. This will help to identify the major gap between estimated/real stats and make not only query optimization better but also query performance debugging easier.

      Attachments

        1. HIVE-14362.01.patch
          872 kB
          Pengcheng Xiong
        2. compare_on_cluster.pdf
          35 kB
          Pengcheng Xiong
        3. HIVE-14362.02.patch
          876 kB
          Pengcheng Xiong
        4. HIVE-14362.03.patch
          965 kB
          Pengcheng Xiong
        5. HIVE-14362.05.patch
          971 kB
          Pengcheng Xiong
        6. HIVE-14362.06.patch
          1.11 MB
          Pengcheng Xiong

        Issue Links

          relates to

          Sub-task - The sub-task of the issue HIVE-15084 Flaky test: TestMiniTezCliDriver:explainanalyze_1,2, 3, 4, 5

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-23189 Change Explain ANALYZE to Explain PROFILE

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

          Web Link RB

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: