Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 87E5611C5F for ; Thu, 3 Jul 2014 16:10:55 +0000 (UTC) Received: (qmail 26292 invoked by uid 500); 3 Jul 2014 16:10:53 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 26260 invoked by uid 500); 3 Jul 2014 16:10:53 -0000 Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.incubator.apache.org Delivered-To: mailing list issues@drill.incubator.apache.org Received: (qmail 26251 invoked by uid 99); 3 Jul 2014 16:10:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jul 2014 16:10:53 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 03 Jul 2014 16:10:47 +0000 Received: (qmail 25586 invoked by uid 99); 3 Jul 2014 16:10:27 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jul 2014 16:10:27 +0000 Date: Thu, 3 Jul 2014 16:10:27 +0000 (UTC) From: "Jinfeng Ni (JIRA)" To: issues@drill.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DRILL-1102) Use same set of keys to distribute rows when planner generates exchange for a join operator. 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/DRILL-1102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14051625#comment-14051625 ] Jinfeng Ni commented on DRILL-1102: ----------------------------------- Yes, I think so. I run the smoking test (TPCH on SF1) and the automation test. No regression found. On Thu, Jul 3, 2014 at 5:43 AM, Aditya Kishore (JIRA) > Use same set of keys to distribute rows when planner generates exchange for a join operator. > --------------------------------------------------------------------------------------------- > > Key: DRILL-1102 > URL: https://issues.apache.org/jira/browse/DRILL-1102 > Project: Apache Drill > Issue Type: Bug > Reporter: Jinfeng Ni > Assignee: Jinfeng Ni > > Today, planner might use a different key sets when generate hash-to-random exchange operator for a join's left and right side. > For instance, if we have join condition : > L1 = R1 and L2 = R2, > Planner may generate a plan where the join's left side is hash distributed using L1, while the right side is hash distributed using (R1, R2). Such plan is not valid, since it would produce wrong query result. > To do that, we need make sure the planner will use the same set of keys when ask for hash distribution for a join's left and right side. -- This message was sent by Atlassian JIRA (v6.2#6252)