Return-Path: X-Original-To: apmail-incubator-drill-user-archive@minotaur.apache.org Delivered-To: apmail-incubator-drill-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 16E521750D for ; Tue, 11 Nov 2014 02:30:37 +0000 (UTC) Received: (qmail 51548 invoked by uid 500); 11 Nov 2014 02:30:36 -0000 Delivered-To: apmail-incubator-drill-user-archive@incubator.apache.org Received: (qmail 51481 invoked by uid 500); 11 Nov 2014 02:30:36 -0000 Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: drill-user@incubator.apache.org Delivered-To: mailing list drill-user@incubator.apache.org Received: (qmail 51465 invoked by uid 99); 11 Nov 2014 02:30:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Nov 2014 02:30:36 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of aengelbrecht@maprtech.com designates 209.85.192.179 as permitted sender) Received: from [209.85.192.179] (HELO mail-pd0-f179.google.com) (209.85.192.179) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Nov 2014 02:30:10 +0000 Received: by mail-pd0-f179.google.com with SMTP id g10so9024528pdj.24 for ; Mon, 10 Nov 2014 18:29:23 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:content-type:message-id:mime-version :subject:date:references:to:in-reply-to; bh=6nplsdJhs53HjV/n8yQzvSCX3jJBLMKoA/pYoYdSQ5k=; b=gSmjxdN6AIG86WUYBiJHUWLdJSz5/oLQwAXCrTo1aQaGUmiQFCgGB18bdqcFHHrw/t fSrKaYq/g4td/Gex/7qM8856sVZ4NIClpLDDRFjVcJlUDhRyjYBhj/8+rsFnQNIYYpZ4 FtOjvzH3oBInJwnIsiXUBI+hMW6Pfq+O/sgJOk6i/F5Mk16YGNuT6ZTw4W162DCYWm5F 56zymVEDjNXqbwnQ1FBIK8JrHRJqGqQvGmicT7IacDFqr2jxp5TS6bBhfY1+fUD3hFwf aC2zvvPoAuHujBZ7AF0bWWXYDhds/tvLq6s/AmVRfJza5/mfUQuzfpGYy4eq1Tq5TDGt 08bA== X-Gm-Message-State: ALoCoQlp2fAhAQazinadJmU4l9NAxkz036TVkgNxgb8M5JsE4O1A7N8a7I4rl3kj7oNsJDNk1rUN X-Received: by 10.66.147.227 with SMTP id tn3mr36399694pab.108.1415672963771; Mon, 10 Nov 2014 18:29:23 -0800 (PST) Received: from [10.250.20.248] (50-205-86-106-static.hfc.comcastbusiness.net. [50.205.86.106]) by mx.google.com with ESMTPSA id ub7sm17746532pbc.30.2014.11.10.18.29.22 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 10 Nov 2014 18:29:22 -0800 (PST) From: Andries Engelbrecht Content-Type: multipart/alternative; boundary="Apple-Mail=_255289FD-5D96-4739-815A-EFDF8E376C7C" Message-Id: Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\)) Subject: Re: Query execution using Drill views Date: Mon, 10 Nov 2014 18:29:16 -0800 References: <83DF99ED-8EAF-4A87-A2F7-BF4E73B0E690@maprtech.com> To: "drill-user@incubator.apache.org" In-Reply-To: X-Mailer: Apple Mail (2.1878.6) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_255289FD-5D96-4739-815A-EFDF8E376C7C Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Thanks, makes sense and wanted to verify. On Nov 10, 2014, at 6:00 PM, Ted Dunning wrote: > Views are just fancy sub-queries. > > > > On Mon, Nov 10, 2014 at 4:21 PM, Andries Engelbrecht < > aengelbrecht@maprtech.com> wrote: > >> How does Drill handle views that include aggregations? >> Does it need to fully materialize the view? >> >> Thanks >> Andries >> >> --Apple-Mail=_255289FD-5D96-4739-815A-EFDF8E376C7C--