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
2 answers
Cassandra: creating a Partition Key
I have a table student (id,marks,score) in cassandra. i created the table with id as primary key. I need to sort table by score and i haven't created a partition key for score. How to create a partition key without recreating table?

Vignesh Mohan
- 11
- 2
0
votes
1 answer
How to create table structure which supports multiple WHERE Clause with different ORDER BY in Cassandra
hi every one thank you in advance for your help and sorry for my bed English.
i am newbie with Cassandra database.
now my problem is
i want to create a table on which i can fire multiple query with different type of where clause and order by…

Vishnu
- 375
- 4
- 16
0
votes
1 answer
Strange replication in Cassandra
I have configured locally 3 nodes in on 'Test Cluster' of Cassandra. When I run them and create some keyspace or table also on all three nodes the keyspace or the table appears.
The problem I'm dealing with is, when I'm importing from CSV millions…

iMajna
- 489
- 4
- 28
0
votes
1 answer
Cassandra JMX need to connect all the nodes
I am trying to get to know Cassandra cfstats information from all the machines using JMX. This can be done using OpsCenter, but I do not want to use it. I started building my own utility. For now, my java program connects to JMX and fetching cfstats…

Madhu Mohan Kommu
- 335
- 2
- 13
0
votes
1 answer
Cassandra incorrect TTL value for select ttl()
I have a 3 node cluster with replication factor : 2.
The column family in consideration has default_time_to_live = 3600
Which is set using alter table :
cqlsh:summary> alter table match with default_time_to_live=3600;
After inserting data into…

nitesh
- 1
- 5
0
votes
0 answers
How to generate fake data for cassandra
Hi I need to generate fake data for cassandra
about 100 000 000 row so i tried to generate .csv file with 1 000 000 row
and then import that in db 100 time, but there is a problem when I use COPY
operator I must have all uuid, so using COPY isn't…

ashmna
- 95
- 1
- 9
0
votes
1 answer
Connecting two desktop PC into multi node cluster Cassandra
I'm doing this for the very first time and I need help about clearing some stuffs.
I have Ubuntu 14.04 desktop on one machine, and on the other I have Windows 8.1. also on both machines I have installed the same version of Cassandra.
Can someone…

iMajna
- 489
- 4
- 28
0
votes
2 answers
How to setup stomp_interface for failover node for cassandra Opscenter
How to setup a fail-over node for Cassandra Opscenter. The Opscenter data is stored on Opscenter node itself. So to setup a failover node i need to setup an Opscenter different from current Opscenter and sync Opscenter data and config files between…

user6288321
- 365
- 4
- 14
0
votes
2 answers
Schedule read repair before read
I have a reporting tool which reads data from Cassandra. Configurations are Consistency level is LOCAL_QUORUM, Compaction Strategy is size-tiered and RF=3.
When the pull request from reporting tool to Cassandra, as per the Cassandra design it…

Madhu Mohan Kommu
- 335
- 2
- 13
0
votes
1 answer
sstablesplit not working on cassandra 2.1.12
I have a sstable having a size of 40GB which i was trying to split using the following command :
bin/sstablesplit --no-snapshot -s 10 keyspace-columnfamily-ka-2466-Data.db
But it deletes the current file of 40Gb and doens't even split it without…

Naresh
- 5,073
- 12
- 67
- 124
0
votes
1 answer
Cassandra if not exist to enforce unique emails
Hello I am very new to Cassandra and have begun to learn it a couple days ago. I have a question when it comes to if not exist function. Does if not exist work on only 1 column ? . My concern is that if I have a column family that contains 3…

Ignacio Perez
- 2,341
- 3
- 13
- 18
0
votes
1 answer
Why sstable2json and json2stable is not there in Cassandra 2.1.12
sstable2sjon and json2stable utilities are not present in Cassandra 2.1.12. Is there anyway i could use them with the existing Cassandra version. Also, is there any limit on the size of parition which these utilities can handle to import and export…

Naresh
- 5,073
- 12
- 67
- 124
0
votes
1 answer
Difference between creating a secondary index vs creating an index CF manually in Cassandra
Can anyone tell me the differnce between creating a secondary index vs creating an index CF manually in Cassandra

Naresh
- 5,073
- 12
- 67
- 124
0
votes
2 answers
Cassandra implementing string search pattern
Does Cassandra support like attribute on a string. I feel like based on partition system in cassandra, this type of query is not even supported in cassandra.
If I have model post
CREATE TABLE Post (
title text PRIMARY KEY,
description…

Srikan
- 2,161
- 5
- 21
- 36
0
votes
1 answer
What is the best way to swap hard drives in cassandra
we have dense nodes. (~1TB per node; 8 node cluster. DSC 2.1.13; RF=3). we are planning on moving SSDs from spinning disks. what is the best way of doing this?
Approach 1: nodetool decommission -> going to take for ever to re-distribute all the data…

DataJanitor
- 456
- 2
- 4
- 16