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
1
vote
1 answer
Exception encountered during startup - Emptied cassandra.yaml file
Am using Cassandra 2.1.13
As part of some execution when C* was actually starting up and while C* start process was not complete, in mid of this operation the machine got rebooted.
Strangely the C* configuration file cassandra.yaml is emptied when…

Neuron
- 71
- 5
1
vote
1 answer
Frequent Spikes in Cassandra write latency
In Production cluster , the Cluster Write latency frequently spikes from 7ms to 4Sec. Due to this clients face a lot of Read and Write Timeouts. This repeats in every few hours.
Observation:
Cluster Write latency (99th percentile) - 4Sec
Local Write…

Sinister8774
- 11
- 2
1
vote
1 answer
Adding EC2 Cassandra Nodes to my already running premise Apache Cassandra Cluster
Here is my use case:
I have a single DC Cassandra cluster(3 nodes) with RF 2. This Cluster is running on my on-premises DC. Here is my question, I am hoping to add 3 EC2 nodes into this cluster and then change the RF to say 4, also add one of the…

mic255
- 11
- 1
1
vote
0 answers
Cassandra Nodetool Status shows command not found
How to find the table size in Cassandra 2.8.2 community version. nodetool cfstats is not working and in help as well nodestool is not avaiable.

Sukanta Ghosh
- 11
- 2
1
vote
1 answer
SSTables row timestamps distribution messed up with TWCS
We're running Cassandra 2.1.14 and migrated to TWCS on one of our CFs a few months ago and since then, while getting better performance and avg SSTables read per query reduced drastically, we noticed old SSTables never get evicted.
Running…

sternr
- 6,216
- 9
- 39
- 63
1
vote
0 answers
Cassandra compare timestamp with currentdate
Trying to find the count for currendate in Cassandra like using the below query.
select count(*) from xyz.abctable where toDate(datetime)>=toDate(now());
This is not working and gives an error message:
SyntaxException: line 1:55 no viable…

mass
- 11
- 2
1
vote
2 answers
When to enable repairs after adding new nodes to cassandra cluster?
I am adding new nodes to my existing cassandra cluster which is running on Vnodes with cassandra version 2.1.16. I had cron jobs scheduled for the repairs to run on these nodes. Before adding the new nodes I had disabled the cron jobs, but I am…

Ankitha Sathya
- 23
- 5
1
vote
1 answer
Cassandra: Can't one use snapshots to rapidly scale out a cluster?
This details how to replicate data to a new cluster:
https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_snapshot_restore_new_cluster.html
Can't a similar scheme be used to rapidly scale out a cluster with existing data? Say take a…

Constance Eustace
- 407
- 4
- 12
1
vote
2 answers
Cassandra - What is difference between TTL at table and inserting data with TTL
I have a Cassandra 2.1 cluster where we insert data though Java with TTL as the requirement of persisting the data is 30 days.
But this causes problem as the files with old data with tombstones is kept on the disk. This results in disk space being…

warrior107
- 709
- 1
- 9
- 25
1
vote
1 answer
What is the maximum size/number of lines of cassandra cqlsh_history and cli.history?
I am using cassandra version 2.1.16. I have verfied that the cli.history files contains max 501 lines. However I dont see there is a limit for cqlsh_history file. Any idea on that.

Laxmikant
- 1,551
- 1
- 13
- 30
1
vote
1 answer
LightWeight Transcation in cassandra
I have two questions regarding the LightWeight Transcation in cassandra,
1) What level of locking (Row? Column? Table? level locking) will be provided for the following two queries?
i) INSERT INTO user (user_id, user_name, user_phone, timestamp)…

Harry
- 3,072
- 6
- 43
- 100
1
vote
2 answers
Unable to see all keyspaces in C* 2.1.7 after I downgraded from 3.0 to 2.1.7
I've been using Cassandra 2.1.7 and For some reason I upgraded to 3.0.12 and later realized that some dependent apps won't work with 3.0.12 and I downgraded and using C* 2.1.7 as I was using before. But Now I'm not able to see Keyspaces in C*. (Just…

Avis
- 496
- 1
- 5
- 18
1
vote
2 answers
Using multiple hosts in cqlsh command
We are using a pig script to export data into Cassandra from hive.
The script will truncate the cassandra table and run export .
To perform TRUNCATE part, we are using the below command. But if that node is down at the moment , the script fails .
$…

Tony
- 671
- 1
- 9
- 29
1
vote
1 answer
Cassandra 2.1 speed up full compaction
I have a Cassandra 2.1 cluster using Leveled Compaction Strategy.
Base on my calculation, the cluster will run out of space before compaction kick in automatically when it reaches next level. For that reason, I have a cron job that runs "nodetool…

Cary Li
- 241
- 1
- 5
- 9
1
vote
1 answer
How can we understand the concept of replication factor in cassandra?
What is replication factor in cassandra and how does it affect single DC or multiple DC nodes ?

iNeedToAskThis
- 31
- 7