Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@locus.apache.org Received: (qmail 94601 invoked from network); 7 Jan 2009 13:39:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Jan 2009 13:39:05 -0000 Received: (qmail 67448 invoked by uid 500); 7 Jan 2009 13:39:05 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 67431 invoked by uid 500); 7 Jan 2009 13:39:05 -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 67418 invoked by uid 99); 7 Jan 2009 13:39:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2009 05:39:05 -0800 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED 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; Wed, 07 Jan 2009 13:39:04 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 510B1234C48D for ; Wed, 7 Jan 2009 05:38:44 -0800 (PST) Message-ID: <1094504637.1231335524330.JavaMail.jira@brutus> Date: Wed, 7 Jan 2009 05:38:44 -0800 (PST) From: "Ashish Thusoo (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-22) Output invalid when choose all columns from left table of a join MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-22?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661561#action_12661561 ] Ashish Thusoo commented on HIVE-22: ----------------------------------- I believe that this has been fixed by Namit. > Output invalid when choose all columns from left table of a join > ----------------------------------------------------------------- > > Key: HIVE-22 > URL: https://issues.apache.org/jira/browse/HIVE-22 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor > Reporter: Joey Pan > > Here is what I observed, in a hive command: from ad_stat2 join ad on(ad_stat2.ad_id=ad.ad_id) select ad_stat2.*, ad.ad_id where ad_stat2.ad_clk>1000; > In the command, 2 tables are involved, the observation is if the output includes all columns of left table(ad_stat2.*), then no matter what columns you pick for the right table, it will print out all columns of right table. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.