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

Posted to user@drill.apache.org by PROJJWAL SAHA <pr...@gmail.com> on 2017/02/20 12:02:27 UTC

Re: Query on performance using Drill and Amazon S3

On Mon, Feb 20, 2017 at 5:29 PM, PROJJWAL SAHA <pr...@gmail.com> wrote:

> I am using 1GB data in the form of .tsv file, stored in Amazon S3 using
> Drill 1.8. I am using default configurations of Drill using S3 storage
> plugin coming out of the box. The drill bits are configured on a 5 node
> cluster with 32GB RAM and 4VCPU.
>
> I see that select * from xxx; query takes 23 mins to fetch 1,040,000 rows.
>
> Is this the expected behaviour ?
> I am looking for any quick tuning that can improve the performance or any
> other suggestions.
>
> Attaching is the JSON profile for this query.
>
> Regards,
> Projjwal
>
>
>