cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Lin <wool...@gmail.com>
Subject Re: Support for ad-hoc query
Date Tue, 09 Jun 2015 12:27:08 GMT
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 <seenutn@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.
>

Mime
View raw message