>
>
>
>
> 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
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
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
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
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,
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.
Cassandra isn¹t great at ad hoc queries. Many of us have paired it with an
indexing engine like SOLR or Elastic Search.
(built-into the DSE solution)
As of late, I think there are a few of us exploring Spark SQL. (which you
can then use via JDBC or REST)
-brian
---
Brian O'Neill
Chief Technol
