Questions tagged [cassandra-2.2]

Casandra is a NoSQL database sponsored by Apache. Use this tag for a question specifically for version 2.2.

46 questions
1
vote
1 answer

Cassandra denormalization vs normalization

Denormalized reality In my database I have following denormalized table which perfectly suits to my use-case and I am receiving data very fast... CREATE TABLE IF NOT EXISTS lp_webmap.link ( drank int, prank int, title text, nofollow…
1
vote
1 answer

Cassandra batch isolation guarantee

I have a question regarding Cassandra batch isolation: Our cluster consist of a single datacenter, replication factor of 3, reading and writing in LOCAL_QUORUM. We must provide a news feed resembling an 'after' trigger, to notify clients about CRUD…
AQ1
  • 15
  • 5
1
vote
1 answer

Defining a partition key in Cassandra

I'm playing around with Cassandra for the first time and I feel like I understand the basics and limits. I'm working with the following model, as an example, for storing tweets collected by hashtag. create table posts ( id text, status…
Chris
  • 27,596
  • 25
  • 124
  • 225
1
vote
1 answer

How can I create a local multi-node Cassandra cluster on Windows 7 64 bit?

I am looking for a set of instructions to create a local multi-node Cassandra 2.x cluster on a Window 7 64 bit PC. It should preferably use CCM “Cassandra Cluster Manager” and allow management using DataStax OpsCenter I followed the instructions…
Adrian
  • 6,013
  • 10
  • 47
  • 68
0
votes
1 answer

Cassandra does not load commitlog from the data folder

I am new to cassandra, but i want to resotore cassandra back up. While restoring cassandra does not load data which is not yet commited to mem table and available in the Commitlog. as i know it has benchmark based on that it will commit the data in…
montu
  • 1
0
votes
1 answer

Fail fast Cassandra NTR blocked tasks

We ran into an issue where a Cassandra node goes down in a cluster of 18 nodes and the overall cluster read/write latencies spike up due to which the Native Transport requests threads reach maximum capacity of 128 (default) and the NTR max queued…
0
votes
1 answer

Repair after/before decommissioning in Cassandra?

We're planning to decommission few nodes from our Apache Cassandra 2.2.8 cluster, do we need to do repair after decommission or before decommission? or no need of repair at all in this case?
KISHOR
  • 21
  • 3
0
votes
1 answer

Monitor/Log slow running queries in Apache Cassandra 2.2.X

how to monitor/log slow running queries in Apache Cassandra 2.2.X version without using any external monitoring tools? Is there is any parameter that we can set in YAML to log slow running queries? or any other approach? Also in CASSANDRA-12403, i…
KISHOR
  • 21
  • 3
0
votes
0 answers

How to Install and Use Cassandra Reaper for Apache Cassandra 2.2.X version

We are using Cassandra 2.2.x version in production and currently we are manually triggering the repairs on each node. So we are planning to automate repairs using Cassandra Reaper. I don't see much documentation on it. Can anyone please list the…
KISHOR
  • 21
  • 3
0
votes
1 answer

Audit log in Cassandra 2.2.8 community edition

Is there any way to log queries along with user that executed the query in Cassandra community edition? I'm looking for a Server level solution, not driver/client based solution Thanks!
ecunado
  • 101
  • 5
0
votes
1 answer

Cassandra keyspace creation goes in infinite loop with cassandra driver 2.2.0-rc3

I have setup a 3 nodes cassandra cluster in single machine(Ubantu), And I do the following - All three nodes up and application is able to create keyspace. Shutdown one out of 3 running nodes and application is still able to create keyspace.…
0
votes
1 answer

Cassandra data synchronization and full repair

I'm running a Cassandra 2.2.8 cluster of 3 nodes in a single data center. The replication factor is 3. I had to recover one of the nodes from an old backup. After recovering the backup I ran a full repair to sync the latest data, but it seems that…
ecunado
  • 101
  • 5
0
votes
1 answer

How can I view pending Cassandra repair tasks?

I have a Cassandra 2.2.9 repair that has failed, and in this state the Cassandra metrics show about 70 repair tasks still pending. Cassandra should take care of retrying these failed tasks itself, but for whatever reason this time it has not. The…
0
votes
1 answer

How to Insert into cassandra table using select from another table in cassandra?

insert into sys.new_table select id + (select max(id) from sys.Old_table),name from sys.Old_table; By this we can able to insert data from one table to another table in Oracle. How can i write this query in Cassandra? Old_table ID,Case…
xyz_scala
  • 463
  • 1
  • 4
  • 21
0
votes
1 answer

Coordinator get responce from one node notably later than from other nodes

Please, help me to understand what i missed. I see strange behavior of one cluster node on SELECT with LIMIT and ORDER BY DESC clauses: SELECT cid FROM test_cf WHERE uid = 0x50236b6de695baa1140004bf ORDER BY tuuid DESC LIMIT 1000; TRACING (only…