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.
