[
https://issues.apache.org/jira/browse/HADOOP-4084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12633304#action_12633304
]
Hudson commented on HADOOP-4084:
--------------------------------
Integrated in Hadoop-trunk #611 (See
[http://hudson.zones.apache.org/hudson/job/Hadoop-trunk/611/])
> Add explain plan capabilities to Hive QL
> ----------------------------------------
>
> Key: HADOOP-4084
> URL: https://issues.apache.org/jira/browse/HADOOP-4084
> Project: Hadoop Core
> Issue Type: New Feature
> Components: contrib/hive
> Reporter: Ashish Thusoo
> Assignee: Ashish Thusoo
> Fix For: 0.19.0
>
> Attachments: patch-4084, patch-4084, patch-4084_v3
>
>
> Adding explain plan for queries in hive.
> The current proposal is to support something like:
> EXPLAIN [EXTENDED]
> SELECT ....
> This will output the following:
> Abstract Syntax Tree:
> Number of Stages:
> Dependencies between Stages:
> Plan for each stage:
> If EXTENDED keyword is used then much more information will be emitted where
> as without that keyword only logical information will be emitted.
> e.g. In case of a group by query
> EXPLAIN
> SELECT T.c1, count(1) FROM T GROUP BY T.c1;
> The explain plan itself has two stages
> Stage1 and Stage2
> Stage1 will have the plan for generating the partial aggregates
> and Stage2 will have the plan for generating the complete aggregates.
> I also plan to convert the parse and semantic analysis tests so that they use
> this for finding differences in the plan instead of the programmatic plan
> dumps that we are using today (tests/queries/positive).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
