RE: Hiper-V snapshot and Cassandra

2015-10-21 Thread Raul D'Opazo
Hi, so what is the usual thing to take care of backups: -Take Cassandra snapshots -Take this snapshots to a backup system ? From: Robert Coli [mailto:rc...@eventbrite.com] Sent: Tuesday, October 20, 2015 5:07 PM To: user@cassandra.apache.org Subject: Re: Hiper-V snapshot and Cas

Re: C* Table Changed and Data Migration with new primary key

2015-10-21 Thread Jeff Jirsa
Because the data format has changed, you’ll need to read it out and write it back in again. This means using either a driver (java, python, c++, etc), or something like spark. In either case, split up the token range so you can parallelize it for significant speed improvements. From: "qihu

C* Table Changed and Data Migration with new primary key

2015-10-21 Thread qihuang.zheng
Hi All: We have a table defined only one partition key and some cluster key. CREATE TABLE test1 ( attribute text, partner text, app text, "timestamp" bigint, event text, PRIMARY KEY ((attribute), partner, app, "timestamp") ) And now we want to split original test1 table to 3 t

Object Mapping VS Direct Queries

2015-10-21 Thread Ashish Soni
Hi All , Please let me know if there are any disadvantages of using Object Mapping instead of writing direct CQL queries. Ashish

UNSUBSCRIBE

2015-10-21 Thread Rampally, Parthasaradhi - Fairfax, VA - Contractor
UNSUBSCRIBE

Re: Read query taking a long time

2015-10-21 Thread Carlos Alonso
Well... I think that pretty much is showing the problem. The problem I'd say is a bad data model. Your read query is perfect, it hits a single partition and that's the best situation, but on the other hand, it turns out that there are one or two huge partitions and fully reading them is extremely

Re: Read query taking a long time

2015-10-21 Thread Laing, Michael
Are the clocks synchronized across the cluster - probably, but I thought I would ask :) On Wed, Oct 21, 2015 at 3:35 AM, Brice Figureau < brice+cassan...@daysofwonder.com> wrote: > Hi, > > On 20/10/2015 19:48, Carlos Alonso wrote: > > I think also having the output of cfhistograms could help. I'd

ALTER TABLE implementation details

2015-10-21 Thread Mikhail Sokolov
Hi! I'm using Cassandra 2.2 for my home-grown SAAS and currently evaluating prospect of adding columns to tables on user requests. So I have a couple of questions regarding ALTER TABLE statement: 1) how adding/removing columns implemented on cluster level? 2) in case of column addition how soon af

Re: Read query taking a long time

2015-10-21 Thread Brice Figureau
Hi, On 20/10/2015 19:48, Carlos Alonso wrote: > I think also having the output of cfhistograms could help. I'd like to > know how many sstables are being hit during reads. Ooops, my bad I thought you mentioned proxyhistograms. Here's the worst node cfhistograms: nodetool cfhistograms akka messag