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 2011/08/05 09:54:27 UTC

[jira] [Updated] (HIVE-2283) Backtracking real column names for EXPLAIN output

     [ https://issues.apache.org/jira/browse/HIVE-2283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Navis updated HIVE-2283:
------------------------

    Attachment: HIVE-2283.3.patch

explains GBY aggregation, etc.

> 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.3.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