Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 302B5200C0D for ; Tue, 31 Jan 2017 17:50:19 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 2ED53160B52; Tue, 31 Jan 2017 16:50:19 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 743B2160B36 for ; Tue, 31 Jan 2017 17:50:18 +0100 (CET) Received: (qmail 17417 invoked by uid 500); 31 Jan 2017 16:50:17 -0000 Mailing-List: contact dev-help@quickstep.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@quickstep.incubator.apache.org Delivered-To: mailing list dev@quickstep.incubator.apache.org Received: (qmail 17406 invoked by uid 99); 31 Jan 2017 16:50:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2017 16:50:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id D97EBC0D5C for ; Tue, 31 Jan 2017 16:50:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -7.019 X-Spam-Level: X-Spam-Status: No, score=-7.019 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 5tmT51lwQZKW for ; Tue, 31 Jan 2017 16:50:16 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id 8FA165F239 for ; Tue, 31 Jan 2017 16:50:15 +0000 (UTC) Received: (qmail 16213 invoked by uid 99); 31 Jan 2017 16:49:56 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2017 16:49:56 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id C6710DFD71; Tue, 31 Jan 2017 16:49:56 +0000 (UTC) From: jianqiao To: dev@quickstep.incubator.apache.org Reply-To: dev@quickstep.incubator.apache.org References: In-Reply-To: Subject: [GitHub] incubator-quickstep pull request #174: Push down disjunctive predicates to f... Content-Type: text/plain Message-Id: <20170131164956.C6710DFD71@git1-us-west.apache.org> Date: Tue, 31 Jan 2017 16:49:56 +0000 (UTC) archived-at: Tue, 31 Jan 2017 16:50:19 -0000 Github user jianqiao commented on a diff in the pull request: https://github.com/apache/incubator-quickstep/pull/174#discussion_r98714161 --- Diff: query_optimizer/PhysicalGenerator.cpp --- @@ -108,6 +109,7 @@ P::PhysicalPtr PhysicalGenerator::generateInitialPlan( P::PhysicalPtr PhysicalGenerator::optimizePlan() { std::vector>> rules; rules.emplace_back(new PruneColumns()); + rules.emplace_back(new PushDownLowCostDisjunctivePredicate()); --- End diff -- Oh I made a mistake that actually the `InjectFilterJoin` optimization will not generate unnecessary `Selection`s, but `PushDownLowCostDisjunctivePredicate` may generate two `Selection`s in a chain. Currently this is a not an issue since the `Selection`s for tables with cardinality around 100 are very light-weight. We may add a `FuseSelection` optimization later. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastructure@apache.org or file a JIRA ticket with INFRA. ---