hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2283) Backtracking real column names for EXPLAIN output
Date Mon, 25 Jul 2011 06:19:10 GMT

    [ https://issues.apache.org/jira/browse/HIVE-2283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070328#comment-13070328
] 

Navis commented on HIVE-2283:
-----------------------------

This patch would change the output of the explain query and, doubtedly, would make fail other
test cases. Making some option switching the explain mode would be appropriate, but doing
that was not so clean (redundant code, etc.) as it was seemed to be. 

I've just laid this down and waiting opinion of others.

> Backtracking real column names for EXPLAIN output
> -------------------------------------------------
>
>                 Key: HIVE-2283
>                 URL: https://issues.apache.org/jira/browse/HIVE-2283
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>    Affects Versions: 0.8.0
>            Reporter: Navis
>            Priority: Minor
>         Attachments: HIVE-2283.1.patch, HIVE-2283.2.patch, HIVE-2283.test.patch
>
>
> GUI people suggested that showing real column names for result of EXPLAIN statement would
make customers feel more comfortable with HIVE. I agreed and working on it. 
> {code}
> a. current EXPLAIN
>  Select Operator
>    expressions:
>      expr: _col10
>      type: int
>      expr: _col17
>      type: string
>    Group By Operator
>      keys:
>        expr: _col0
>        type: int
>        expr: _col17
>        type: int
> b. suggested EXPLAIN
>  Select Operator
>    expressions: _col10=t2.key_int1, _col17=upper(t1.key_int1), _col22=t3.key_string2
>    Group By Operator
>      keys: _col10=t2.key_int1, _col17=upper(t1.key_int1)
> {code}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message