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

Posted to user@drill.apache.org by Alok Tanna <at...@exertdigital.com> on 2015/05/25 04:04:48 UTC

Question

Can we create a view across two files in Drill? Similarly can we run a
query across two files via Drill?

Re: Question

Posted by Alok Tanna <at...@exertdigital.com>.

No , I have not tried that yet . Just had a question . 

Sent from my iPhone

> On May 24, 2015, at 10:14 PM, rahul challapalli <ch...@gmail.com> wrote:
> 
> You can create a view which does a join between 2 files.
> Infact you can write a sql query which joins even 5 or more files.
> You can join folders and each folder can contain multiple files as well.
> 
> Are you struck trying something?
> 
> - Rahul
>> On May 24, 2015 7:05 PM, "Alok Tanna" <at...@exertdigital.com> wrote:
>> 
>> Can we create a view across two files in Drill? Similarly can we run a
>> query across two files via Drill?
>>

Re: Question

Posted by rahul challapalli <ch...@gmail.com>.

You can create a view which does a join between 2 files.
Infact you can write a sql query which joins even 5 or more files.
You can join folders and each folder can contain multiple files as well.

Are you struck trying something?

- Rahul
On May 24, 2015 7:05 PM, "Alok Tanna" <at...@exertdigital.com> wrote:

> Can we create a view across two files in Drill? Similarly can we run a
> query across two files via Drill?
>

Re: Question

Posted by Bob Rumsby <br...@maprtech.com>.

Yes and yes.

http://drill.apache.org/docs/query-data-introduction/

Also see the tutorials for more examples.

On Sun, May 24, 2015 at 7:04 PM, Alok Tanna <at...@exertdigital.com> wrote:

> Can we create a view across two files in Drill? Similarly can we run a
> query across two files via Drill?
>