Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 24 Jun 2014 18:04:27 +0000 (UTC)
From: "Xuefu Zhang (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12425752.1242672685019.38883.1403633067569@arcas>
In-Reply-To: <JIRA.12425752.1242672685019@arcas>
References: <JIRA.12425752.1242672685019@arcas>
Subject: [jira] [Commented] (HIVE-494) Select columns by index instead of
 name
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14042453#comment-14042453 ] 

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: https://issues.apache.org/jira/browse/HIVE-494
>             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, HIVE-494.D12153.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 was sent by Atlassian JIRA
(v6.2#6252)