Yeah, I know it was vague, but that is due to the fact that I'm still coming up
to speed on the project and have yet to hear some of the details. Since I had
heard that there has always been a requirement for ad-hoc queries against the
Oracle DB for data-mining purpsoes, that was the b
On Fri, Sep 20, 2013 at 4:20 PM, Hartzman, Leslie <
leslie.d.hartz...@medtronic.com> wrote:
> Thanks Rob. I thought that might have been the situation but wasn’t
> sure. So does this negate the use of cqlsh to do this then? I’d hate to
> have to provide custom code to support
Cool! Thanks for the suggestions.
From: Peter Lin [mailto:wool...@gmail.com]
Sent: Friday, September 20, 2013 4:52 PM
To: user@cassandra.apache.org
Subject: Re: Ad-hoc queries question
there are several ways of handling these types of use cases. Some people take a
soft real-time approach by
them in a OLAP cube, for reporting purposes.
If your application doesn't need ad-hoc queries results immediately,
usually mapreduce is sufficient. Many people use Pig and Hive to do this
type of operation.
On Fri, Sep 20, 2013 at 7:41 PM, Hartzman, Leslie <
leslie.d.hartz...@medtr
By ad-hoc queries I mean exactly what you've described. The need to access data
from multiple column families, typically addressed in RDBs with JOINs.
I haven't really become familiar enough with MapReduce yet, so I'll have to
delve deeper into that. I'm hoping that the de-
What do you mean by ad-hoc queries?
Most NoSql databases do not support cross table joins, due to the
distributed nature of NoSql databases. If we compare this to partitioned
databases in the RDB world, cross partition joins is also more expensive
than non-partitioned databases.
you can do ad
Thanks Rob. I thought that might have been the situation but wasn't sure. So
does this negate the use of cqlsh to do this then? I'd hate to have to provide
custom code to support ad-hoc queries.
Les
From: Robert Coli [mailto:rc...@eventbrite.com]
Sent: Friday, September 20, 2013
On Fri, Sep 20, 2013 at 3:25 PM, Hartzman, Leslie <
leslie.d.hartz...@medtronic.com> wrote:
> So are ad-hoc queries more awkward or not feasible?
>
Yes.
To expand slightly, you will probably end up querying multiple
columnfamilies and doing the ad-hoc JOIN-esque aspect in appl
I know that for NoSQL the idea is to figure out your queries beforehand and
then plan your data architecture to support them. And this typically is
accomplished with a denormalized database.
So are ad-hoc queries more awkward or not feasible?
Thanks.
Les
[CONFIDENTIALITY AND PRIVACY NOTICE
a library of map/reduce jobs that perform data quality analysis,
>>> statistics, etc.
>>> (> 100 jobs now)
>>>
>>> But... we are still struggling to provide an "ad-hoc" query mechanism
>>> for our users.
>>>
>>> To fill that ga
10 matches
Mail list logo
