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, Jun 9, 2015 at 5:57 PM, Peter Lin <wool...@gmail.com> wrote: > > 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. This works well when > the extracted data is a small subset and fits neatly in a data warehouse. > > As others have stated, Cassandra isn't great at ad-hoc. For MDX style > queries, Cassandra wasn't designed for it. One thing we've done for our own > project is to combine solr with our own fuzzy index to make ad-hoc queries > against a single table more friendly. > > > > On Tue, Jun 9, 2015 at 2:38 AM, Srinivasa T N <seen...@gmail.com> wrote: > >> 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. >> > >