You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2013/03/29 11:17:15 UTC
[jira] [Updated] (HIVE-4258) Log logical plan tree for debugging
[ https://issues.apache.org/jira/browse/HIVE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-4258:
------------------------
Description:
Debugging or implementing optimizer, knowing the shape of logical plan helps general progress of it.
For example,
select count(val) from (select a.key as key, b.value as array_val from src a join array_valued_src b on a.key=b.key) i lateral view explode (array_val) c as val
{noformat}
TS[1]-RS[2]-JOIN[4]-SEL[5]-LVF[6]-SEL[7]-LVJ[10]-SEL[11]-GBY[12]-RS[13]-GBY[14]-SEL[15]-FS[16]
-SEL[8]-UDTF[9]-LVJ[10]
TS[0]-RS[3]-JOIN[4]
{noformat}
was:
Debugging or implementing optimizer, knowing the shape of logical plan helps general progress of it.
For example,
select count(val) from (select a.key as key, b.value as array_val from src a join array_valued_src b on a.key=b.key) i lateral view explode (array_val) c as val
<noformat>
TS[1]-RS[2]-JOIN[4]-SEL[5]-LVF[6]-SEL[7]-LVJ[10]-SEL[11]-GBY[12]-RS[13]-GBY[14]-SEL[15]-FS[16]
-SEL[8]-UDTF[9]-LVJ[10]
TS[0]-RS[3]-JOIN[4]
<noformat>
> Log logical plan tree for debugging
> -----------------------------------
>
> Key: HIVE-4258
> URL: https://issues.apache.org/jira/browse/HIVE-4258
> Project: Hive
> Issue Type: Improvement
> Components: Diagnosability
> Reporter: Navis
> Assignee: Navis
> Priority: Trivial
> Attachments: HIVE-4258.D9801.1.patch
>
>
> Debugging or implementing optimizer, knowing the shape of logical plan helps general progress of it.
> For example,
> select count(val) from (select a.key as key, b.value as array_val from src a join array_valued_src b on a.key=b.key) i lateral view explode (array_val) c as val
> {noformat}
> TS[1]-RS[2]-JOIN[4]-SEL[5]-LVF[6]-SEL[7]-LVJ[10]-SEL[11]-GBY[12]-RS[13]-GBY[14]-SEL[15]-FS[16]
> -SEL[8]-UDTF[9]-LVJ[10]
> TS[0]-RS[3]-JOIN[4]
> {noformat}
--
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