Casandra 2.1 is a NoSQL database sponsored by Apache. Use this tag for question specifically for version 2.1.
Questions tagged [cassandra-2.1]
396 questions
3
votes
1 answer
Cassandra: List recent coversations for a user
we are using cassandra to store chat data. we have to maintain all the users conversations and sort them based on the messages received.
Conversation: Is a stream of messages between 2 or more users. Conversations does not have an endtime and are…

srikanth vukkadapu
- 31
- 3
3
votes
1 answer
Cassandra nodetool decommission
I wish to decommission a cassandra node as that node needs a OS upgrade.
I login to that node. Execute the decommission command and after few minutes i get this exception on console
nodetool decommission
error: Stream failed
-- StackTrace…

Vinod Jayachandran
- 3,726
- 8
- 51
- 88
3
votes
1 answer
How to do full replication of data to new cassandra clustered node?
I have 2 node Cassandra cluster. I wish to replicate the complete data into a 3rd node so that the 3rd node will have complete data (for some special needs). All the 3 nodes will have Cassandra version 2.1.8.
With replication factor 3, I plan to…

Vinod Jayachandran
- 3,726
- 8
- 51
- 88
3
votes
1 answer
Cassandra node can't complete joining operation
Trying to add a new node to an existing C* 2.1.11 cluster, the node appears to have completed the streaming phase of the bootstrap, but I can't find an explanation of why it has not moved from the JOINING state; the cassandra logs for all the nodes…

Carlos Monroy Nieblas
- 2,225
- 2
- 16
- 27
3
votes
1 answer
WARN [PERIODIC-COMMIT-LOG-SYNCER] in system log what does that mean?
i am seeing following warning in my system log
WARN [PERIODIC-COMMIT-LOG-SYNCER] 2016-08-27 09:13:34,110 AbstractCommitLogService.java:105 - Out of 24 commit log syncs over the past 240s with average duration of 3253.23ms, 2 have exceeded the…

user6288321
- 365
- 4
- 14
3
votes
1 answer
How to create unique key using cassandra database
I am beginner of cassandra DB I want to create unique key like oracle in cassandra.
I searched a lot site but not able to get relevant answer.
is it possible to create unique key using cassandra ?

user3812269
- 319
- 2
- 3
- 10
3
votes
1 answer
Cassandra Error during truncate: Cannot achieve consistency level ALL
I'm using Cassandra 2.1.9 Keyspace
WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': '4'} AND durable_writes = true;
Now one node is down and i want to truncate one of the tables. How can i do it? I cannot start my 4th node…

Abhishek Agarwal
- 846
- 4
- 13
- 34
3
votes
1 answer
Serialized Json vs UDT implications in data and schema migrations in cassandra
Coming up short with a real answer to what the different implications of storing the serialized json of a type vs using a UDT in Cassandra are. I'm now reaching out hoping for someone with experience to elaborate.
In terms of performance, data and…

Dashu
- 337
- 2
- 15
3
votes
1 answer
Cassandra load balancing with TokenAwarePolicy and shuffleReplicas
We have 6 node cluster where we deploy everything to one region on AWS with 3 Availability Zones. We are using Ec2Snitch which should distribute one replica in each availability zone. We use DataStax Java driver. Servers doing write and read are…

Nenad Bozic
- 3,724
- 19
- 45
3
votes
1 answer
How to do huge updates in Cassandra without downtime?
I have a very huge Cassandra table with about 13 million entries. This table serves as a kind of a lookup table. That means there are no writes but only reads. I use Datastax Enterprise 4.8 (including Cassandra 2.1).
So, the content is very static,…

Josef Bauer
- 199
- 1
- 1
- 13
3
votes
1 answer
Time series modelling( with start & end date) in cassandra
I am doing time series data modelling where I have a start date and end date of events. I need to query on that data model like the following:
Select * from tablename where startdate>'2012-08-09' and enddate<'2012-09-09'
I referred to the following…

Avik Dutta
- 143
- 12
3
votes
1 answer
Cassandra triggers for updating a table when another is updated
I was going through the triggers implementation in cassandra.
I wanted to implement triggers so as to update a table with old values of the tables that has been modified.
suppose i have a table say test_table in keyspace keyspace1.
i also have a…

Rohith S Pal
- 49
- 4
3
votes
1 answer
Cassandra Table needs a lot of Storage space
I just stored a 3,1 GB CSV via Spark-Cassandra-Connector to a Table in a Cassandra Cluster (5 Nodes, 30 GB each, 7.5 GB RAM each instance, cassandra uses ~1.8 GB of that).
I jst saw via DataOpsCenter, that my Cluster holds 16 GB of data (each node…

D. Müller
- 3,336
- 4
- 36
- 84
3
votes
2 answers
Upgrade from cassandra 2.1.4 to 2.1.5
Everyone
A few days ago I upgraded our 6 node EC2 cluster from cassandra 2.1.4 to 2.1.5.
Since then, all my nodes have "exploded" in their cpu usage - their at 100% cpu for much of the time and their load average is between 100-300 (!!!).
This did…

Amir Tuval
- 317
- 1
- 7
3
votes
1 answer
Cassandra: How to partition data in multiple disks in single server?
I want use cassandra in my server and the server has five disks, can i partition data across disks? in other words,How to store data in this disks with partition key? i read cassandra can partition in multiple servers, how to do same for multiple…

Hamid Mamdoohi
- 134
- 1
- 9