Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 30 Jul 2013 22:45:51 +0000 (UTC)
From: "Phabricator (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12532576.1322109499060.140282.1375224351039@arcas>
In-Reply-To: <JIRA.12532576.1322109499060@arcas>
References: <JIRA.12532576.1322109499060@arcas>
Subject: [jira] [Updated] (HIVE-2608) Do not require AS a,b,c part in
 LATERAL VIEW
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Phabricator updated HIVE-2608:
------------------------------

    Attachment: HIVE-2608.D4317.7.patch

navis updated the revision "HIVE-2608 [jira] Do not require AS a,b,c part in LATERAL VIEW".

  Marked '@Deprecated' for error message which would not be used further

Reviewers: ashutoshc, JIRA

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

CHANGE SINCE LAST DIFF
  https://reviews.facebook.net/D4317?vs=35643&id=36597#toc

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/test/queries/clientpositive/lateral_view_noalias.q
  ql/src/test/results/clientpositive/lateral_view_noalias.q.out

To: JIRA, ashutoshc, navis
Cc: ikabiljo

                
> Do not require AS a,b,c part in LATERAL VIEW
> --------------------------------------------
>
>                 Key: HIVE-2608
>                 URL: https://issues.apache.org/jira/browse/HIVE-2608
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor, UDF
>            Reporter: Igor Kabiljo
>            Assignee: Navis
>            Priority: Minor
>         Attachments: HIVE-2608.8.patch.txt, HIVE-2608.D4317.5.patch, HIVE-2608.D4317.6.patch, HIVE-2608.D4317.7.patch
>
>
> Currently, it is required to state column names when LATERAL VIEW is used.
> That shouldn't be necessary, since UDTF returns struct which contains column names - and they should be used by default.
> For example, it would be great if this was possible:
> SELECT t.*, t.key1 + t.key4
> FROM some_table
> LATERAL VIEW JSON_TUPLE(json, 'key1', 'key2', 'key3', 'key3') t;

--
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