hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <>
Subject [jira] [Commented] (HIVE-494) Select columns by index instead of name
Date Thu, 26 Apr 2012 05:17:39 GMT


Navis commented on HIVE-494:

I've completely forgotten this patch and looking into it newly. 

1. It seemed not a standard SQL and also could be confusional especially with join/unions.

2. The patch is using RR of input operator but it's clearly not correct.

Could it be worth to be implemented?
> Select columns by index instead of name
> ---------------------------------------
>                 Key: HIVE-494
>                 URL:
>             Project: Hive
>          Issue Type: Wish
>          Components: Clients, Query Processor
>            Reporter: Adam Kramer
>            Assignee: Navis
>            Priority: Minor
>              Labels: SQL
>         Attachments: 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:!default.jspa
For more information on JIRA, see:


View raw message