drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: How to deploy Drill to achieve optimal performance
Date Tue, 05 May 2015 10:38:17 GMT
George,

That sounds much too slow.

Can you provide some samples of the data and queries?  How about actual
data counts?  Millioins?  hundreds of millions?





On Tue, May 5, 2015 at 8:54 AM, George Lu <luwenbin888@gmail.com> wrote:

> Hi all,
>
> These days, I am trying Drill to see whether Drill fits the realtime/near
> realtime interactive queries requirement.
> I have a HBase server, underlying HDFS contains three data nodes, and I
> deployed 7 Drill nodes within the cluster.
> I have several million records in the HBase table and I issue queries like
> SUM, MAX, COUNT against the table and found the Drill costs like 5 to 6
> minutes on average to get the result.
>
> Such latency is not ideal for interactive use.
>
> I know Drill is used for low-latency query, so I would like to ask for help
> how to achieve that? How to make Drill run queries in low-latency (in
> seconds not minutes)?
>
> Any suggestions are welcome!
>
> Thanks!
>
> George
>

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