Re: Lost data due to Cassandra update

2013-08-16 Thread Robert Coli
On Fri, Aug 16, 2013 at 2:39 PM, Dhamodaran Subramanian < sdhamoda...@gmail.com> wrote: > Is there a way I can retreive the data by revoking this command. > > I see that data files are in places. Any help will be much appreciated. > 1) snapshot/back up the data files 2) Re-define the original sch

write load while idle?

2013-08-16 Thread Keith Freeman
I have a 3-node cluster running 1.2.8, and with no clients connected (for about an hour) opscenter is showing a heartbeat-like pattern for total writes in the "Cluster Reads & Writes" panel on the dashboard ranging from about 10/sec to 26/sec. Total reads on the other hand are showing a straig

Lost data due to Cassandra update

2013-08-16 Thread Dhamodaran Subramanian
Hey Guys, I know its stupid question. I wanted to change the structure of column by adding it as a key but instead of that I just gave "update columnfamily ;". It dropped all the other column except my pre existing key column. I can't afford to lose the data. Is there a way I can retreive

Re: Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Arthur Zubarev
I understand the intent is to remove select columns, then the simple DELETE would do. The other way of doing things is probably having empty placeholders for the dates/data. /Arthur From: Suruchi Deodhar Sent: Friday, August 16, 2013 2:38 PM To: user@cassandra.apache.org ; Arthur Zubarev Su

Re: Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Suruchi Deodhar
We are using the cassandra thrift interface to interact with Cassandra. In our use case, we store time-series data with one column per day (per row-key) , and we have a fixed number of column families to store data over time. Since we have data for hundreds of days, we cannot create column-familie

Re: Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Arthur Zubarev
Not sure what client you use to interact with C*. In your scenario I assume it is CQL. So what can go wrong with TRUNCATE? Regards Arthur From: Suruchi Deodhar Sent: Friday, August 16, 2013 12:23 PM To: user@cassandra.apache.org Subject: Deleting column data from Cassandra without setting i

Re: Configuring ephemeral only column family

2013-08-16 Thread Jon Haddad
+1 for redis for this use case. On Aug 16, 2013, at 10:54 AM, Robert Coli wrote: > On Fri, Aug 16, 2013 at 10:43 AM, Todd Nine wrote: > We're using expiring columns as a mean for locking. > > Perhaps a log structured data store with immutable data files is not ideal > for your use case? >

Re: Configuring ephemeral only column family

2013-08-16 Thread Robert Coli
On Fri, Aug 16, 2013 at 10:43 AM, Todd Nine wrote: > We're using expiring columns as a mean for locking. Perhaps a log structured data store with immutable data files is not ideal for your use case? If I were you, I'd put this use case in Redis and be done with it instead of trying to get Ca

Re: Configuring ephemeral only column family

2013-08-16 Thread Arthur Zubarev
What about compactions, how often do you run them? -Original Message- From: Todd Nine Sent: Friday, August 16, 2013 1:43 PM To: user@cassandra.apache.org Subject: Configuring ephemeral only column family Hi guys, We're using expiring columns as a mean for locking. All of this data sh

Configuring ephemeral only column family

2013-08-16 Thread Todd Nine
Hi guys, We're using expiring columns as a mean for locking. All of this data should be completely ephemeral with only a 5 second ttl per column. We're seeing some strangeness where our rows are getting quite large with tombstones. We really don't need the commit log, nor the sstables in our u

Re: DataStax Native Protocol Python Driver [beta]

2013-08-16 Thread Blair Zajac
On 8/16/13 9:05 AM, Tyler Hobbs wrote: On Fri, Aug 16, 2013 at 3:35 AM, Sergey Leschenko mailto:sergle...@gmail.com>> wrote: Is there some list of planned drivers for other programming languages? I don't know if we have a list somewhere, but we're currently working on a C/C++ driver and w

Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Suruchi Deodhar
What is the best way to delete column data from a Cassandra cluster after it is backed up with snapshots (using Priam or otherwise) to a stable storage? We dont want to use the TTL option, since we would like to restore the backed-up data in the Cassandra cluster at a later time. Setting a TTL wo

Re: token(), limit and wide rows

2013-08-16 Thread Jonathan Rhone
Read http://www.datastax.com/dev/blog/cql3-table-support-in-hadoop-pig-and-hive And look at http://fossies.org/dox/apache-cassandra-1.2.8-src/CqlPagingRecordReader_8java_source.html - Jon On Fri, Aug 16, 2013 at 12:08 PM, Keith Freeman <8fo...@gmail.com> wrote: > I've run into the same proble

Re: token(), limit and wide rows

2013-08-16 Thread Keith Freeman
I've run into the same problem, surprised nobody's responded to you. Any time someone asks "how do I page through all the rows of a table in CQL3?", the standard answer is token() and limit. But as you point out, this method will often miss some data from wide rows. Maybe a Cassandra expert

Re: DataStax Native Protocol Python Driver [beta]

2013-08-16 Thread Tyler Hobbs
On Fri, Aug 16, 2013 at 3:35 AM, Sergey Leschenko wrote: > Is there some list of planned drivers for other programming languages? I don't know if we have a list somewhere, but we're currently working on a C/C++ driver and we'd like to make sure that good Ruby, node.js, and (probably) PHP drivers

Re: Cassandra HANGS after some writes

2013-08-16 Thread Naresh Yadav
just to update everyone, as per expert advices i tried running this on Linux machine but i still have exact same problem on linux also...even no difference in performance...I tried with default yaml and heap size of 8GB..Now advise me on cassandra linux optmizations, will try those... Naresh On W

Re: DataStax Native Protocol Python Driver [beta]

2013-08-16 Thread Sergey Leschenko
On Tue, Aug 6, 2013 at 1:41 AM, Tyler Hobbs wrote: > For those of you using pycassa or the cassandra dbapi2 driver, I wanted to > let you know that a beta version of the DataStax python driver is available > on GitHub here: https://github.com/datastax/python-driver > ​Thanks! Is there some list