Re: DataModelling to query date range

2016-03-24 Thread Vidur Malik
will return 0 results as it would only match routes that have a > valid of 2016-01-15 exactly. > > thanks, > > Chris > > > On Wed, Mar 23, 2016 at 11:19 PM, Vidur Malik <vi...@shopkeep.com > <javascript:_e(%7B%7D,'cvml','vi...@shopkeep.com');>> wrote: > >>

Re: DataModelling to query date range

2016-03-23 Thread Vidur Malik
1-31 > > And then filtering the rest of the data app side. This doesn't seem ideal > though as I'm going to end up fetching much more data (probably around an > order of magnitude more) from Cassandra than I really want. > > Is there a better way to model the data? > >

Re: Insertion Delay Cassandra 2.1.9

2015-11-06 Thread Vidur Malik
ng it which, per the CQL documentation, means a default of ONE. > > On Fri, Nov 6, 2015 at 1:49 PM, Vidur Malik <vi...@shopkeep.com> wrote: > >> What is your query consistency? >> >> On Fri, Nov 6, 2015 at 1:47 PM, Greg Traub <randomciti...@gmail.com> >> wro

Re: Insertion Delay Cassandra 2.1.9

2015-11-06 Thread Vidur Malik
ay in all rows being available and how might I lessen/eliminate this > delay? > > Thanks, > Greg > -- Vidur Malik [image: ShopKeep] <http://www.shopkeep.com> 800.820.9814 <8008209814> [image: ShopKeep] <https://www.facebook.com/ShopKeepPOS> [image: ShopKeep] <https://twitter.com/shopkeep> [image: ShopKeep] <https://instagram.com/shopkeep/>

Re: Old SSTables lying around

2015-09-08 Thread Vidur Malik
10:32 AM, Vidur Malik <vi...@shopkeep.com> wrote: > >> Bump on this. Anybody have any insight/need more info? >> > > With your report, I have heard 3 similar issues on 2.2.0. > > https://issues.apache.org/jira/browse/CASSANDRA-10270 > > Is the ticket abliss has ope

Re: Old SSTables lying around

2015-09-08 Thread Vidur Malik
Bump on this. Anybody have any insight/need more info? On Fri, Sep 4, 2015 at 5:09 PM, Vidur Malik <vi...@shopkeep.com> wrote: > Hey, > > We're running a Cassandra 2.2.0 cluster with 8 nodes. We are doing > frequent updates to our data and we have very few reads, and we a

Old SSTables lying around

2015-09-04 Thread Vidur Malik
Hey, We're running a Cassandra 2.2.0 cluster with 8 nodes. We are doing frequent updates to our data and we have very few reads, and we are using Leveled Compaction with a sstable_size_in_mb of 160MB. We don't have that much data currently since we're just testing the cluster. We are seeing the