drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From PROJJWAL SAHA <proj.s...@gmail.com>
Subject Re: Query on performance using Drill and Amazon S3
Date Mon, 20 Feb 2017 12:02:27 GMT
On Mon, Feb 20, 2017 at 5:29 PM, PROJJWAL SAHA <proj.saha@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
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message