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)