[jira] [Updated] (HIVE-23189) Change Explain ANALYZE to Explain PROFILE
[ https://issues.apache.org/jira/browse/HIVE-23189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Mollitor updated HIVE-23189: -- Resolution: Not A Bug Status: Resolved (was: Patch Available) > 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 > Attachments: HIVE-23189.1.patch > > > {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)
[jira] [Updated] (HIVE-23189) Change Explain ANALYZE to Explain PROFILE
[ https://issues.apache.org/jira/browse/HIVE-23189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Mollitor updated HIVE-23189: -- Status: Patch Available (was: Open) > 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 > Attachments: HIVE-23189.1.patch > > > {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)
[jira] [Updated] (HIVE-23189) Change Explain ANALYZE to Explain PROFILE
[ https://issues.apache.org/jira/browse/HIVE-23189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Mollitor updated HIVE-23189: -- Attachment: HIVE-23189.1.patch > 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 > Attachments: HIVE-23189.1.patch > > > {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)
[jira] [Updated] (HIVE-23189) Change Explain ANALYZE to Explain PROFILE
[ 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)