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 (JIRA)" <ji...@apache.org> on 2013/08/22 08:40:52 UTC

[jira] [Updated] (HIVE-4204) Support ellipsis for selecting multiple columns

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

Phabricator updated HIVE-4204:
------------------------------

    Attachment: HIVE-4204.D9549.4.patch

navis updated the revision "HIVE-4204 [jira] Support ellipsis for selecting multiple columns".

  Rebased to trunk

Reviewers: JIRA

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

CHANGE SINCE LAST DIFF
  https://reviews.facebook.net/D9549?vs=35709&id=38607#toc

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/ColumnInfo.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckCtx.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
  ql/src/test/queries/clientnegative/allcolref_from_tablealias.q
  ql/src/test/queries/clientpositive/allcolref_from.q
  ql/src/test/results/clientnegative/allcolref_from_tablealias.q.out
  ql/src/test/results/clientpositive/allcolref_from.q.out

To: JIRA, navis

                
> Support ellipsis for selecting multiple columns
> -----------------------------------------------
>
>                 Key: HIVE-4204
>                 URL: https://issues.apache.org/jira/browse/HIVE-4204
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Trivial
>         Attachments: HIVE-4204.D9549.1.patch, HIVE-4204.D9549.2.patch, HIVE-4204.D9549.3.patch, HIVE-4204.D9549.4.patch
>
>
> Some UDF should take all columns starting from second or third one and in this case, star argument(HIVE-3490) cannot be used. It's not pleasant to specify all of them especially when the table has many of columns. For example,
> {noformat}
> select some_udtf(a2,a3,a4,a5,a6) as (a2,a3,a4,a5,a6) from table;
> {noformat}
> it can be simplified to 
> {noformat}
> select some_udtf(a2...) as (a2,a3,a4,a5,a6) from table;
> {noformat}
> if HIVE-2608 would be committed, it can be simplified further 
> {noformat}
> select some_udtf(a2...) from table;
> {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira