[
https://issues.apache.org/jira/browse/HIVE-3925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13578194#comment-13578194
]
Navis commented on HIVE-3925:
-----------------------------
>explain select * from src order by key;
<noformat>
STAGE DEPENDENCIES:
Stage-1 [MAPRED] is a root stage
Stage-0 [ FETCH] depends on stages: Stage-1
<noformat>
>set hive.auto.convert.join = true;
>explain
select sum(hash(a.k1,a.v1,a.k2, a.v2))
from (
SELECT src1.key as k1, src1.value as v1,
src2.key as k2, src2.value as v2 FROM
(SELECT * FROM src WHERE src.key < 10) src1
JOIN
(SELECT * FROM src WHERE src.key < 10) src2
SORT BY k1, v1, k2, v2
) a;
<noformat>
STAGE DEPENDENCIES:
Stage-7 [ CONDITION] is a root stage , consists of Stage-8, Stage-9, Stage-1
Stage-8 [MAPREDLOCAL] has a backup stage: Stage-1
Stage-5 [ MAPRED] depends on stages: Stage-8
Stage-2 [ MAPRED] depends on stages: Stage-1, Stage-5, Stage-6
Stage-3 [ MAPRED] depends on stages: Stage-2
Stage-0 [ FETCH] depends on stages: Stage-3
Stage-9 [MAPREDLOCAL] has a backup stage: Stage-1
Stage-6 [ MAPRED] depends on stages: Stage-9
Stage-1 [ MAPRED]
<noformat>
> dependencies of fetch task are not shown by explain
> ---------------------------------------------------
>
> Key: HIVE-3925
> URL: https://issues.apache.org/jira/browse/HIVE-3925
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
> Attachments: HIVE-3925.D8577.1.patch, HIVE-3925.D8577.2.patch
>
>
> A simple query like:
> hive> explain select * from src order by key;
> OK
> ABSTRACT SYNTAX TREE:
> (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT
> (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR
> TOK_ALLCOLREF)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
> STAGE DEPENDENCIES:
> Stage-1 is a root stage
> Stage-0 is a root stage
> Stage: Stage-0
> Fetch Operator
> limit: -1
> Stage-0 is not a root stage and depends on stage-1.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
