Reason for Trace Message Drop

2016-06-15 Thread Varun Barala
4 Thanks in advance!! Regards, Varun Barala

Re: Reason for Trace Message Drop

2016-06-16 Thread Varun Barala
a large number of column families, > which produces memory pressure, and at first blush that strikes me as a > likely cause. > > > On Wed, Jun 15, 2016 at 3:23 AM Varun Barala <varunbaral...@gmail.com> > wrote: > >> Hi all, >> >> Can anyone tell me that w

Re: Reason for Trace Message Drop

2016-06-16 Thread Varun Barala
uld be with a lower CF count (there is a fixed memory cost per CF). > Reconsider your data model, usually this many column families suggests > dynamically creating CF's (eg to solve multi-tenancy). If your CF count > will grow steadily over time at any appreciable rate, that's an &g

Re: Read data from specific node in cassandra

2016-05-05 Thread Varun Barala
Hi Siddharth Verma, You can define consistency level LOCAL_ONE. and you can applyh consistency level during statement creation. like this -> statement.setConsistencyLevel(ConsistencyLevel.LOCAL_ONE); On Thu, May 5, 2016 at 3:55 PM, Siddharth Verma < verma.siddha...@snapdeal.com> wrote: > Hi,

regarding drain process

2016-07-26 Thread Varun Barala
specific settings for the same ? *we are using C*-2.1.13.* please let me know if you need more info. Thanking you!! Regards, Varun Barala

(C)* stable version after 3.5

2016-07-12 Thread Varun Barala
Hi all users, Currently we are using cassandra-2.1.13 but we want to upgrade *2.1.13 to 3.x* in production. Could anyone please tell me which is the most stable *cassandra version after 3.5*. Thanking You!! Regards, Varun Barala

Re: (C)* stable version after 3.5

2016-07-18 Thread Varun Barala
Thanks everyone for your detailed explanation!! We are going to upgrade from 2.1 to 3.0.8 as many people agreed that It's safe skipping measure version 2.2. Could anyone please tell me which *cassandra java driver* will be compatible with 3.0.8 ? Currently we are using *2.1.7.1 driver version*

Fwd: Counter global logical clock

2016-10-06 Thread Varun Barala
, Varun Barala

Re: regarding drain process

2016-09-25 Thread Varun Barala
<jeff.ji...@crowdstrike.com> wrote: > Are you running chef/puppet or similar? > > > > *From: *Varun Barala <varunbaral...@gmail.com> > *Reply-To: *"user@cassandra.apache.org" <user@cassandra.apache.org> > *Date: *Tuesday, July 26, 2016 at 1

Re: CQL datatype for long?

2016-12-07 Thread Varun Barala
use `bigint` for long. Regards, Varun Barala On Thu, Dec 8, 2016 at 10:32 AM, Check Peck <comptechge...@gmail.com> wrote: > What is the CQL data type I should use for long? I have to create a column > with long data type. Cassandra version is 2.0.10. > > CREATE TABLE sto

Re: CQL datatype for long?

2016-12-23 Thread Varun Barala
yes!! On Thu, Dec 8, 2016 at 1:21 PM, Check Peck <comptechge...@gmail.com> wrote: > And then from datastax java driver, I can use. Am I right? > > To Read: > row.getLong(); > > To write > boundStatement.setLong() > > > On Wed, Dec 7, 2016 at 6:50 PM, V

Re: Cassandra crashed with OOM, and the system.log and debug.log doesn't match.

2017-07-10 Thread Varun Barala
Hi, *How many column families are there? What is the heap size?* You can turn off logs for statusLogger.java and gc to optimize heap usage. Can you also monitor cpu usage and memory usage? IMO, in your case memory is the bottle-neck. Thanks!! On Mon, Jul 10, 2017 at 5:07 PM, 张强

Re: Help in c* Data modelling

2017-07-23 Thread Varun Barala
Hi, You can create pseudo index table. IMO, structure can be:- CREATE TABLE IF NOT EXISTS test.user ( account_id bigint, pid bigint, disp_name text, status int, PRIMARY KEY (account_id, pid) ) WITH CLUSTERING ORDER BY (pid ASC); CREATE TABLE IF NOT EXISTS test.user_index ( account_id bigint,

Materialize View in production

2017-05-07 Thread Varun Barala
stability* About bugs* About performance (cluster size or DCs)* Could you please help us to make the decision. Thanking you!! Regards, Varun Barala

Re: Alter table gc_grace_seconds

2017-10-01 Thread Varun Barala
* Which C* version are you using? * How many nodes are there in this cluster? These tombstones will not be deleted if they are not older than gc_grace_seconds. On Sun, Oct 1, 2017 at 10:14 PM, Gábor Auth <auth.ga...@gmail.com> wrote: > Hi, > > On Sun, Oct 1, 2017 at 3:44

Re: Alter table gc_grace_seconds

2017-10-01 Thread Varun Barala
Hi, This is the property of table and It's not written in sstables. If you change gc_grace, It'll get applied for all the data. Thanks!! C* stores this info inside schema_columnfamilies Regards, Varun Barala On Sun, Oct 1, 2017 at 9:23 PM, Gábor Auth <auth.ga...@gmail.com> wrote:

Re: Alter table gc_grace_seconds

2017-10-01 Thread Varun Barala
* You should not try on real clusters directly. Did you change gc_grace for all column families? > But not in the `number_item` CF... :( Could you please explain? Thanks!! On Mon, Oct 2, 2017 at 2:24 AM, Gábor Auth <auth.ga...@gmail.com> wrote: > Hi, > > On Sun, Oct 1, 201

Re: Alter table gc_grace_seconds

2017-10-01 Thread Varun Barala
Sorry If I misunderstood the situation. { "type" : "row", "position" : 146160, "clustering" : [ "humidity", "97781fd0-9dab-11e7-a3d5-7f6ef9a844c7" ], "deletion_info" : { "marked_deleted" : "2017-09-25T11:51:19.165276Z", "local_delete_time" : "2017-09-25T11:51:19Z" }, "cells" : [ ] }

Re: Alter table gc_grace_seconds

2017-10-02 Thread Varun Barala
> wrote: > >> Hi, >> >> On Mon, Oct 2, 2017 at 5:55 AM Varun Barala <varunbaral...@gmail.com> >> wrote: >> >>> *select gc_grace_seconds from system_schema.tables where keyspace_name = >>> 'keyspace' and table_name = 'number_item;* >&g

Re: Alter table gc_grace_seconds

2017-10-01 Thread Varun Barala
Can you share result of query:- *select gc_grace_seconds from system_schema.tables where keyspace_name = 'keyspace' and table_name = 'number_item;* Thanks!! On Mon, Oct 2, 2017 at 3:42 AM, Gábor Auth <auth.ga...@gmail.com> wrote: > Hi, > > On Sun, Oct 1, 2017 at 9:36

Re: Alter table gc_grace_seconds

2017-10-02 Thread Varun Barala
e a full repair before the GC > grace period expires, otherwise it's possible you could experience zombie > data (i.e. data that was previously deleted coming back to life) > > See http://thelastpickle.com/blog/2016/07/27/about-deletes- > and-tombstones.html for a good overview of the

Re: Cassandra stress tool - data generation

2017-11-01 Thread Varun Barala
Hi, https://www.instaclustr.com/deep-diving-into-cassandra-stress-part-1/ In the blog, They covered many things in detail. Thanks!! On Thu, Nov 2, 2017 at 12:38 AM, Lucas Benevides < lu...@maurobenevides.com.br> wrote: > Dear community, > > I am using Cassandra Stress Tool and trying to

Re: Cassandra stress tool - data generation

2017-11-01 Thread Varun Barala
https://www.instaclustr.com/deep-diving-cassandra-stress-part-3-using-yaml-profiles/ In this particular blog, they mentioned your case. Changed uniform() distribution to seq() distribution https://issues.apache.org/jira/browse/CASSANDRA-12490 Thanks!! On Thu, Nov 2, 2017 at 12:54 AM, Varun

Re: Reg :- Multiple Node Cluster set up in Virtual Box

2017-11-06 Thread Varun Barala
you can try *CCM* https://academy.datastax.com/planet-cassandra/getting-started-with-ccm-cassandra-cluster-manager Thanks On Mon, Nov 6, 2017 at 10:12 PM, @Nandan@ wrote: > Hi Users , > Just seeking some perfect guidelines to set up multi-node cluster single >

Re: Re: Re: how to configure the Token Allocation Algorithm

2018-10-02 Thread Varun Barala
never tested it thoroughly but this should work conceptually. So here we are taking advantage of the fact that we have volumes(data) for the new node beforehand so we no need to bootstrap them. Thanks & Regards, Varun Barala On Tue, Oct 2, 2018 at 2:31 PM onmstester onmstester wrote: > &

Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

2019-04-09 Thread Varun Barala
I'm not sure about the use cases. But other approaches can also be considered:- * Every mutation will have the timestamp in the commitlog [So taking backup of the commitlogs will give you this functionality] * At client side, you fetch the existing writetime for those columns from the db and also