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/07/15 02:52:01 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:
------------------------
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