Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jakers@gmail.com designates
 74.125.83.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=qeObMrK9+1EDccf+5C+pGuYhBLvYKoMvAQ08SPpofgWXUqzXYuej/Lw89WSSAThrFQ
         wl9vhgAIb082DGhFhvAYhstp38C8mrv4JpC5rf77cAtyhxXCY1iH+S8oBpTRgI3obELS
         tTGUN/2lwh0+RrKLeXmyj9aJ4rfQZHW4yDHlg=
MIME-Version: 1.0
In-Reply-To: <BANLkTinN7RQGM54r+9t7D2HfMWZJ0kLq6Q@mail.gmail.com>
References: <BANLkTinN7RQGM54r+9t7D2HfMWZJ0kLq6Q@mail.gmail.com>
From: Jake Luciani <jakers@gmail.com>
Date: Tue, 21 Jun 2011 14:19:11 -0400
Message-ID: <BANLkTim_dwNx-tvmzTe5JkOUYxAWfZCjug@mail.gmail.com>
Subject: Re: solandra or pig or....?
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=20cf303f6adca4337604a63ce447

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

Solandra can answer the question you used as an example and it's more of a
fit for low-latency ad-hoc reporting then PIG.  Pig queries will take
minutes not seconds.

On Tue, Jun 21, 2011 at 12:12 PM, Sasha Dolgy <sdolgy@gmail.com> wrote:

> Folks,
>
> Simple question ... Assuming my current use case is the ability to log
> lots of trivial and seemingly useless sports statistics ... I want a
> user to be able to query / compare .... For example:
>
> --> Show me all baseball players in cheektowaga and ontario,
> california who have hit a grandslam on tuesdays where it was just a
> leap year.
>
> Each baseball player is represented by a single row in a CF:
>
> player_uuid, fullname, hometown, game1, game2, game3, game4
>
> Game's are UUID's that are a reference to another row in the same CF
> that provides information about that game...
>
> location, final score, date (unix timestamp or ISO format) , and
> statitics which are represented as a new column timestamp:player_uuid
>
> I can use PIG, as I understand, to run a query to generate specific
> information about specific "things" and populate that data back into
> Cassandra in another CF ... similar to the hypothetical search
> above....as the information is structured already, i assume PIG is the
> right tool for the job, but may not be ideal for a web application and
> enabling ad-hoc queries ... it could take anywhere from 2-....?
> seconds for that query to generate, populate, and return to the
> user...?
>
> On the other hand, I have started to read about Solr / Solandra /
> Lucandra .... can this provide similar functionality or better ?  or
> is it more geared towards full text search and indexing ...
>
> I don't want to get into the habit of guessing what my potential users
> want to search for ... trying to think of ways to offload this to
> them.
>
>
>
> --
> Sasha Dolgy
> sasha.dolgy@gmail.com
>


-- 
http://twitter.com/tjake

--20cf303f6adca4337604a63ce447
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Solandra can answer the question you used as an example and it&#39;s more o=
f a fit for low-latency ad-hoc reporting then PIG. =A0Pig queries will take=
 minutes not seconds.<div><div><br><div class=3D"gmail_quote">On Tue, Jun 2=
1, 2011 at 12:12 PM, Sasha Dolgy <span dir=3D"ltr">&lt;<a href=3D"mailto:sd=
olgy@gmail.com">sdolgy@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">Folks,<br>
<br>
Simple question ... Assuming my current use case is the ability to log<br>
lots of trivial and seemingly useless sports statistics ... I want a<br>
user to be able to query / compare .... For example:<br>
<br>
--&gt; Show me all baseball players in cheektowaga and ontario,<br>
california who have hit a grandslam on tuesdays where it was just a<br>
leap year.<br>
<br>
Each baseball player is represented by a single row in a CF:<br>
<br>
player_uuid, fullname, hometown, game1, game2, game3, game4<br>
<br>
Game&#39;s are UUID&#39;s that are a reference to another row in the same C=
F<br>
that provides information about that game...<br>
<br>
location, final score, date (unix timestamp or ISO format) , and<br>
statitics which are represented as a new column timestamp:player_uuid<br>
<br>
I can use PIG, as I understand, to run a query to generate specific<br>
information about specific &quot;things&quot; and populate that data back i=
nto<br>
Cassandra in another CF ... similar to the hypothetical search<br>
above....as the information is structured already, i assume PIG is the<br>
right tool for the job, but may not be ideal for a web application and<br>
enabling ad-hoc queries ... it could take anywhere from 2-....?<br>
seconds for that query to generate, populate, and return to the<br>
user...?<br>
<br>
On the other hand, I have started to read about Solr / Solandra /<br>
Lucandra .... can this provide similar functionality or better ? =A0or<br>
is it more geared towards full text search and indexing ...<br>
<br>
I don&#39;t want to get into the habit of guessing what my potential users<=
br>
want to search for ... trying to think of ways to offload this to<br>
them.<br>
<font color=3D"#888888"><br>
<br>
<br>
--<br>
Sasha Dolgy<br>
<a href=3D"mailto:sasha.dolgy@gmail.com">sasha.dolgy@gmail.com</a><br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br><a href=3D"http:=
//twitter.com/tjake" target=3D"_blank">http://twitter.com/tjake</a><br>
</div></div>

--20cf303f6adca4337604a63ce447--