You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2008/12/11 00:18:44 UTC
[jira] Commented: (HIVE-153) explain should give meaningful column
names
[ https://issues.apache.org/jira/browse/HIVE-153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655413#action_12655413 ]
Zheng Shao commented on HIVE-153:
---------------------------------
Basically, we should use meaningful names for internal names whenever possible, instead of using numbers like 0, 1, 2, etc.
> explain should give meaningful column names
> -------------------------------------------
>
> Key: HIVE-153
> URL: https://issues.apache.org/jira/browse/HIVE-153
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Zheng Shao
>
> Currently explain uses numbers like "1" to represent the columns.
> It will be much better to print out the real name of the columns.
> hive> explain FROM table a SELECT a.country as b, count(1) as c WHERE a.ds='2008-12-09' GROUP BY a.country;
> ...
> Select Operator
> expressions:
> expr: country
> type: string
> expr: ds
> type: string
> Filter Operator
> predicate:
> expr: (1 = '2008-12-09')
> type: boolean
> Reduce Output Operator
> key expressions:
> expr: 0
> type: string
> sort order: +
> Map-reduce partition columns:
> expr: rand()
> type: double
> tag: -1
> value expressions:
> expr: 1
> type: int
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.