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

Change Explain ANALYZE to Explain PROFILE

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • None
    • None
    • None
    • None

    Description

      EXPLAIN [EXTENDED|CBO|AST|DEPENDENCY|AUTHORIZATION|LOCKS|VECTORIZATION|ANALYZE] query
      

      https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain#LanguageManualExplain-TheANALYZEClause

      In Hive, there is an EXPLAIN ANALYZE query. This can get a bit confusing because you can run an EXPLAIN ANALYZE against an ANALYZE TABLE statement, so you have something like,...

      EXPLAIN ANALYZE ANALYZE TABLE `myTable` COMPUTE STATISTICS;
      

      I would like to propose that the name be changed to EXPLAIN PROFILE. This borrows from Apache Impala because it has a PROFILE command which produces the stats that actually occurred during the query run (much like this Hive feature).

      Attachments

        1. HIVE-23189.1.patch
          99 kB
          David Mollitor

        Issue Links

          Activity

            People

              belugabehr David Mollitor
              belugabehr David Mollitor
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: