[
https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14042453#comment-14042453
]
Xuefu Zhang commented on HIVE-494:
----------------------------------
Yeah. I think this is useful, as long as it doesn't bring ambiguity. Original
original proposal of table[0] notation is ambiguous, but the current table.$0
is good. Also, we should make sure that Hive emits an error message in case $0
cannot be uniquely identified such as in a join, similar to the case where a
column's name cannot be uniquely identified.
> 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: ASF.LICENSE.NOT.GRANTED--HIVE-494.D1641.1.patch,
> HIVE-494.2.patch.txt, HIVE-494.D12153.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 was sent by Atlassian JIRA
(v6.2#6252)
