Re: DataModelling to query date range

2016-03-24 Thread Vidur Malik
ch 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 > wrote: > >> Flip the problem over. Instead of storing validTo and validFrom, simply >> s

Re: DataModelling to query date range

2016-03-23 Thread Vidur Malik
gton' and > validFrom <= 2016-01-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. > >

Re: Insertion Delay Cassandra 2.1.9

2015-11-06 Thread Vidur Malik
er the CQL documentation, means a default of ONE. > > On Fri, Nov 6, 2015 at 1:49 PM, Vidur Malik wrote: > >> What is your query consistency? >> >> On Fri, Nov 6, 2015 at 1:47 PM, Greg Traub >> wrote: >> >>> Cassandra users, >>> >>> I

Re: Insertion Delay Cassandra 2.1.9

2015-11-06 Thread Vidur Malik
ows 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
I did add a comment to that ticket, but the problem seems slightly different; moreover the compaction strategies are different. I'm also not seeing the error that abliss is reporting. On Tue, Sep 8, 2015 at 2:47 PM, Robert Coli wrote: > On Tue, Sep 8, 2015 at 10:32 AM, Vidur Mali

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 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 are using > Level

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 SS