[jira] Created: (HIVE-494) Select columns by number instead of name

["Adam Kramer (JIRA)" <ji...@apache.org>]

Select columns by number instead of name
----------------------------------------

                 Key: HIVE-494
                 URL: https://issues.apache.org/jira/browse/HIVE-494
             Project: Hadoop Hive
          Issue Type: Wish
          Components: Clients, Query Processor
            Reporter: Adam Kramer


In a very real sense, tables are like arrays or matrices with rows and columns. IT would be fantastic if I could refer to columns in my select statement by their index, rather than by their name.

SELECT mytable[0], mytable[2] FROM some_table_name mytable;

...which would then get the first and third column from mytable. We already have syntax like this for array data types, which I think would translate nicely: SELECT mytable[0][3], etc.

Or maybe I just spend too much time coding in R...

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.