Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 8754 invoked from network); 10 Dec 2009 06:38:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Dec 2009 06:38:45 -0000 Received: (qmail 73171 invoked by uid 500); 10 Dec 2009 06:38:45 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 73034 invoked by uid 500); 10 Dec 2009 06:38:43 -0000 Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-dev@hadoop.apache.org Received: (qmail 73017 invoked by uid 99); 10 Dec 2009 06:38:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Dec 2009 06:38:43 +0000 X-ASF-Spam-Status: No, hits=-6.5 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Dec 2009 06:38:38 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 2BE2B234C1E9 for ; Wed, 9 Dec 2009 22:38:18 -0800 (PST) Message-ID: <326430245.1260427098145.JavaMail.jira@brutus> Date: Thu, 10 Dec 2009 06:38:18 +0000 (UTC) From: "Namit Jain (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-935) support LATERAL VIEW In-Reply-To: <74073126.1258394979786.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12788542#action_12788542 ] Namit Jain commented on HIVE-935: --------------------------------- Also, would it be possible to add the following tests: 1. A negative test where the explode is returning 2 columns, but you have specified 2 aliases. 2. A positive test where 2 column aliases are being returned - you can add a dummy function in contrib/test which returns the same value twice. > support LATERAL VIEW > -------------------- > > Key: HIVE-935 > URL: https://issues.apache.org/jira/browse/HIVE-935 > Project: Hadoop Hive > Issue Type: New Feature > Components: Query Processor > Reporter: Namit Jain > Assignee: Paul Yang > Attachments: HIVE-935.1.patch, HIVE-935.2.patch, HIVE-935.3.patch, HIVE-935.4.patch, HIVE-935.5.patch, HIVE-935.6.patch, HIVE-935.7.patch > > > For table functions, the following syntax should be supported > select ... from T LATERAL VIEW explode(adid_list) as adid,... -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.