[HIVE-23189] Change Explain ANALYZE to Explain PROFILE

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Target Version/s: 4.0.0
• Assignee: David Mollitor
• Reporter: David Mollitor
• Created: 13/Apr/20 15:17
• Updated: 14/Apr/20 13:20
• Resolved: 14/Apr/20 13:20

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

Issue Links

• blocks: HIVE-23187 Make TABLE Token Optional in ANALYZE Statement
• is related to: HIVE-14362 Support explain analyze in Hive