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 <sdo...@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.do...@gmail.com > -- http://twitter.com/tjake
