You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Andries Engelbrecht <ae...@maprtech.com> on 2014/11/10 22:06:37 UTC

Query execution using Drill views

Does Drill need to materialize a view before a query runs against it or does it incorporate the view in the query plan for execution?

What is the impact if the view includes aggregations?

Re: Query execution using Drill views

Posted by Andries Engelbrecht <ae...@maprtech.com>.

Thanks, makes sense and wanted to verify.



On Nov 10, 2014, at 6:00 PM, Ted Dunning <te...@gmail.com> 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
>> 
>>

Re: Query execution using Drill views

Posted by Ted Dunning <te...@gmail.com>.

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
>
>

Re: Query execution using Drill views

Posted by Tomer Shiran <ts...@maprtech.com>.

Drill does not materialize views regardless of what's in the view.

On Mon, Nov 10, 2014 at 2: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
>
>


-- 
Tomer Shiran
VP Product Management | MapR Technologies | 650-804-8657

Query execution using Drill views

Posted by Andries Engelbrecht <ae...@maprtech.com>.

How does Drill handle views that include aggregations?
Does it need to fully materialize the view?

Thanks
Andries