RE: Ad-hoc queries question

2013-09-20 Thread Hartzman, Leslie
sting complexity. Les From: Robert Coli [mailto:rc...@eventbrite.com] Sent: Friday, September 20, 2013 5:10 PM To: user@cassandra.apache.org Subject: Re: Ad-hoc queries question On Fri, Sep 20, 2013 at 4:20 PM, Hartzman, Leslie mailto:leslie.d.hartz...@medtronic.com>> wrote: Thanks Rob. I t

Re: Ad-hoc queries question

2013-09-20 Thread Robert Coli
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 ad-hoc queries. > T

RE: Ad-hoc queries question

2013-09-20 Thread Hartzman, Leslie
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

Re: Ad-hoc queries question

2013-09-20 Thread Peter Lin
e deeper into that. I’m hoping that the de-normalized nature of > things would obviate the need for complex subquery-type of operations. > > ** ** > > *From:* Peter Lin [mailto:wool...@gmail.com] > *Sent:* Friday, September 20, 2013 4:30 PM > > *To:* user@ca

RE: Ad-hoc queries question

2013-09-20 Thread Hartzman, Leslie
normalized nature of things would obviate the need for complex subquery-type of operations. From: Peter Lin [mailto:wool...@gmail.com] Sent: Friday, September 20, 2013 4:30 PM To: user@cassandra.apache.org Subject: Re: Ad-hoc queries question What do you mean by ad-hoc queries? Most NoSql data

Re: Ad-hoc queries question

2013-09-20 Thread Peter Lin
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 4:06 PM > *To:* user@cassan

RE: Ad-hoc queries question

2013-09-20 Thread Hartzman, Leslie
4:06 PM To: user@cassandra.apache.org Subject: Re: Ad-hoc queries question On Fri, Sep 20, 2013 at 3:25 PM, Hartzman, Leslie mailto: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 multipl

Re: Ad-hoc queries question

2013-09-20 Thread Robert Coli
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 application code. =Ro

Ad-hoc queries question

2013-09-20 Thread Hartzman, Leslie
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]