Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2BDF11839A for ; Thu, 29 Oct 2015 00:18:55 +0000 (UTC) Received: (qmail 25929 invoked by uid 500); 28 Oct 2015 23:18:54 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 25873 invoked by uid 500); 28 Oct 2015 23:18:54 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 25861 invoked by uid 99); 28 Oct 2015 23:18:54 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Oct 2015 23:18:54 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 13C641A2904 for ; Wed, 28 Oct 2015 23:18:54 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.88 X-Spam-Level: ** X-Spam-Status: No, score=2.88 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id IwfZCXrKUdW5 for ; Wed, 28 Oct 2015 23:18:48 +0000 (UTC) Received: from mail-yk0-f169.google.com (mail-yk0-f169.google.com [209.85.160.169]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 50E43439F2 for ; Wed, 28 Oct 2015 23:18:48 +0000 (UTC) Received: by ykft191 with SMTP id t191so25165521ykf.0 for ; Wed, 28 Oct 2015 16:18:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=3wD/yPrApKyMW2PxujPRW5qCWLu/MFhOMtJ7U3zID+M=; b=jA1e52e+Ssotf0FiMUmrHPFvZymyeVjevbSm8Qk35u91Xz4kZObOeD7hhHKoKcAecO 98PRnvNhMevz8ju5ncT4z94Uy2XfGpEVnyVS0yx4+tgoBqkLAoj1K2LNMClcwfYssJei 9WJg5/l1Docfx2j2Qfw8xQO/CeGGxCtFFSx7TxMOS+zOM2Ze/6UJsa+iqPJS1aJAD3c3 CIFBi0eQzrKLRZV0ESUp9ta0QrYUumT8lj+GWqdbNBF9eCJGOcjwa4e9TiaQwTVal6py RpbSDilzSMTYJ25X+2OjD3kOE+Z+rGtTpmnZoykQ8Jzs1shAHtENT7EziqQTSge41lED 1F7w== X-Received: by 10.13.216.212 with SMTP id a203mr36151716ywe.112.1446074327825; Wed, 28 Oct 2015 16:18:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.37.209.215 with HTTP; Wed, 28 Oct 2015 16:18:28 -0700 (PDT) In-Reply-To: References: From: Hanifi GUNES Date: Wed, 28 Oct 2015 16:18:28 -0700 Message-ID: Subject: Re: setting planner max width To: dev@drill.apache.org Content-Type: multipart/alternative; boundary=001a114e6e7ca100df0523326a05 --001a114e6e7ca100df0523326a05 Content-Type: text/plain; charset=UTF-8 Yup. That makes sense. All ~150 minor fragments seem under a sing;e major fragment though. I should dig in further to see what's going on here. -H+ 2015-10-28 16:14 GMT-07:00 Jacques Nadeau : > Max width per node is per major fragment per node, not per query. > > So you should see no more than 60 minor fragments for any particular major > fragment. > > Remember that in most cases, a multi-major-fragment query has blocking > operations in it. > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Wed, Oct 28, 2015 at 4:11 PM, Hanifi GUNES wrote: > > > On a 10 node cluster, I am executing a query with the following > > > > *alter session set `planner.width.max_per_node`=6;* > > > > and see 153 minor fragments reported in the profiles tab whereas I would > > expect a max parallelization of 60 cluster-wide. > > > > Is not this option bounding the max # of threads per query per node? > Need a > > second look here. > > > > > > Thanks. > > -Hanifi > > > --001a114e6e7ca100df0523326a05--