Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: <59CB5FA4-9982-42B4-87FE-CB527197379C@falconknight.com>
References: 
 <CAKa9qD=9Jwj1Kc0vc=-fqf87xdGwUO=2iWjuitEz+SFJKYL0kQ@mail.gmail.com>
 <59CB5FA4-9982-42B4-87FE-CB527197379C@falconknight.com>
From: Tomer Shiran <tshiran@maprtech.com>
Date: Thu, 6 Dec 2012 11:17:53 -0800
Message-ID: 
 <CAMHgjMpyYgk+wzu0P2R_g_vLWNCfoZ8X=pxY7+E1ig3TK_Vb7A@mail.gmail.com>
Subject: Re: What do you want out of Apache Drill?
To: drill-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=f46d04083f3be24a3f04d033f516

--f46d04083f3be24a3f04d033f516
Content-Type: text/plain; charset=ISO-8859-1

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.)?

Thanks!


On Thu, Dec 6, 2012 at 10:57 AM, Shawn O'Connor
<soconnor@falconknight.com>wrote:

> 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

--f46d04083f3be24a3f04d033f516--