[jira] [Updated] (HIVE-23189) Change Explain ANALYZE to Explain PROFILE

["David Mollitor (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-23189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Mollitor updated HIVE-23189:
----------------------------------
    Target Version/s: 4.0.0

> 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
>            Priority: Major
>
> {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)