Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 77229 invoked from network); 24 Jun 2009 09:15:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 24 Jun 2009 09:15:18 -0000 Received: (qmail 52757 invoked by uid 500); 24 Jun 2009 09:15:29 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 52723 invoked by uid 500); 24 Jun 2009 09:15:29 -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 52713 invoked by uid 99); 24 Jun 2009 09:15:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Jun 2009 09:15:29 +0000 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, 24 Jun 2009 09:15:27 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 5DA4F234C004 for ; Wed, 24 Jun 2009 02:15:07 -0700 (PDT) Message-ID: <891913185.1245834907369.JavaMail.jira@brutus> Date: Wed, 24 Jun 2009 02:15:07 -0700 (PDT) From: "Yongqiang He (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Updated: (HIVE-560) column pruning not working with map joins In-Reply-To: <1708317526.1245098647655.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yongqiang He updated HIVE-560: ------------------------------ Attachment: hive-560-2009-06-24-normal(mapjoin-after-column-pruning).patch hive-560-2009-06-24-mapjoin-before-column-pruning.patch Modifed the code to let column pruning be independ with map join conversion. hive-560-2009-06-24-mapjoin-before-column-pruning.patch and hive-560-2009-06-24-normal(mapjoin-after-column-pruning).patch share the same set of modifications. They both passed tests in my local. hive-560-2009-06-24-mapjoin-before-column-pruning.patch is not created against truck. And in it, map join conversion is done before column prune started( by reordering them in optimizer). hive-560-2009-06-24-normal(mapjoin-after-column-pruning).patch is the one we needed and i retest and patched with truck code. > column pruning not working with map joins > ----------------------------------------- > > Key: HIVE-560 > URL: https://issues.apache.org/jira/browse/HIVE-560 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 0.4.0 > Reporter: Namit Jain > Assignee: Yongqiang He > Attachments: hive-560-2009-06-19-2.patch, hive-560-2009-06-19-5.patch, hive-560-2009-06-24-mapjoin-before-column-pruning.patch, hive-560-2009-06-24-normal(mapjoin-after-column-pruning).patch > > > drop table tst1; > drop table tst2; > create table tst1(a1 string, a2 string, a3 string, a4 string); > create table tst2(b1 string, b2 string, b3 string, b4 string); > explain select /*+ MAPJOIN(a) */ a.a1, a.a2 from tst1 a join tst2 b ON a.a2=b.b2; > the select is after the join - column pruning is not happening -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.