hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <>
Subject [jira] [Commented] (HIVE-494) Select columns by index instead of name
Date Tue, 24 Jun 2014 18:04:27 GMT


Xuefu Zhang commented on HIVE-494:

Yeah. I think this is useful, as long as it doesn't bring ambiguity. Original original proposal
of table[0] notation is ambiguous, but the current table.$0 is good. Also, we should make
sure that Hive emits an error message in case $0 cannot be uniquely identified such as in
a join, similar to the case where a column's name cannot be uniquely identified.

> 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: ASF.LICENSE.NOT.GRANTED--HIVE-494.D1641.1.patch, HIVE-494.2.patch.txt,
> 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 was sent by Atlassian JIRA

View raw message