[
https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262373#comment-13262373
]
Phabricator commented on HIVE-494:
----------------------------------
cwsteinbach has commented on the revision "HIVE-494 [jira] Select columns by
index instead of name".
INLINE COMMENTS
ql/src/test/queries/clientpositive/select_by_column_index.q:2 Is this syntax
part of the SQL standard, or is it an extension specific to Hive?
ql/src/test/queries/clientpositive/select_by_column_index.q:5 Please add
coverage for JOINs, ORDER BY, HAVING, and UNION clauses, and a negative
testcase that shows what happens when an invalid index is referenced.
REVISION DETAIL
https://reviews.facebook.net/D1641
> 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
> Assignee: Navis
> 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
