Nodetool tablehistograms

2017-07-19 Thread Abhinav Solan
Hi Everyone, Here is the result of my tablehistograms command on one of our tables. Percentile SSTables Write Latency Read LatencyPartition Size Cell Count (micros) (micros) (bytes) 50% 4.00 73.46

Re: Row cache not working

2016-10-03 Thread Abhinav Solan
cache_save_period: 60 then this cache would be refreshed automatically or it would be lazy, whenever the fetch call is made then only it caches it. On Mon, Oct 3, 2016 at 1:31 PM Jeff Jirsa wrote: > Which version of Cassandra are you running (I can tell it’s newer than > 2.1, but exact

Re: Row cache not working

2016-10-03 Thread Abhinav Solan
Hi, can anyone please help me with this Thanks, Abhinav On Fri, Sep 30, 2016 at 6:20 PM Abhinav Solan wrote: > Hi Everyone, > > My table looks like this - > CREATE TABLE test.reads ( > svc_pt_id bigint, > meas_type_id bigint, > flags bigint, > read_tim

Row cache not working

2016-09-30 Thread Abhinav Solan
Hi Everyone, My table looks like this - CREATE TABLE test.reads ( svc_pt_id bigint, meas_type_id bigint, flags bigint, read_time timestamp, value double, PRIMARY KEY ((svc_pt_id, meas_type_id)) ) WITH bloom_filter_fp_chance = 0.1 AND caching = {'keys': 'ALL', 'rows_per_

Re: NoHostAvailableException coming up on our server

2016-07-13 Thread Abhinav Solan
> > Best, > > Romain > > > Le Mardi 12 juillet 2016 23h57, Abhinav Solan a > écrit : > > > I am using 3.0.0 version over apache-cassandra-3.3 > > On Tue, Jul 12, 2016 at 2:37 PM Riccardo Ferrari > wrote: > > What driver version are you using? > >

Re: NoHostAvailableException coming up on our server

2016-07-12 Thread Abhinav Solan
; >> >> On Tue, Jul 12, 2016 at 11:47 AM Johnny Miller >> wrote: >> >>> Abhinav - your getting that as the driver isn’t finding any hosts up for >>> your query. You probably need to check if all the nodes in your cluster are >>> running. >>>

Re: NoHostAvailableException coming up on our server

2016-07-12 Thread Abhinav Solan
n your cluster are > running. > > See: > http://docs.datastax.com/en/drivers/java/3.0/com/datastax/driver/core/exceptions/NoHostAvailableException.html > > > Johnny > > On 12 Jul 2016, at 18:46, Abhinav Solan wrote: > > Hi Everyone, > > I am getting this err

NoHostAvailableException coming up on our server

2016-07-12 Thread Abhinav Solan
Hi Everyone, I am getting this error on our server, it comes and goes seems the connection drops a comes back after a while - Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: :9042 (com.datastax.driver.core.excepti

Blob or columns

2016-06-03 Thread Abhinav Solan
Hi Everyone, We have a unique situation at my workplace while storing data. We are using Cassandra as a write through cache where we keep real time data in Cassandra for around 10 - 20 days and rest we archive it to another data store as archived data. The current data which we are going to store