RE: [External] Re: Cassandra ad hoc search options

2017-02-02 Thread Yu, John
To: user@cassandra.apache.org Subject: Re: [External] Re: Cassandra ad hoc search options +1 On Tue, 31 Jan 2017 at 10:04 Jonathan Haddad <j...@jonhaddad.com<mailto:j...@jonhaddad.com>> wrote: With regards to having DCs for specific workloads, it would be nice to have per DC indexes

Re: [External] Re: Cassandra ad hoc search options

2017-01-31 Thread Justin Cameron
he data to > support ad hoc queries. It seems mostly limited to clustering columns. > Maybe in other cases, it would result in full scan, but that’s going to be > very slow. > > > > Regards, > > John > > > > *From:* siddharth verma [mailto:sidd.verma29

Re: [External] Re: Cassandra ad hoc search options

2017-01-31 Thread Jonathan Haddad
ases, it would result in full scan, but that’s going to be > very slow. > > > > Regards, > > John > > > > *From:* siddharth verma [mailto:sidd.verma29.l...@gmail.com] > *Sent:* Monday, January 30, 2017 10:20 PM > > *To:* user@cassandra.apache.org > *Subject:* Re: [E

Re: [External] Re: Cassandra ad hoc search options

2017-01-31 Thread Justin Cameron
that’s going to be > very slow. > > > > Regards, > > John > > > > *From:* siddharth verma [mailto:sidd.verma29.l...@gmail.com] > *Sent:* Monday, January 30, 2017 10:20 PM > > *To:* user@cassandra.apache.org > *Subject:* Re: [External] Re: Cassandra ad hoc sear

Re: [External] Re: Cassandra ad hoc search options

2017-01-31 Thread vincent gromakowski
gt;> that’s going to be very slow. >> >> >> >> Regards, >> >> John >> >> >> >> *From:* siddharth verma [mailto:sidd.verma29.l...@gmail.com] >> *Sent:* Monday, January 30, 2017 10:20 PM >> >> *To:* user@cassandra.apac

Re: [External] Re: Cassandra ad hoc search options

2017-01-31 Thread vincent gromakowski
l scan, > but that’s going to be very slow. > > > > Regards, > > John > > > > *From:* siddharth verma [mailto:sidd.verma29.l...@gmail.com] > *Sent:* Monday, January 30, 2017 10:20 PM > > *To:* user@cassandra.apache.org > *Subject:* Re: [External] Re: Cassan

RE: [External] Re: Cassandra ad hoc search options

2017-01-30 Thread Yu, John
, 2017 10:20 PM To: user@cassandra.apache.org Subject: Re: [External] Re: Cassandra ad hoc search options Hi, Are you using the DataStax connector as well? Yes, we used it to query on lucene index. Does it support querying against any column well (not just clustering columns)? Yes it does. We used

RE: [External] Re: Cassandra ad hoc search options

2017-01-30 Thread Yu, John
Does this work with Cassandra, or provide an alternative? Thanks. From: vincent gromakowski [mailto:vincent.gromakow...@gmail.com] Sent: Monday, January 30, 2017 11:38 PM To: user@cassandra.apache.org Subject: Re: [External] Re: Cassandra ad hoc search options I gave a try on spark+filodb

Re: [External] Re: Cassandra ad hoc search options

2017-01-30 Thread vincent gromakowski
ohn...@sandc.com] > *Sent:* Monday, January 30, 2017 12:04 AM > *To:* user@cassandra.apache.org > *Subject:* RE: [External] Re: Cassandra ad hoc search options > > > > Thanks for the input! Are you using the DataStax connector as well? Does > it support querying against any co

Re: [External] Re: Cassandra ad hoc search options

2017-01-30 Thread siddharth verma
(with multiple conditional filters). > > > > Thanks, > > John > > > > *From:* Yu, John [mailto:john...@sandc.com] > *Sent:* Monday, January 30, 2017 12:04 AM > *To:* user@cassandra.apache.org > *Subject:* RE: [External] Re: Cassandra ad hoc search options &g

RE: [External] Re: Cassandra ad hoc search options

2017-01-30 Thread Yu, John
@cassandra.apache.org Subject: RE: [External] Re: Cassandra ad hoc search options Thanks for the input! Are you using the DataStax connector as well? Does it support querying against any column well (not just clustering columns)? I’m wondering how it could build the index around them “on-the-fly

RE: [External] Re: Cassandra ad hoc search options

2017-01-30 Thread Yu, John
: Friday, January 27, 2017 12:15 AM To: user@cassandra.apache.org Subject: Re: [External] Re: Cassandra ad hoc search options Hi We used lucene stratio plugin with C*3.0.3 Helped to solve a lot of some read patterns. Served well for prefix. But created problems as repairs failed repeatedly. We

Re: [External] Re: Cassandra ad hoc search options

2017-01-27 Thread siddharth verma
Hi We used lucene stratio plugin with C*3.0.3 Helped to solve a lot of some read patterns. Served well for prefix. But created problems as repairs failed repeatedly. We might have used it sub optimally, not sure. Later, we had to do away with it, and tried to serve most of the read patterns with

RE: [External] Re: Cassandra ad hoc search options

2017-01-26 Thread Yu, John
Thanks a lot. Mind sharing a couple of points where you feel it’s better than the alternatives. Regards, John From: Jonathan Haddad [mailto:j...@jonhaddad.com] Sent: Thursday, January 26, 2017 2:33 PM To: user@cassandra.apache.org Subject: [External] Re: Cassandra ad hoc search options > With