[ 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)