hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-2283) Backtracking real column names for EXPLAIN output
Date Fri, 15 Jul 2011 00:52:01 GMT

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

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

    Description: 
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}

  was:
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. 

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)



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