David Mollitor created HIVE-23189:
-------------------------------------

             Summary: Change Explain ANALYZE to Explain PROFILE
                 Key: HIVE-23189
                 URL: https://issues.apache.org/jira/browse/HIVE-23189
             Project: Hive
          Issue Type: Improvement
            Reporter: David Mollitor
            Assignee: David Mollitor


{code:none}
EXPLAIN [EXTENDED|CBO|AST|DEPENDENCY|AUTHORIZATION|LOCKS|VECTORIZATION|ANALYZE] 
query
{code}

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,...

{code:sql}
EXPLAIN ANALYZE ANALYZE TABLE `myTable` COMPUTE STATISTICS;
{code}

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).




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to