Re: How to deploy Drill to achieve optimal performance

2015-05-05 Thread Steven Phillips
It would be helpful if you could post the profile for the query somewhere, or send it directly to me as an attachment (since attachments won't post to the mailing list). To get the profile, go to the profile page in the Web UI: http://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-

Re: How to deploy Drill to achieve optimal performance

2015-05-05 Thread Ted Dunning
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 wrote: > Hi all, > > These days, I am trying Drill to see whether Drill fits the realtime/nea

How to deploy Drill to achieve optimal performance

2015-05-05 Thread George Lu
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 iss