RE: Supported Cassandra version for CentOS 5.5

2014-02-26 Thread Arindam Barua
I am running Cassandra 1.2.12 on CentOS 5.10. Was running 1.1.15 previously without any issues as well. -Arindam From: Donald Smith [mailto:donald.sm...@audiencescience.com] Sent: Tuesday, February 25, 2014 3:40 PM To: user@cassandra.apache.org Subject: RE: Supported Cassandra version for

RE: Bootstrap stuck: vnode enabled 1.2.12

2014-02-26 Thread Arindam Barua
As an update - finally got the node to join the ring. Restarting all the nodes in the cluster, followed by a clean bootstrap of the node that was stuck did the trick. -Arindam From: Arindam Barua [mailto:aba...@247-inc.com] Sent: Monday, February 24, 2014 5:04 PM To: user@cassandra.apache.org

FW: Sporadic gossip exception on add node

2014-02-26 Thread Desimpel, Ignace
Did not help finally. So I enabled logging at debug level. The log files tell me that the node being added is communicating with the other nodes (that are seed nodes). Still nothing seems to be returning to that node. The log files on the other nodes are detecting the shadow request, but no

Cassandra nodetool status result after restoring snapshot

2014-02-26 Thread Ranking Lekarzy
Hi I have two separated clusters consist of 4 nodes. One cluster is running on 1.2.12 and the other one on 2.0.5. I loaded data from first cluster (1.2.12) to the second one (2.0.5) by copying snapshots between corresponding nodes. I removed commitlogs, started second cluster and run nodetool

Re: CQL decimal encoding

2014-02-26 Thread Peter Lin
You may need to bit shift if that is the case Sent from my iPhone On Feb 26, 2014, at 2:53 AM, Ben Hood 0x6e6...@gmail.com wrote: Hey Colin, On Tue, Feb 25, 2014 at 10:26 PM, Colin Blower cblo...@barracuda.com wrote: It looks like you are trying to implement the Decimal type. You might

Re: CQL decimal encoding

2014-02-26 Thread Laing, Michael
go uses 'zig-zag' encoding, perhaps that is the difference? On Wed, Feb 26, 2014 at 6:52 AM, Peter Lin wool...@gmail.com wrote: You may need to bit shift if that is the case Sent from my iPhone On Feb 26, 2014, at 2:53 AM, Ben Hood 0x6e6...@gmail.com wrote: Hey Colin, On Tue, Feb

Re: Getting the most-recent version from time-series data

2014-02-26 Thread Tupshin Harper
And one last clarification. Where I said stored procedure earlier, I meant prepared statement. Sorry for the confusion. Too much typing while tired. -Tupshin On Tue, Feb 25, 2014 at 10:36 PM, Tupshin Harper tups...@tupshin.comwrote: I failed to address the matter of not knowing the families

Cassandra Java Client

2014-02-26 Thread Timmy Turner
Hi, is the DataStax Java Driver for Apache Cassandra ( https://github.com/datastax/java-driver) the official/recommended Java Client to use for accessing Cassandra from Java? Does Cassandra itself (i.e. the apache-cassandra-* jars) not contain any CQL clients? Thanks!

Re: Cassandra Java Client

2014-02-26 Thread DuyHai Doan
Short answer : yes Long anwser: depending on whether you want to access Cassandra using Thrift of the native CQL3 protocole, different options are available. For Thrift access, lots of choices (Hector, Astyanax...). For CQL3 right now the only Java client so far is the one provided by Datastax

Re: Naive question about orphan rows

2014-02-26 Thread Edward Capriolo
It is probably ok to have redundant songs in playlists, cassandra is about denormalization. Dealing with this issue is going to be hard since the only way to dwal with this would be scanning through the firsr cf and procing counts then using that information to delete in the second table. However

Re: Cassandra nodetool status result after restoring snapshot

2014-02-26 Thread Jonathan Lacefield
Hello, That's a large variation between the old and new cluster. Are you sure you pulled over all the SSTables for your keyspaces? Also, did you run a repair after the data move? Do you have a lot of tombstone data in the old cluster that was removed during the migration process? Are you

Re: Cassandra Java Client

2014-02-26 Thread Vivek Mishra
Kundera does support CQL3. Work for supporting datastax java driver is under development. https://github.com/impetus-opensource/Kundera/issues/385 -Vivek On Wed, Feb 26, 2014 at 6:34 PM, DuyHai Doan doanduy...@gmail.com wrote: Short answer : yes Long anwser: depending on whether you want

Flushing after dropping a column family

2014-02-26 Thread Ben Hood
Hi, I'm trying to truncate data on a single node 2.0.5 instance and I'm noticing that using either TRUNCATE or DROP/CREATE in cqlsh appear to leave the underlying data behind. So I was wondering what nodetool operation I should use to completely nuke the old data, short of dropping the entire

Re: Flushing after dropping a column family

2014-02-26 Thread DuyHai Doan
I'm noticing that using either TRUNCATE or DROP/CREATE in cqlsh appear to leave the underlying data behind. -- What do you mean by underlying data ? Are you talking about snapshots ? If yes, you can wipe them using nodetool clearsnapshots command On Wed, Feb 26, 2014 at 4:14 PM, Ben Hood

RE: Naive question about orphan rows

2014-02-26 Thread Green, John M (HP Education)
Edward, Thanks for your insight. One other thought I had was to store a reference count with the song. When the last playlist referencing the song is deleted the song will also be deleted because the reference count decrements to zero. However, this would create some nastiness when it

Re: Flushing after dropping a column family

2014-02-26 Thread Ben Hood
On Wed, Feb 26, 2014 at 3:17 PM, DuyHai Doan doanduy...@gmail.com wrote: I'm noticing that using either TRUNCATE or DROP/CREATE in cqlsh appear to leave the underlying data behind. -- What do you mean by underlying data ? Are you talking about snapshots ? I was referring to all of the state

Re: Flushing after dropping a column family

2014-02-26 Thread DuyHai Doan
Try truncate foo instead of drop table foo. About the nodetool clearsnapshot, I've experienced the same behavior also before. Snapshots cleaning is not immediate On Wed, Feb 26, 2014 at 4:53 PM, Ben Hood 0x6e6...@gmail.com wrote: On Wed, Feb 26, 2014 at 3:17 PM, DuyHai Doan

Re: Flushing after dropping a column family

2014-02-26 Thread Tupshin Harper
This is a known issue that is fixed in 2.1beta1. https://issues.apache.org/jira/browse/CASSANDRA-5202 Until 2.1, we do not recommend relying on the recycling of tables through drop/create or truncate. However, on a single node cluster, I suspect that truncate will work far more reliably than

Re: Flushing after dropping a column family

2014-02-26 Thread DuyHai Doan
I've played with it using a 2 nodes cluster with auto_snapshot = false in cassandra.yaml and by deactivating durable write (no commitlog). In my case, truncating tables allows cleaning up data. With nodetool status, I can see the data payload decreasing from Gb to some kbytes On Wed, Feb 26,

Re: Naive question about orphan rows

2014-02-26 Thread Edward Capriolo
Right the problem with building a list of counts in a batch is what happens if song added as you are building the counts. On Wed, Feb 26, 2014 at 10:32 AM, Green, John M (HP Education) john.gr...@hp.com wrote: Edward, Thanks for your insight. One other thought I had was to store a

Re: Flushing after dropping a column family

2014-02-26 Thread Ben Hood
On Wed, Feb 26, 2014 at 3:58 PM, DuyHai Doan doanduy...@gmail.com wrote: Try truncate foo instead of drop table foo. About the nodetool clearsnapshot, I've experienced the same behavior also before. Snapshots cleaning is not immediate I get the same behavior with truncate as well.

Re: Flushing after dropping a column family

2014-02-26 Thread Ben Hood
On Wed, Feb 26, 2014 at 3:59 PM, Tupshin Harper tups...@tupshin.com wrote: This is a known issue that is fixed in 2.1beta1. https://issues.apache.org/jira/browse/CASSANDRA-5202 Until 2.1, we do not recommend relying on the recycling of tables through drop/create or truncate. However, on a

RE: Supported Cassandra version for CentOS 5.5

2014-02-26 Thread Donald Smith
Oh, I should add that I was trying to use Cassandra 2.0.X on CentOS and it needed CentOS 6.2+. Don From: Arindam Barua [mailto:aba...@247-inc.com] Sent: Wednesday, February 26, 2014 1:52 AM To: user@cassandra.apache.org Subject: RE: Supported Cassandra version for CentOS 5.5 I am running

Re: Supported Cassandra version for CentOS 5.5

2014-02-26 Thread Tim Dunphy
I am running Cassandra 2.0.5 on CentOS 5.9 without issue. Getting CassandraPDO to work with with PHP... well that's another matter entirely. I haven't had any luck there at all. I may have to move to Centos 6.x for that reason alone! Tim On Wed, Feb 26, 2014 at 11:55 AM, Donald Smith

Re: Flushing after dropping a column family

2014-02-26 Thread Robert Wille
I use truncate between my test cases. Never had a problem with one test case inheriting the data from the previous one. I¹m using a single node, so that may be why. On 2/26/14, 9:27 AM, Ben Hood 0x6e6...@gmail.com wrote: On Wed, Feb 26, 2014 at 3:58 PM, DuyHai Doan doanduy...@gmail.com wrote:

Commit logs building up

2014-02-26 Thread Christopher Wirt
We're running 2.0.5, recently upgraded from 1.2.14. Sometimes we are seeing CommitLogs starting to build up. Is this a potential bug? Or a symptom of something else we can easily address? We have commitlog_sync: periodic commitlog_sync_period_in_ms:1

Re: Naive question about orphan rows

2014-02-26 Thread Edward Capriolo
One way to handle this is that both tables should be de-normalized. Take this: SongsAndPlaylists PlaylistsAndSongs In this way your client software is charged with keeping data in sync. When you remove a song from a PlaylistsAndSongs you do a read for that song in SongsAnyPlaylists. If the

Re: Update multiple rows in a CQL lightweight transaction

2014-02-26 Thread Clint Kelly
Thanks for your help everyone. Sylvain, as I understand it, the scenario I described above is not resolved by CASSANDRA-6561, correct? (This scenario may not matter to most folks, which is totally fine, I just want to make sure that I understand.) Should I instead look into using the Thrift API

Combine multiple SELECT statements into one RPC?

2014-02-26 Thread Clint Kelly
Hi all, Is there any way to use the DataStax Java driver to combine multiple SELECT statements into a single RPC? I assume not (I could not find anything about this in the documentation), but I just wanted to check. Thanks! Best regards, Clint

Re: CQL decimal encoding

2014-02-26 Thread Ben Hood
On Wed, Feb 26, 2014 at 12:10 PM, Laing, Michael michael.la...@nytimes.com wrote: go uses 'zig-zag' encoding, perhaps that is the difference? On Wed, Feb 26, 2014 at 6:52 AM, Peter Lin wool...@gmail.com wrote: You may need to bit shift if that is the case Thanks for everybody's help, I've

Re: CQL decimal encoding

2014-02-26 Thread Ben Hood
On Thu, Feb 27, 2014 at 12:01 AM, Ben Hood 0x6e6...@gmail.com wrote: Hopefully the gocql team can code review this soon and if that's good to go, we'll have another CQL driver that can deal with decimals. BTW thanks and kudos go to Theo and Tyler (of the cql-rb and the datastax python drivers

Re: CQL decimal encoding

2014-02-26 Thread Ben Hood
On Thu, Feb 27, 2014 at 12:05 AM, Ben Hood 0x6e6...@gmail.com wrote: BTW thanks and kudos go to Theo and Tyler (of the cql-rb and the datastax python drivers respectively) for publishing encoding test cases for the decimal type - that was quite helpful :-) Sorry, I forgot to mention the

Background flushing appears to peg CPU

2014-02-26 Thread Ben Hood
Hi, Using Cassandra 2.0.5 we seem to be running into an issue with a continuous flush of a column family that has no current data ingress. After disconnecting all clients from the node, the Cassandra instance seems to continuously flushing a specific column family with this line appearing all