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
; > > > 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 Cassandr

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

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

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