Questions tagged [cassandra-2.1]

Casandra 2.1 is a NoSQL database sponsored by Apache. Use this tag for question specifically for version 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…
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…
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…
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…
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