Re: Support for ad-hoc query

2015-06-12 Thread Jack Krupansky
> > > > > Sean Durity > > > > *From:* Peter Lin [mailto:wool...@gmail.com] > *Sent:* Wednesday, June 10, 2015 8:17 AM > *To:* user@cassandra.apache.org > *Subject:* Re: Support for ad-hoc query > > > > > > I'll second Jack's detailed r

RE: Support for ad-hoc query

2015-06-12 Thread SEAN_R_DURITY
Hadoop for querying by hive. Example: “We found a few records with incorrect data. How many more records like that are out there?” Sean Durity From: Peter Lin [mailto:wool...@gmail.com] Sent: Wednesday, June 10, 2015 8:17 AM To: user@cassandra.apache.org Subject: Re: Support for ad-hoc query

Re: Support for ad-hoc query

2015-06-10 Thread Peter Lin
I'll second Jack's detailed response and add that you really should do some discovery to figure out what kinds of queries you may need to support. It might not be possible and often that is the case, but it's worth while to ask the end users what kind of reports they need to run. Allowing arbitrar

Re: Support for ad-hoc query

2015-06-10 Thread Jack Krupansky
Knowing your queries in advance is a hard-core requirement for effective deployment of Cassandra. Ad hoc queries are a very clear anti-pattern for Cassandra. DSE Search does provide support for advanced, complex, and ad hoc queries. Stratio and TupleJump Stargate can also be used. Back to the ques

Re: Support for ad-hoc query

2015-06-09 Thread Srinivasa T N
Thanks guys for the inputs. By ad-hoc queries I mean that I don't know the queries during cf design time. The data may be from single cf or multiple cf. (This feature maybe required if I want to do analysis on the data stored in cassandra, do you have any better ideas)? Regards, Seenu. On Tue,

Re: Support for ad-hoc query

2015-06-09 Thread Peter Lin
what do you mean by ad-hoc queries? Do you mean simple queries against a single column family aka table? Or do you mean MDX style queries that looks at multiple tables? if it's MDX style queries, many people extract data from Cassandra into a data warehouse that support multi-dimensional cubes.

Re: Support for ad-hoc query

2015-06-09 Thread Brian O'Neill
use of, or taking any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. From: Srinivasa T N Reply-To: Date: Tuesday, June 9, 2015 at 2:38 AM To: "user@cassandra.apache.org" Subject: Support for ad-hoc que

Support for ad-hoc query

2015-06-08 Thread Srinivasa T N
Hi All, I have an web application running with my backend data stored in cassandra. Now I want to do some analysis on the data stored which requires some ad-hoc queries fired on cassandra. How can I do the same? Regards, Seenu.