Stack Overflow
Stack Overflow

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
2
votes
2 answers

Major compaction on Cassandra after changing gc_grace_seconds 10 to 0 day

I have a Cassandra cluster which is having gc_grace_seconds 10 days. auto compaction is enabled and running as per configuration but I am suspecting that auto compaction is not clearing the tombstones which are expired gc_grace_seconds duration(10…
LetsNoSQL
  • 1,478
  • 1
  • 11
  • 23
2
votes
1 answer

Replacing a seed node without removing it from seed list

I have a cassandra(version 2.2.8) cluster of total 6 nodes, where 3 nodes are seed nodes. One of the seed node recently went down. I need to replace that dead seed node. My cluster is setup in a way where it cannot survive a loss of more than 1…
Eats
  • 477
  • 1
  • 6
  • 13
2
votes
1 answer

what is right practice to use Cassandra table as key-value Pair. And to perform bulk read and write on this Table

I want to create a key-value datastore where key is a url and value is around 0.5 MB data. Application requirement is to write and read about 10-20K key-values at a time which are coming from a file. What could be correct schema.? If there is no…
vermaji
  • 539
  • 2
  • 10
2
votes
2 answers

Cassandra tombstones not deleted a month after actual record TTL

Running into an issue with DSE 4.7. The tombstones are not being deleted even after compactions, cleanup, rebuild_index and repair. records have a 15 day ttl. sstablemetadata output suggests that there are 90% tombstones Any ideas? sstablemetadata…
Vikas Lalwani
  • 43
  • 8
2
votes
1 answer

How to modify System Keyspace (and its columnfamilies) in Cassandra

I am wondering if there is a workaround to ALTER the columnfamilies of System keyspace such as: schema_columns and schema_columnfamilies I tried to type ALTER CQL in CQLSH and it returned Unauthorized: Error from server: code=2100 [Unauthorized]…
Ev3rlasting
  • 2,145
  • 4
  • 18
  • 31
2
votes
1 answer

jstatd, command not found CentOS 7

I am trying to monitor VisualGC from my workstation. Command: java -version openjdk version "1.8.0_151" OpenJDK Runtime Environment (build 1.8.0_151-b12) OpenJDK 64-Bit Server VM (build 25.151-b12, mixed mode) So i created a policy file and tried…
Pramod
  • 113
  • 2
  • 14
2
votes
1 answer

4 node setup in cassandra is as same as 3 node setup

I have a 4 node setup in Cassandra and decided to go with the following configuration, but ppl are saying this will be same as 3 node setup, So could somebody please give me a light and say why, Nodes = 3, Replication Factor = 2, Write Consistency =…
Harry
  • 3,072
  • 6
  • 43
  • 100
2
votes
1 answer

Cassandra java driver protocol version and connection limits don't match

I am using java driver version: 2.1.4 Cassandra version: dsc-cassandra-2.1.10 Output from cql gives the following cqlsh 5.0.1 | Cassandra 2.1.10 | CQL spec 3.2.1 | Native protocol v3 I am protocol V3. But it throws an exception when I try to set it…
GenerousJoker
  • 87
  • 1
  • 12
2
votes
1 answer

Cassandra system hints large partition

We are using cassandra 2.1.14. Currently large partition warning is seen on system.hints table. How to make sure that system.hints table doesn't have wide partitions ? Note that we don't want to upgrade to cassandra 3 now. Is there a periodic way…
Knight71
  • 2,927
  • 5
  • 37
  • 63
2
votes
2 answers

Will diskspace increase if I increase number of nodes in Cassandra Cluster?

I have a situation in Cassandra cluster (deployed over ec2 instance) such that, the disk space is going to run out of space in each node of the cluster. Now if I add some more instances in the Cassandra cluster, will it increase disk space? What i…
user2392631
  • 497
  • 8
  • 15
2
votes
2 answers

How do you change a column value after a certain time interval - Cassandra

I have a column family in Cassandra in which one of the column name is status with value Y. This status has to be updated to a new value - X after 30 minutes if it wasn't updated to some other value say N within the 30 minutes. Basically, I want to…
gautam suddapalli
  • 65
  • 5
2
votes
2 answers

Changing commitlog directory in cassandra

Currently commitlog directory is pointing to Directory1. I want to change it different directory D2. How should the migration be ?
phaigeim
  • 729
  • 13
  • 34
2
votes
2 answers

Does cassandra guarantee row level consistency during write?

As I understand a row in a cassandra table is a Set of Key-value pairs (corresponding to each column) I notice a strange issue during insert, values are not persisted in couple of columns, though I am fairly confident it has values before insert. It…
Vinod Jayachandran
  • 3,726
  • 8
  • 51
  • 88
2
votes
1 answer

Cassandra Light Weight Transaction in batch update affecting multiple partitions / tables

There is a scenario where I need to update multiple partitions (of the same or different table) together. Consider an example of the orders here: create table test.orders_by_id( order_email text, order_id timeuuid, order_name …
Piyush
  • 43
  • 4
2
votes
1 answer

Cassandra 2.1: how to model for the N most recently active users?

I need to get a list of N users with the most recent actions using cassandra. I have tried to use the following schema: CREATE TABLE user_actions( partition_key int, username int, action_time timestamp, PRIMARY KEY(partition_key,…
cscan
  • 3,684
  • 9
  • 45
  • 83
1 2 3
…
26 27