From issues-return-70168-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Mon Jul 23 18:41:04 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 27249180677 for ; Mon, 23 Jul 2018 18:41:03 +0200 (CEST) Received: (qmail 87045 invoked by uid 500); 23 Jul 2018 16:41:03 -0000 Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list issues@ignite.apache.org Received: (qmail 87035 invoked by uid 99); 23 Jul 2018 16:41:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jul 2018 16:41:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id E0001C19A6 for ; Mon, 23 Jul 2018 16:41:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.501 X-Spam-Level: X-Spam-Status: No, score=-109.501 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id y9Kgr5VLa7JA for ; Mon, 23 Jul 2018 16:41:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 88A265F39F for ; Mon, 23 Jul 2018 16:41:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id C9D21E03EC for ; Mon, 23 Jul 2018 16:41:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 8DDDE2713E for ; Mon, 23 Jul 2018 16:41:00 +0000 (UTC) Date: Mon, 23 Jul 2018 16:41:00 +0000 (UTC) From: "Andrew Mashenkov (JIRA)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (IGNITE-8596) SQL: remove unnecessary index lookups when query parallelism is enabled 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/IGNITE-8596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Mashenkov reassigned IGNITE-8596: ---------------------------------------- Assignee: Andrew Mashenkov > SQL: remove unnecessary index lookups when query parallelism is enabled > ----------------------------------------------------------------------- > > Key: IGNITE-8596 > URL: https://issues.apache.org/jira/browse/IGNITE-8596 > Project: Ignite > Issue Type: Task > Components: sql > Affects Versions: 2.5 > Reporter: Vladimir Ozerov > Assignee: Andrew Mashenkov > Priority: Major > Labels: performance > Fix For: 2.7 > > > See {{org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor#onQueryRequest}} method. If table is segmented, we will submit as many SQL requests as much segments. But consider a case when target cache partition(s) is already defined by user or derived through partition pruning. In this case most of segments will not contain useful information and return empty result set. At the same time these queries may impose index or data page scans, thus consuming resources without a reason. > To mitigate the problem we should not submit SQL requests to segments we are not interested in. > Note that it is not sufficient to simply skip SQL requests on mapper, because reducer expects separate response for every message. We should fix both local mapper logic as well as protocol. -- This message was sent by Atlassian JIRA (v7.6.3#76005)