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
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…
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…
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.
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…
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…
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 ?