You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ning Zhang (JIRA)" <ji...@apache.org> on 2011/08/16 06:26:28 UTC
[jira] [Assigned] (HIVE-1916) Change Default Alias For Aggregated
Columns (_c1)
[ https://issues.apache.org/jira/browse/HIVE-1916?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ning Zhang reassigned HIVE-1916:
--------------------------------
Assignee: Sameer M
> Change Default Alias For Aggregated Columns (_c1)
> -------------------------------------------------
>
> Key: HIVE-1916
> URL: https://issues.apache.org/jira/browse/HIVE-1916
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Environment: All
> Reporter: James Mayfield
> Assignee: Sameer M
> Priority: Minor
> Attachments: HIVE-1916.3.patch.txt
>
>
> Problem:
> When running a Hive query that aggregates (does a group by operation), Hive will automatically name this column _c0, _c1, _c2, etc.. This is a problem because Hive will not then execute a query against a column that begins with "_" and then the user has to manually input back-ticks in order to get the query to run.
> Potential Solution:
> Hive should by default call these columns by their query assignment like "sum_active30day_users" or if that is not possible, call it something simple like "column_1" so that users can then query the new column without adding special back-ticks.
> Example Query:
> SELECT a.ds, COUNT(a.num_accounts)
> Example Result:
> ds, count_num_accounts OR ds, column_1
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira