Re: Cassandra Delete Query Doubt

2021-11-10 Thread raman gugnani
of cells, and supersedes/shadows > them when merged (either in the read path or compaction path). > > > > On Wed, Nov 10, 2021 at 4:27 AM raman gugnani > wrote: > >> HI Team, >> >> >> I have one table below and want to delete data on this table. >> >>

Cassandra Delete Query Doubt

2021-11-10 Thread raman gugnani
, updated_at timestamp, PRIMARY KEY ((tournament_id, version_id, partition_id), user_id) ) WITH CLUSTERING ORDER BY (user_id ASC) -- Raman Gugnani

Re: Change of Cassandra TTL

2021-09-14 Thread raman gugnani
t doesn't overload your > production cluster. Cheers! > >> -- Raman Gugnani

Change of Cassandra TTL

2021-09-14 Thread raman gugnani
the table , is there a way to update the existing data? -- Raman Gugnani

Re: Data is not syncing up when we add one more Node(DR) to existing 3 node cluster

2019-12-11 Thread raman gugnani
Please provide suggestions to make the new node on DC2 to sync up with > existing cluster. This is required as the DC2 is our DR in a different > region other than existing cluster. > > > > > > *Regards,* > > *Anil Ganipineni* > > > > *P** Please consider environment before printing this page.* > > > -- Raman Gugnani

Cassandra OutOfMemoryError

2019-07-25 Thread raman gugnani
Dropped Mutations: 0 bytes *Can someone please help, what can be the issue ?* -- Raman Gugnani

Getting warnings in system.log

2019-07-21 Thread raman gugnani
happening (move or decommission),but this node hasn't updated its ring metadata yet. Adding mutation to local batchlog to be replayed later. I did nodetool decomission on one of the node. After that I have started receiving above logs. nodetool status of the node is *UL* -- Raman Gugnani

Re: Cassandra LWT Writes inconsistent

2019-07-08 Thread raman gugnani
ed A* > > This is causing my count of writes to tables to differ from required > 10, to 11, writing extra codes. > > Please guide here. > > -- > Regards, > Upasana Sharma > -- Raman Gugnani 8588892293 Principal Engineer *ixigo.com <http://ixigo.com>*

Best compaction strategy

2018-10-25 Thread raman gugnani
Hi All, I have one table in which i have some data which has TTL of 2days and some data which has TTL of 60 days. What compaction strategy will suits the most. 1. LeveledCompactionStrategy (LCS) 2. SizeTieredCompactionStrategy (STCS) 3. TimeWindowCompactionStrategy (TWCS) -- Raman

Reading Data from C* Cluster

2018-05-24 Thread raman gugnani
field is appx 12~20 characters Query : 1) How much data I can put in one partition ? 2) I want to read data from cassandra as SELECT * from code where campaign_id_sub_partition = 'XXX-1'; Is reading whole partition at one time is feasible or shall I use pagination ? -- Raman Gugnani 8588892293

Re: Count(*) is not working

2017-02-16 Thread Selvam Raman
esult. > > Do you really need the actual live count? To get a idea you can always > look at nodetool cfstats (but those numbers also contain deleted rows). > > > Am 16.02.2017 um 13:18 schrieb Selvam Raman: > > Hi, > > I want to know the total records count in table. >

Re: Count(*) is not working

2017-02-16 Thread Selvam Raman
I am using cassandra 3.9. Primary Key: id text; On Thu, Feb 16, 2017 at 12:25 PM, Cogumelos Maravilha < cogumelosmaravi...@sapo.pt> wrote: > C* version please and partition key. > > On 02/16/2017 12:18 PM, Selvam Raman wrote: > > Hi, > > I want to know the total re

Count(*) is not working

2017-02-16 Thread Selvam Raman
ken(id) > token(test:-2220-UV033/04) LIMIT 100 (see tombstone_warn_threshold). Can you please help me to get the total count of the table. -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Cassandra: maximum size of collection list type

2016-12-01 Thread Selvam Raman
Hi, What is the maximum size which can be stored into collection list(in a row ) in cassandra. -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Re: Cassandra: maximum size of collection list type

2016-12-01 Thread Selvam Raman
I am getting the below error when i am having huge list( greater than 3lakh). "Cassandra timeout during write query at consistency LOCAL_ONE (1 replica were required but only 0 acknowledged the write)" 2016-12-01 16:20 GMT+00:00 Selvam Raman <sel...@gmail.com>: > Hi, >

Java Collections.emptyList inserted as null object in cassandra

2016-11-29 Thread Selvam Raman
Filed Type in cassandra : List I am trying to insert Collections.emptyList() from spark to cassandra list field. In cassandra it stores as null object. How can i avoid null values here. -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Cassandra timestamp to spark Date field

2016-09-05 Thread Selvam Raman
ues)),schema) in schema fields I have mentioned timestamp as *StructField*("shipped_datetime", *DateType*), when I try to show the result, it throws java.util.Date can not convert to java.sql.Date. so how can I solve the issue. First I have converted cassandrascanrdd to -- Selvam

Reading cassandra table using Spark

2016-09-04 Thread Selvam Raman
t when i crate action it throws plenty of error example: com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured columnfamily size_estimates -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

UNSUBSCRIBE

2016-07-21 Thread Raman Kannan

unsubscribe

2016-05-23 Thread Raman Kannan
unsubscribe

unsubscribe

2016-05-05 Thread raman
unsubscribe

Achilles not picking cassandra ConsistencyLevel

2016-03-11 Thread Raman Gugnani
Write {}", clRead, clWrite); final ManagerFactory factory = ManagerFactoryBuilder.builder(cluster).withDefaultWriteConsistency( clWrite == null ? ConsistencyLevel.EACH_QUORUM : ConsistencyLevel.valueOf(clWrite)).withDefaultReadConsistency( clRead == null ? ConsistencyLevel.ON

Not able to insert data through achilles.

2016-03-02 Thread Raman Gugnani
'com.xxx.domain.cassandra.entity.TeamMember' should not be null because it is a clustering column I am trying below insert through achilles TeamMember teamMember = new TeamMember(); teamMember.setTeamname("raman"); teamMember.setManager("rahul"); teamMember.setLocation("india"); ma

Re: Cassandra Data Audit

2016-02-24 Thread Raman Gugnani
One way of doing this is to create new CFs , but I wanted to know if >> there is any standard C* feature that could be used. >> >> Any guidance in this and implementation approaches would really help. >> >> >> >> Thanks, >> >> Charu >> > > -- Tha

best ORM for cassandra

2016-02-09 Thread Raman Gugnani
Hi I am new to cassandra. I am developing an application with cassandra. Which is the best ORM for cassandra? -- Thanks & Regards Raman Gugnani *Senior Software Engineer | CaMS* M: +91 8588892293 | T: 0124-660 | EXT: 14255 ASF Centre A | 2nd Floor | CA-2130 | Udyog Vihar Phas

unsubscribe

2015-02-21 Thread Raman
unsubscribe

Re: commitlog -deleted keyspaces.

2013-03-12 Thread Raman
Can someone refer me to a C* tutorial on how to define dynamic schema and populate data. I am trying to an inheritance hierarchy object population into C*. I want to handle all Base/Derived Class objects as dynamic schema each with its own set of attributes... Thanks Raman

Re: Data Model - Additional Column Families or one CF?

2013-02-26 Thread Raman
to distribute the load around the world according to the jurisdiction of the Parent record. I am particularly interested in learning how to define the Shape CF but insert Rectangle, Circle, with different columns? Thank you for your help regards Raman