Re: DataStax Native Protocol Python Driver [beta]

2013-08-16 Thread Sergey Leschenko
On Tue, Aug 6, 2013 at 1:41 AM, Tyler Hobbs ty...@datastax.com 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

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

Re: DataStax Native Protocol Python Driver [beta]

2013-08-16 Thread Tyler Hobbs
On Fri, Aug 16, 2013 at 3:35 AM, Sergey Leschenko sergle...@gmail.comwrote: 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

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

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

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 sergle...@gmail.com 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

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

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

Re: Configuring ephemeral only column family

2013-08-16 Thread Robert Coli
On Fri, Aug 16, 2013 at 10:43 AM, Todd Nine tn...@apigee.com 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

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 rc...@eventbrite.com wrote: On Fri, Aug 16, 2013 at 10:43 AM, Todd Nine tn...@apigee.com wrote: We're using expiring columns as a mean for locking. Perhaps a log structured data store with immutable data files is

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

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

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

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 CFname;. 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

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 straight

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 schema