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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: