You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Phabricator (Updated) (JIRA)" <ji...@apache.org> on 2012/02/08 09:10:01 UTC

[jira] [Updated] (HIVE-494) Select columns by index instead of name

     [ https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phabricator updated HIVE-494:
-----------------------------

    Attachment: HIVE-494.D1641.1.patch

navis requested code review of "HIVE-494 [jira] Select columns by index instead of name".
Reviewers: JIRA

  DPAL-732 Select columns by index instead of name

  SELECT mytable<span class="error">[0]</span>, mytable<span class="error">[2]</span> 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.

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D1641

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
  ql/src/test/queries/clientpositive/select_by_column_index.q
  ql/src/test/results/clientpositive/select_by_column_index.q.out

MANAGE HERALD DIFFERENTIAL RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/3501/

Tip: use the X-Herald-Rules header to filter Herald messages in your client.

                
> 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
>            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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira