[jira] [Commented] (HIVE-494) Select columns by index instead of name

["Edward Capriolo (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13735746#comment-13735746 ] 

Edward Capriolo commented on HIVE-494:
--------------------------------------

[~cwsteinbach] [~navis]

I think we should commit this. 
* it is impossible to name a column 1
* it is impossible to name a column alias 1

If order by supports this I do not see group by can't? Do we want to reconsider this?I kinda like the feature.

                
> 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: ASF.LICENSE.NOT.GRANTED--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
For more information on JIRA, see: http://www.atlassian.com/software/jira