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

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

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

2017-01-31 Thread Justin Cameron
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.l...@gmail.com] > *Sent:* Monday, January 30, 2017 10:20 PM >

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

2017-01-31 Thread Jonathan Haddad
’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 sea

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

2017-01-31 Thread Justin Cameron
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 search opti

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

2017-01-31 Thread vincent gromakowski
gt; >> >> >> 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: Cassa

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

2017-01-31 Thread vincent gromakowski
> 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: Cassandra ad hoc

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 and

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

2017-01-30 Thread vincent gromakowski
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 column well (not just clustering columns)? >

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

2017-01-30 Thread siddharth verma
tional 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 > > > > Thanks

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
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 Cassandra, what are the options f

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 > W

Re: Cassandra ad hoc search options

2017-01-26 Thread Jonathan Haddad
> With Cassandra, what are the options for ad hoc query/search similar to RDBMS? Your best options are Spark w/ the DataStax connector or Presto. Cassandra isn't built for ad-hoc queries so you need to use other tools to make it work. On Thu, Jan 26, 2017 at 2:22 PM Yu, John wrote: > Hi All, >

Cassandra ad hoc search options

2017-01-26 Thread Yu, John
Hi All, Hope I can get some help here. We're using Cassandra for services, and recently we're adding UI support. With Cassandra, what are the options for ad hoc query/search similar to RDBMS? We love the features of Cassandra but it seems it's a known "weakness" that it doesn't come with strong