You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Phabricator (Updated) (JIRA)" <ji...@apache.org> on 2012/02/08 09:10:01 UTC
[jira] [Updated] (HIVE-494) Select columns by index instead of name
[ https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-494:
-----------------------------
Attachment: HIVE-494.D1641.1.patch
navis requested code review of "HIVE-494 [jira] Select columns by index instead of name".
Reviewers: JIRA
DPAL-732 Select columns by index instead of name
SELECT mytable<span class="error">[0]</span>, mytable<span class="error">[2]</span> FROM some_table_name mytable;
...should return the first and third columns, respectively, from mytable regardless of their column names.
The need for "names" specifically is kind of silly when they just get translated into numbers anyway.
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D1641
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
ql/src/test/queries/clientpositive/select_by_column_index.q
ql/src/test/results/clientpositive/select_by_column_index.q.out
MANAGE HERALD DIFFERENTIAL RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/3501/
Tip: use the X-Herald-Rules header to filter Herald messages in your client.
> Select columns by index instead of name
> ---------------------------------------
>
> Key: HIVE-494
> URL: https://issues.apache.org/jira/browse/HIVE-494
> Project: Hive
> Issue Type: Wish
> Components: Clients, Query Processor
> Reporter: Adam Kramer
> Priority: Minor
> Labels: SQL
> Attachments: HIVE-494.D1641.1.patch
>
>
> SELECT mytable[0], mytable[2] FROM some_table_name mytable;
> ...should return the first and third columns, respectively, from mytable regardless of their column names.
> The need for "names" specifically is kind of silly when they just get translated into numbers anyway.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira