Counter column impossible to delete and re-insert

Hi, I have a table with counter column . When I insert (update) a row, delete it and try to re-insert, it fail to re-insert the row. Here is the commands i use : CREATE TABLE test( testId int, year int, testCounter counter, PRIMARY KEY (testId, year) )WITH CLUSTERING ORDER BY (yea

Re: Storing files in Cassandra with Spring Data / Astyanax

Hi, We are building an application where we install it on-premise, usually there is no internet connection at all there. As I am using Cassandra for storing everything else in the application, it would be very convenient to also use Cassandra for those files so I don't have to set up 2 distributed

Re: tuning concurrent_reads param

Sorry I have late follow up question In the Cassandra.yaml file the concurrent_read section has the following comment: What does it mean by " the operations to enqueue low enough in the stack that the OS and drives can reorder them." ? how does it help making the system healthy? What really

Re: Why is one query 10 times slower than the other?

In your “lookup_code” example “type” is not a clustercolumn it is the partition key, and hence the first query only hits one partition The second query is a range slice across all possible keys, so the sub-ranges are farmed out to nodes with the data. You are likely at CL_ONE, so it only needs re

Why is one query 10 times slower than the other?

Hi Guys, I have two cassandra 2.0.5 nodes, RF=2. When I do a: select * from table1 where clustercolumn=‘something' The trace indicates that it only needs to talk to one node, which I would have expected. However when I do a: select * from table2 Which is a small table with only has 20

Re: Cassandra heap pre-1.1

We are planning to upgrade soon. But in the meantime, I wanted to see if we can tweak certain things. -Rajesh On Wed, Nov 5, 2014 at 3:10 PM, Robert Coli wrote: > On Tue, Nov 4, 2014 at 8:51 PM, Raj N wrote: > >> Is there a good formula to calculate heap utilization in Cassandra >> pre-1.1, sp

Re: Storing files in Cassandra with Spring Data / Astyanax

On Wed, Nov 5, 2014 at 8:19 AM, Wim Deblauwe wrote: > I am currently testing with Cassandra and Spring Data Cassandra. I would > now need to store files (images and avi files, normally up to 50 Mb big). > https://github.com/mogilefs/ A for distributed/replicated file storage, would use agai

Re: Storing files in Cassandra with Spring Data / Astyanax

Astyanax isn't deprecated; that user is wrong and is downvoted--and has a comment mentioning the same. What you're describing doesn't sound like you need a data store at all; it /sounds/ like you need a file store. Why not use S3 or similar to store your images? What benefits are you expecting t

use select with different attributes present in where clause Cassandra

Hello all, I need to create a Cassandra column family with following attributes. id bigint, content varchar, year int, frequency int, I want to get the content with highest frequency in a given year using this column family. Also when inserting data to table, for given content and year, I need t

Re: different disk foot print of cassandra data folder on copying

Duh. I totally forgot about my snapshotting just before daily rsync backup. k.z. On Wed, Nov 5, 2014 at 3:13 PM, Robert Coli wrote: > On Wed, Nov 5, 2014 at 12:08 PM, KZ Win wrote: >> >> I have cassandra nodes with long uptime. Disk foot print for >> cassandra data older is different when I c

Re: different disk foot print of cassandra data folder on copying

On Wed, Nov 5, 2014 at 12:08 PM, KZ Win wrote: > I have cassandra nodes with long uptime. Disk foot print for > cassandra data older is different when I copy to a different folder. > > I am talking about as much 100% different for 25-40GB of data. On > copying they grow to double that. 1) C

Re: Cassandra heap pre-1.1

On Tue, Nov 4, 2014 at 8:51 PM, Raj N wrote: > Is there a good formula to calculate heap utilization in Cassandra > pre-1.1, specifically 1.0.10. We are seeing gc pressure on our nodes. And I > am trying to estimate what could be causing this? Using node tool info my > steady state heap is at abo

different disk foot print of cassandra data folder on copying

I have cassandra nodes with long uptime. Disk foot print for cassandra data older is different when I copy to a different folder. Why is that ? I have used rsync and cp. This can be very confusing when trying to do certain maintenance tasks like hardware upgrade on EC2 and backing up a snapshot.

Storing files in Cassandra with Spring Data / Astyanax

Hi, I am currently testing with Cassandra and Spring Data Cassandra. I would now need to store files (images and avi files, normally up to 50 Mb big). I did find the Chuncked Object store from Astyanax which looks promising. However

Re: Unsubscribe

http://cassandra.apache.org/#lists 2014-11-04 21:59 GMT+01:00 James Carman : > You should have received an email when you signed up which gives you > instructions on how to unsubscribe. Otherwise, send an email to > user-h...@cassandra.apache.org > > On Mon, Nov 3, 2014 at 10:30 PM, Malay Nilabh

Bulk Load Hadoop to Cassandra

Hi, I intend to bulk load data from HDFS to Cassandra using a map-only program which uses the BulkOutputFormat class. Please advise me which versions of Cassandra and Hadoop would support such a use-case. I am using Hadoop 2.2.0 and Cassandra 2.0.6 and I am getting following error: Error: Foun