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-drill-web-ui/ When you find the profile for the query in question, if you add ".json" to the URL, this will display the wrong text for the profile. You can download this and save it somewhere. On Tue, May 5, 2015 at 3:38 AM, Ted Dunning <[email protected]> wrote: > 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 <[email protected]> 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 > > > -- Steven Phillips Software Engineer mapr.com
