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
1
vote
2 answers
How to Select Nth Row in Cassandra DB Table
i need to select 'N'th row from cassandra table based on the particular number i'm getting from my logic. i.e: if logic output is 23 means, i need to get 23rd row details. since there is no auto increment in cassandra,i cant able to go with ID key…
Mahesh Kumar
- 25
- 5
1
vote
1 answer
What does 'Invalid frame size' mean in Thrift
Running cassandra 2.1 clusters here where we see few errors like below from time to time:
ERROR [Thrift-Selector_15] 2017-07-15 01:08:42,677 Message.java:164 - Invalid frame size got (15826670), maximum expected 15728640
Wondering what might be the…
Steffen Winther Sørensen
- 343
- 1
- 11
1
vote
2 answers
Cassandra lots of GC on specific nodes
Since we've upgraded our cassandra clusters from version 2.0.17 to 2.1.15, we're experiencing issues with 2 nodes from a 3 node cluster.
They are consistently using much more cpu than the other one. Closer investigation seems to indicate it's down…
Mopper
- 1,677
- 2
- 18
- 41
1
vote
2 answers
Necessity of repair before Cassandra version upgrade
Our production version of DSE is 4.8.4(Cassandra 2.1.12). We run 3 nodes cluster with 256 vnodes per node, ~200GB data per node, RF=3. We are going to consistently migrate to the latest DSE version 5.1.1(Cassandra 3.10.0).
According to DataStax…
Mikita Harbacheuski
- 2,193
- 8
- 16
1
vote
1 answer
Insert row with auto increment
I create this table
CREATE TABLE table_test(
id uuid PRIMARY KEY,
varchar,
description varchar
);
And I was expecting that since id was uuid, it would be auto incremented automatically
INSERT INTO table_test (title,description) VALUES…
paul
- 12,873
- 23
- 91
- 153
1
vote
2 answers
Cassandra 2.1 Cluster Showing Consistently High CPU Usage and Slow Responses
On May 3rd we deployed. Our 3 node cassandra cluster became extremely slow and many web requests were timing out. By EOD May 3rd we launched another m1.large machine to our cluster which resolved the timeouts. That being said, the cluster was still…
cscan
- 3,684
- 9
- 45
- 83
1
vote
0 answers
cassandra table modeling - updating existing columns in bulk and adding new columns
I am migrating RDBMS tables to cassandra. We track customers who are subscribing to different categories. There are some categories already but some categories maybe added new incourse of time. Right now we are joining the tables.
details table1 -…
summer
- 139
- 1
- 10
1
vote
1 answer
Does Cassandra Optimize Storage For Repeating Strings?
We are trying to reduce our current disk usage. In doing so we noticed that most of the information we store is mostly meta data comprising of the same strings repeated across multiple tables and rows.
As strings often tend to occupy more space…
Filipe Teixeira
- 3,565
- 1
- 25
- 45
1
vote
1 answer
Datastax / Cassandra tar ball installation & run as service
I have downloaded & extracted the cassandra tar ball package. I'm able to run the process from the extracted location both in background & foreground mode. Could someone provide me instructions to run this as a service ?so that the service can start…
Siva Dasari
- 1,059
- 2
- 19
- 40
1
vote
1 answer
How to compare contents of two cassandra keyspaces
I have two keyspaces in my Cassandra cluster, where the second one has been created as a copy (schema and data) of the first one (using sstableloader).
How can I compare (check) if all the data from first one keyspace is also stored in second…
pWoz
- 1,649
- 3
- 20
- 30
1
vote
1 answer
Cassandra CQLSH shows the wrong schema?
I'm trying to migrate some data from one Cassandra cluster to
another using CQLSH's COPY, but I've run into a strange issue with
one of the column families. The schema of foo.quux, as described by
cqslsh, looks like this:
CREATE TABLE foo.quux (
…
Stig Brautaset
- 2,602
- 1
- 22
- 39
1
vote
1 answer
Load data from one table to another every 10 mins - Cassandra
We have a stream of data coming to Table A every 10 mins. No history preserved. The existing data has to be flushed to a new table B every time data is loaded in Table A. Can this be done dynamically or automated in Cassandra?
I can think of loading…
Arun.K
- 103
- 2
- 4
- 21
1
vote
2 answers
Cassandra 'nodetool repair -pr' taking way too much time
I am running a cluster with 1 datacenter (10 nodes) and Cassandra 2.1.7 installed on each. We are using SimpleStretegy (old mistake).
The situation is, I have not run any nodetool repair since begining, and now there is data of about 200 GB with 3…
r005t3r
- 228
- 1
- 8
1
vote
1 answer
Cassandra : isolated workloads
I have three workloads.
DATACENTER1 sharing data by rest services - streaming ingest
DATACENTER2 load bulk - analysis
DATACENTER3 research
I want to isolated workloads, i am going to create one datacenter foreach workloads.
The objective of the…
V.HL
- 80
- 6
1
vote
1 answer
How can I fix a Cassandra RuntimeException: [hash] is not defined as a collection?
I've been experiencing problems with a 3 node, RF 3, Cassandra 2.1.16 cluster and will try and describe them as accurately as possible considering the knowledge I've got at this point.
Adding a new row to a table either:
a) does not replicate to…
HelpfulPanda
- 377
- 3
- 14