Casandra is a NoSQL database sponsored by Apache. Use this tag for a question specifically for version 2.2.
Questions tagged [cassandra-2.2]
46 questions
30
votes
3 answers
What is the batch limit in Cassandra?
I have a Java client that pushes (INSERT) records in batch to Cassandra cluster. The elements in the batch all have the same row key, so they all will be placed in the same node. Also I don't need the transaction to be atomic so I've been using…

m.hashemian
- 1,786
- 2
- 15
- 31
15
votes
1 answer
Upgrading Cassandra from 2.2 to 3.0 in RHEL
I have a RHEL 7.0 server running Cassandra 2.2.3 which I tried to upgrade to 3.0. When I run yum update it showed me there is a new version of Cassandra for update, and upgraded the server to 2.2.4-1, but not 3.0.
Now if I search yum for dsc30 I can…

m.hashemian
- 1,786
- 2
- 15
- 31
6
votes
0 answers
Cassandra Leveled Compaction Strategy requires 50% disk space overhead
We have a 24 node AWS cluster (i2.xlarge) running Cassandra 2.2.5. We have one large table and a few smaller ones. The large table consumes most of the disk space. Disk usage is unexpectedly increasing.
We are using LCS and have noticed that the…
user6575408
5
votes
1 answer
High Native-Transport-Requests All time Blocked
After running tpstats on all nodes. I see a lot of nodes having high number of ALL TIME BLOCKED NTR. We have a 4 node cluster and the values for NTR ALL TIME BLOCKED are :
NODE 1: 23953
NODE 2: 2935
NODE 3: 15229
NODE 4: 5951
I know ALL TIME BLOCKED…

johri21
- 153
- 1
- 9
5
votes
2 answers
Cassandra version upgrade from 2.0.9 to 2.2
We are planning to upgrade our cluster which currently runs on 2.0.9 to 2.2.6. According to the documentation and some blogs people upgrade cassandra inplace ie remove a node from ring upgrade it and add it back again. We are skeptical of following…

johri21
- 153
- 1
- 9
4
votes
1 answer
Unexpected exception during request
I'm using apache cassandra 2.2.4. I have a 4 (four) node cluster with Replication Factor 3 in DC1 and Replication Factor 1 in DC2, where DC1 contains 3 (three) nodes and DC2 contains 1 (one) node. There were some more nodes before in this cluster,…

Anower Perves
- 754
- 8
- 15
4
votes
2 answers
Cassandra: select only latest rows
I work with following table:
CREATE TABLE IF NOT EXISTS lp_registry.domain (
ownerid text,
name1st text,
name2nd text,
name3rd text,
registrar text,
registered timestamp,
expiration timestamp,
updated timestamp,
…

Michal
- 1,955
- 5
- 33
- 56
3
votes
2 answers
Is it safe to run sstableverify against live sstables?
Is it safe to run sstableverify against live sstables while Cassandra is running?
After and while running sstableverify in a lab, I cannot find anything in any logs that would indicate a problem.

kalaolani
- 323
- 1
- 16
2
votes
2 answers
Cassandra database import issue for timeuuid
I have installed Cassandra 2.2.12 on my window machine locally. I have exported database from live server in a '.sql' file using 'razorsql' GUI tool. I don't have server access for live, only have database access. When i am trying ti import '.sql'…

M.Bains
- 395
- 1
- 2
- 14
2
votes
2 answers
launching cassandra cqlsh python not found
I am trying to install cassandra version 2.2.0 and I found the compatible python version for it is 2.7.10 then I installed it.
when I type in terminal
python2.7 --version
Python 2.7.10
but when I launch cassandra server and want to start cassandra…

Eman
- 111
- 1
- 4
- 14
2
votes
0 answers
Cassandra PHP: "All connections on all I/O threads are busy" after adding node
I am facing a strange problem with cassandra connection, after I added new cassandra node.
Situation before adding node:
1 cassandra node on server 1 in data center 1
Fully operational java applications distributed over many machines
PHP nginx web…

Michal
- 1,955
- 5
- 33
- 56
2
votes
3 answers
Cassandra restart issues while restoring to a new cluster
I am restoring to a fresh new Cassandra 2.2.5 cluster consisting of 3 nodes.
Initial cluster health of the NEW cluster:
-- Address Load Tokens Owns Host ID Rack
UN 10.40.1.1 259.31 KB 256 …

prat0318
- 571
- 1
- 8
- 19
2
votes
1 answer
Cassandra 3 nodes cluster throwing NoHostAvailableException as soon as one node is down
We have a 3 nodes cluster with a RF 3.
As soon as we drain one node from the cluster we see many:
All host(s) tried for query failed (no host was tried)
com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed…

Etienne
- 226
- 1
- 12
2
votes
0 answers
Distributed pagination in Cassandra
I was searching for pagination in cassandra and found this perfect topic here: Results pagination in Cassandra (CQL) , with this answer accepted by majority of people. But I want to do same thing on multiple computers. I'll provide an example...
The…

Michal
- 1,955
- 5
- 33
- 56
2
votes
1 answer
Cassandra CQL: Batch select
Hi I have following table in Cassandra:
* ---------------------------------------------------------------------------
* Note:
* 'curr_pos' is always fixed, so we can put it into cluster key and order
* In each crawler iteration 'prev_pos',…

Michal
- 1,955
- 5
- 33
- 56