hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From " (JIRA)" <>
Subject [jira] [Commented] (HIVE-1916) Change Default Alias For Aggregated Columns (_c1)
Date Tue, 09 Aug 2011 22:41:29 GMT

] commented on HIVE-1916:

This is an automatically generated e-mail. To reply, visit:

Review request for hive and Ning Zhang.


Default behavior will be as before.
Adding new Hive conf vars to make the column names include the aggregation function and params.

This addresses bug HIVE-1916.


  trunk/common/src/java/org/apache/hadoop/hive/conf/ 1155181 
  trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ 1155181 
  trunk/ql/src/test/queries/clientpositive/autogen_colname.q PRE-CREATION 
  trunk/ql/src/test/results/clientpositive/autogen_colname.q.out PRE-CREATION 



Added new query file with expected results. All unit tests pass



> Change Default Alias For Aggregated Columns (_c1)
> -------------------------------------------------
>                 Key: HIVE-1916
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>         Environment: All
>            Reporter: James Mayfield
>            Priority: Minor
> 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:


View raw message