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
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.
-
You can reply to this email to add a comment to the issue online.
