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
0
votes
1 answer
Will Cassandra be useful for this scenerio
I have around 10 Million names, combination of about 5 files each consisting of 2 million names and there are 100s of users. Each user comes with a file which has 1Million numbers.
I need to process these 1 million numbers against 2 million names…

Varun
- 5
- 2
0
votes
0 answers
I can see cassandra is CPU bound for write heavy work loads but is it network bound as well?
SETUP: 1
3-node cassandra cluster. Each node is on a different machine with 4 cores 32 GB RAM, 800GB SSD (DISK), 1Gbit/s = 125 MBytes/sec Network bandwith
2 cassandra-stress client machines with same exact configuration as above.
Experiment1: Ran…

user1870400
- 6,028
- 13
- 54
- 115
0
votes
1 answer
How to do delete rows based on indexed column in cassandra
Current Approach that i am using for deleting rows based on indexed column
Select query with a limit 100.
If there are rows Delete all the fetched rows one by one.
Flush the entity Manager.
Go to step 1.
Using cassandra 2.1.8 and…

Prabhath
- 629
- 6
- 13
0
votes
2 answers
Cannot change timezone in Cassandra 2.1.11 to IST
I am inserting the data from C# to Cassandra cluster in IST ('2015-12-28') format. But when i query the same data using cqlsh. It gives me in '2015-12-27 18:30:00+0000' format. So, to change the format i have tried some of the suggestion but…

Naresh
- 5,073
- 12
- 67
- 124
0
votes
2 answers
Does CQL3 "IF" make my update not idempotent?
It seems to me that using IF would make the statement possibly fail if re-tried. Therefore, the statement is not idempotent. For instance, given the CQL below, if it fails because of a timeout or system problem and I retry it, then it may not work…

Jason
- 2,006
- 3
- 21
- 36
0
votes
0 answers
cqlsh does not show the frozen collection in the table
CREATE TABLE data.banks (
id text,
codes frozen

Prabhath
- 629
- 6
- 13
0
votes
1 answer
How to handle a datacenter outage in a mutil-datacenter Cassandra Cluster
Our application is running in a Cassandra Cluster of six nodes with two data centers.
Cluster information:
Cassandra version : 2.0.3
Snitch : GossipingPropertyFileSnith
Partitioner :…

Ravi Raja Chandra Bose
- 73
- 1
- 9
0
votes
1 answer
Can not get rid of tombstones in cassandra 2.1.8 using (STCS) SizeTieredCompactionStrategy
I have a 3 nodes cassandra (2.1.8) cluster on which I am running application using titan db (v0.5.4). The amount of data is very small (<20 MB) but as my use case require deletes from time to time I already have problems with tombstones.
I can not…

Krzysztof Genge
- 11
- 4
0
votes
2 answers
Datastax Enterprise: Added Node serviing data before replication is complete
We have a cluster of 3 Cassandra 2.1 nodes in Datastax Enterprise; we had to replace one of our nodes that had a hardware failure. When we added the third node, it immediately started to serve requests before it had completed data…

Robert Glassett
- 9
- 3
0
votes
1 answer
Cassandra account modeling with indexes
We are modeling account table in cassandra with social logins, we chose email as primary key and skinny row implementation. Our cassandra is on version 2.1.6. Here is table definition:
CREATE TABLE account_by_email (
email_address text,
…

Nenad Bozic
- 3,724
- 19
- 45
0
votes
1 answer
Select query shows nohostavailableexception without partition key in where condition
I am trying to read rows from dev center and client apis but if i "select *" for all 2k rows it shows no host available exception in query trace though it has all the nodes up in cluster. but if i keep partition key in where condition it doesn't…

john cena
- 41
- 4
0
votes
0 answers
NoHostAvailableException while reading in cassandra
We are getting nohostavailable exception on client for reading 2000 rows( just 3 simple columns ), tried on different tables but ended up with same error. I changed socket connect and read timeout but still it didn't solve the issue. And I found…

john cena
- 41
- 4
0
votes
1 answer
Atomic probabilistic counting and set membership in Cassandra
I am looking to do probabilistic counting and set membership using structures such as bloom filters and hyperloglog.
Is there any support for using such data structures and performing operations on them atomically on the server-side, through…

Daniel Siegmann
- 287
- 1
- 3
- 5
0
votes
1 answer
Leveled Compaction Strategy with low disk space
We have Cassandra 1.1.1 servers with Leveled Compaction Strategy.
The system works so that there are read and delete operations. Every half a year we delete approximately half of the data while new data comes in. Sometimes it happens that disk usage…

Maxim Zakharenkov
- 311
- 2
- 12
0
votes
2 answers
InvalidQueryException when trying to create column family in Cassandra via unit
I have a 3 node cassandra cluster and via my unit test in Java, I first create a keyspace and then create a column family within that keyspace. Sometimes the unit tests passes but randomly I keep getting the following error. I am using the latest…

Sau
- 21
- 3