drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tomer Shiran <tshi...@maprtech.com>
Subject Re: What do you want out of Apache Drill?
Date Thu, 06 Dec 2012 19:17:53 GMT
Thanks Shawn! It looks like the attachment is being removed by the Apache
mailing list. Can you paste the query in the body or put it in a publicly
accessible place (Dropbox, Google Doc, etc.)?


On Thu, Dec 6, 2012 at 10:57 AM, Shawn O'Connor

> Once it is ready, I'd like to replace our traditional SQL servers with
> Drill. Our use case is realtime statistical analytics (Average, standard
> deviation, sum, etc.) on user specified groups of data.
> Our traditional SQL solution works okay up to about 300k rows but starts
> to become slow (> 3 seconds) beyond that. We've worked around it by having
> multiple SQL servers and sending the queries to them asynchronously,
> collecting the varied responses and then returning the results. We need to
> be able to handle 12 million rows, still hopefully in a real-time manner.
> In addition, the drill approach would shift the complexity from the
> sharding data.
> I've attached a sample query as an attachment.
>         -Shawn
> On Dec 6, 2012, at 10:36 AM, Jacques Nadeau <jacques.drill@gmail.com>
> wrote:
> >
> > While comments like "Faster Hive" or "more compliant SQL" are useful, it
> > would be more helpful if you spent more time describing the particular
> data
> > flows that you run today (including data sources), what your pain points
> > are and things that you can't do today but would like to do.

Tomer Shiran
Director of Product Management | MapR Technologies | 650-804-8657

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