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
17
votes
2 answers
Max. size of wide rows?
Theoretically, Cassandra allows up to 2 billion columns in a wide row.
I have heard that in reality up to 50.000 cols/50 MB are fine; 50.000-100.000 cols/100 MB are OK but require some tuning; and that one should never go above 100.000/100 MB…

tbsalling
- 4,477
- 4
- 30
- 51
13
votes
1 answer
How does the Leveled Compaction Strategy ensure 90% of reads are from one sstable
I am trying to understand how the Leveled Compaction Strategy in Cassandra works that guarantees 90% of all reads will be satisfied from a single sstable.
From DataStax Doc:
new sstables are added to the first level, L0, and immediately compacted…

Chaity
- 1,348
- 13
- 20
11
votes
1 answer
Cassandra Compaction vs Repair vs Cleanup
After posting a question and reading this and that articles, I still do not understand the relations between those three operations-
Cassandra compaction tasks
nodetool repair
nodetool cleanup
Is repair task can be processed while compaction…
user2552806
11
votes
2 answers
Is Cassandra for OLAP or OLTP or both?
Cassandra does not comply with ACID like RDBMS but CAP. So Cassandra picks AP out of CAP and leaves it to the user for tuning consistency.
I definitely cannot use Cassandra for core banking transaction because C* is slightly inconsistent.
But…

Suhas Chandramouli
- 465
- 1
- 6
- 12
10
votes
2 answers
Optimal JVM settings for Cassandra
I have a 4 node cluster with 16 core CPU and 100 GB RAM on each box (2 nodes on each rack).
As of now, all are running with default JVM settings of Cassandra (v2.1.4). With this setting, each node uses 13GB RAM and 30% CPU. It is a write heavy…

dvl
- 741
- 2
- 8
- 19
9
votes
2 answers
JanusGraph + Cassandra (Generic questions)
I have a few questions regarding the integration of the two tools. Not technical questions and how to setup( i will have my fun with that later ) but more on the course of the project and the direction, seeing that JanusGraph is still very young.
I…

iocentos
- 263
- 4
- 12
9
votes
2 answers
How to prevent Cassandra commit logs filling up disk space
I'm running a two node Datastax AMI cluster on AWS. Yesterday, Cassandra started refusing connections from everything. The system logs showed nothing. After a lot of tinkering, I discovered that the commit logs had filled up all the disk space on…

plamb
- 5,636
- 1
- 18
- 31
8
votes
1 answer
You have to be logged in and not anonymous to perform this request in cassandra even though I access it with cassandra userid
This is Cassandra 2.1.13 day2 for me.
I've been through 10 min. cassandra tutorial at http://www.planetcassandra.org/try-cassandra/ on my local machine.
% cqlsh -u cassandra -p cassandra
% // create demo keyspace
% // create users table
% //insert a…

user2761895
- 1,431
- 4
- 22
- 38
8
votes
3 answers
Cassandra replication factor greater than number of nodes
I am using the datastax java driver for Apache Cassandra (v. 2.1.9) and I am wondering what should happen when I set replication_factor greater than number of nodes. I've read somewhere that Cassandra allows for this operation, but should fail when…

bemol
- 381
- 3
- 18
8
votes
3 answers
Schema changes are getting timed out in Cassandra
I tried setting up a 2 node Cassandra setup and it's quite done. Nodes are seems connected as shown below :
Datacenter: datacenter1
=======================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens …

Harsh Pandit
- 101
- 1
- 5
6
votes
2 answers
How to restart one live node from a multi node cassandra cluster?
I have a production cassandra cluster of 6 nodes. I have made some changes to the cassandra.yaml file on one node and hence need to restart it.
How can I do it without losing any data or causing any cluster related issues?
Can I just kill the…

Abhishek S
- 103
- 1
- 1
- 8
6
votes
2 answers
No appropriate python interpreter found. Cassandra
I am a java developer and am very new to Linux and Cassandra. I am using CentOS6. I am trying to install Cassandra3.4 in the Linux machine. I have followed the steps mentioned in here.
Looks like the Linux machine already has Python installed. When…

Andy
- 5,433
- 6
- 31
- 38
6
votes
2 answers
datastax opscenter agents not installing
I'm running my own version of cassandra on 127.0.1.1. I changed the rpc_address and also the address to 127.0.1.1.
When I'm starting Opscenter I'm prompted to install agents and I'm doing so by the recommended Fix now option. But when I try to…

HackCode
- 1,837
- 6
- 35
- 66
5
votes
3 answers
View Cassandra Partitions using CQLSH
Using Cassandra, how do i see how many partitions were created base on how i created the primary key? I have been following a tutorial and it mentions to go to bin/cassandra-cli and use the LIST command. However, the latest Cassandra install does…

BigBug
- 6,202
- 23
- 87
- 138
5
votes
3 answers
How can I create User Defined Functions in Cassandra with Custom Java Class?
I couldn't find this anywhere online. How can I create a custom user defined function in cassandra?.
For Ex :
CREATE OR REPLACE FUNCTION customfunc(custommap map)
CALLED ON NULL INPUT
RETURNS map
LANGUAGE java AS 'return…

Venky
- 101
- 1
- 10