hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-494) Select columns by number instead of name
Date Mon, 18 May 2009 18:51:45 GMT
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.

View raw message