Questions tagged [cassandra-2.0]

Cassandra 2.0 is a NoSQL database sponsored by Apache.

Cassandra 2.0 is a NoSQL database sponsored by Apache.

Cassandra advertises itself to have the following merits:

  1. Proven (used by many large established companies);
  2. Performant (peforms consistently well on NoSQL benchmarks);
  3. Fault tolerant (data is automatically replicated to multiple nodes for fault-tolerance. Replication across multiple data centers is supported. Failed nodes can be replaced with no downtime.);
  4. Decentralized (there are no single points of failure and no network bottlenecks. Every node in the cluster is identical);
  5. Durable (durability is the property that writes, once completed, will survive permanently, even if the server is killed or crashes or loses power.); and
  6. Elastic (read and write throughput both increase linearly as new machines are added, with no downtime or interruption to applications);
1327 questions
6
votes
2 answers

No appropriate python interpreter found. Cassandra

I am a java developer and am very new to Linux and Cassandra. I am using CentOS6. I am trying to install Cassandra3.4 in the Linux machine. I have followed the steps mentioned in here. Looks like the Linux machine already has Python installed. When…
Andy
  • 5,433
  • 6
  • 31
  • 38
6
votes
3 answers

Cassandra: Adding new column to the table

Hi I just added a new column Business_sys to my table my_table: ALTER TABLE my_table ALTER business_sys TYPE set; But again I just droped this column name because I wanted to change the type of column: ALTER TABLE my_table DROP…
JOGO
  • 285
  • 2
  • 7
  • 16
6
votes
3 answers

Range query on secondary index in cassandra

I am using cassandra 2.1.10. So First I will clear that I know secondary index are anti-pattern in cassandra.But for testing purpose I was trying following: CREATE TABLE test_topology1.tt ( a text PRIMARY KEY, b timestamp ) WITH…
undefined_variable
  • 6,180
  • 2
  • 22
  • 37
6
votes
2 answers

How to set Cassandra (>2.0) JVM heap size of 8GB?

How to set Cassandra (>2.0) JVM heap size of 8GB? When I type in free -m it gives me the following. How can I set the Cassandra JVM heap size to 8GB? total used free shared buffers cached Mem: 16047 …
user1870400
  • 6,028
  • 13
  • 54
  • 115
6
votes
1 answer

Cassandra 3.0 updated SSTable format

According to this issue, Cassandra's storage format was updated in 3.0. If previously I could use cassandra-cli to see how the SSTable is built, to get something like this: [default@test] list phonelists; ------------------- RowKey: scott =>…
6
votes
1 answer

Cassandra Query Failures: All host(s) tried for query failed (no host was tried)

I am not able to do queries against the Cassandra Node. I am able to make the connection to the cluster and connect. However while doing the the query, it fails Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s)…
im2kul
  • 297
  • 1
  • 3
  • 13
6
votes
3 answers

Event de-duplication using Cassandra

I'm looking for the best way to de-duplicate events using Cassandra. I have many clients receiving event id's (thousands per second). I need to ensure that each event id is processed once and only once with high reliability and high…
Jim Meyer
  • 9,275
  • 1
  • 24
  • 49
6
votes
2 answers

How to delete a record in Cassandra?

I have a table like this: CREATE TABLE mytable ( user_id int, device_id ascii, record_time timestamp, timestamp timeuuid, info_1 text, info_2 int, PRIMARY KEY (user_id, device_id, record_time, timestamp) ); When I ask…
m.hashemian
  • 1,786
  • 2
  • 15
  • 31
6
votes
1 answer

There is no rollback in Cassandra, then how does Cassandra remove failed writes?

Suppose I have a 2 node cluster with Replication Factor(RF) = 2. I fire an insert with Consistency 2. Cassandra starts to write to these 2 nodes while client is waiting for a response. In between one node fails and could not complete the write,…
6
votes
1 answer

How do I change location of Cassandra storage files?

I am running a single node test instance of Apache Cassandra. I would like to change the location of where Cassandra stores its files to an external disk. How can I change it?
syntagma
  • 23,346
  • 16
  • 78
  • 134
6
votes
0 answers

Cassandra: How to get a list of processes?

Hello Cassandra Experts, How can I get a list of processes in Cassandra cluster (similiar to the show processlist command of MySQL)? Im puzzled as to why I cannot find any posts anywhere about this topic. Thanks.
6
votes
2 answers

Data Versioning in Cassandra with CQL3

I'm struggling with the data modelling for the use cases I'm trying to satisfy. I looked at this and this and even this but they're not exactly what I needed. I have this basic table: CREATE TABLE documents ( itemid_version text, …
Dexter Legaspi
  • 3,192
  • 1
  • 35
  • 26
6
votes
1 answer

Astyanax Cassandra Double type precision

I'm trying to get a Double value from a Cassandra table with a double type column. I've created the table in CQL3 syntax: CREATE TABLE data_double ( datetime timestamp, value double, primary key (datetime) ); I've inserted a…
Guy Wald
  • 599
  • 1
  • 10
  • 25
6
votes
3 answers

How do you insert custom timeuuid's to cassandra without the now() function?

I was trying to insert a specific timeuuid to cassandra and the only way I managed to insert one was using the now() function, because I assume, the now function knows what format the database likes it. How do I create cqlsh command for…
Charlie Parker
  • 5,884
  • 57
  • 198
  • 323
6
votes
4 answers

Atomic Batches in Cassandra

What do you mean by Batch Statements are atomic in cassandra? Docs are a bit confusing in nature to be precise. Does it mean that queries are atomic across nodes in cluster? Say,for example, i have a batch with 100 queries. If the 40th query in…