unsubscribe

2014-02-24 Thread flroche.ext
unsubscribe _ Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc pas etre diffuses, exploites ou copies sans

Re: Performance problem with large wide row inserts using CQL

2014-02-24 Thread Sylvain Lebresne
On Fri, Feb 21, 2014 at 8:53 PM, Yogi Nerella ynerella...@gmail.com wrote: I am using CCM to install the servers, it is bringing in the source code, is there any option for CCM which I can set only to download the binary, just to make sure it is not bringing in the working copy of the code.

FW: Sporadic gossip exception on add node

2014-02-24 Thread Desimpel, Ignace
Had a look at the code, and this might be a race-condition like problem at the function StorageService::checkForEndpointCollision and StorageService::prepareReplacementInfo To do a Gossiper.instance.doShadowRound(), the MessagingService.instance().listen(FBUtilities.getLocalAddress()) must be

Re: Performance problem with large wide row inserts using CQL

2014-02-24 Thread Sylvain Lebresne
I still have some questions regarding the mapping. Please bear with me if these are stupid questions. I am quite new to Cassandra. The basic cassandra data model for a keyspace is something like this, right? SortedMapbyte[], SortedMapbyte[], PairLong, byte[] ^ row key.

Re: [OT]: Can I have a non-delivering subscription?

2014-02-24 Thread Edward Capriolo
You can setup the mail to deliver one per day as well. On Saturday, February 22, 2014, Robert Wille rwi...@fold3.com wrote: Yeah, it¹s called a rule. Set one up to delete everything from user@cassandra.apache.org. On 2/22/14, 10:32 AM, Paul LeoNerd Evans leon...@leonerd.org.uk wrote: A

Are indexes replicated to all nodes?

2014-02-24 Thread Peter Lin
I was looking at the indexing code in Cassandra server and couldn't determine if the indexes use the same replication factor as the keyspace. When I print out the details of the keyspace, it correctly show the replication factor, which suggests the index for a given partition only lives on the

CQL decimal encoding

2014-02-24 Thread Ben Hood
Hi, I'd like to implement decimal encoding for gocql but I'm wondering what this should be compatible with. Is there some kind of wire format that arbitrary precision numbers should adhere to to ensure interoperability? Cheers, Ben

Re: Performance problem with large wide row inserts using CQL

2014-02-24 Thread Rüdiger Klaehn
On Mon, Feb 24, 2014 at 11:47 AM, Sylvain Lebresne sylv...@datastax.comwrote: I still have some questions regarding the mapping. Please bear with me if these are stupid questions. I am quite new to Cassandra. The basic cassandra data model for a keyspace is something like this, right?

Re: CQL decimal encoding

2014-02-24 Thread Peter Lin
Not sure what you mean by the question. Are you talking about the structure of BigDecimal in java? If that is your question, the java's BigDecimal uses the first 4 bytes for scale and remaining bytes for BigInteger On Mon, Feb 24, 2014 at 10:47 AM, Ben Hood 0x6e6...@gmail.com wrote: Hi,

Handling data consistency

2014-02-24 Thread Kasper Middelboe Petersen
Hi, My requirements include a system that can handle friend based highscore lists (as a user I have a bunch of friends from various social sites like Facebook). The user must have a highscore list that consist of his friends only. I have implemented this using the users ID as partition key and

Re: CQL decimal encoding

2014-02-24 Thread Ben Hood
Hey Peter, On Mon, Feb 24, 2014 at 5:25 PM, Peter Lin wool...@gmail.com wrote: Not sure what you mean by the question. Are you talking about the structure of BigDecimal in java? If that is your question, the java's BigDecimal uses the first 4 bytes for scale and remaining bytes for

Re: CQL decimal encoding

2014-02-24 Thread Peter Lin
ok, I think I understand. I took a look at the code. Java uses big endian encoding. I don't know if GO defaults to big or little. In my port of Hector to C#, I reverse the bytes due to the fact that .Net uses little endian. hope that helps On Mon, Feb 24, 2014 at 12:51 PM, Ben Hood

Re: CQL decimal encoding

2014-02-24 Thread Ben Hood
On Mon, Feb 24, 2014 at 6:09 PM, Peter Lin wool...@gmail.com wrote: I took a look at the code. Java uses big endian encoding. I don't know if GO defaults to big or little. In my port of Hector to C#, I reverse the bytes due to the fact that .Net uses little endian. Cool - I'll take this as a

Re: CQL decimal encoding

2014-02-24 Thread Paul LeoNerd Evans
On Mon, 24 Feb 2014 17:51:54 + Ben Hood 0x6e6...@gmail.com wrote: Or in the absence of a spec, just a heads up from other language driver implementors as to what approach they've taken. I reverse-engineered it by using cqlsh to insert lots of known numerical values, then seeing what the

Re: CQL decimal encoding

2014-02-24 Thread Ben Hood
Hey Paul, On Mon, Feb 24, 2014 at 6:40 PM, Paul LeoNerd Evans leon...@leonerd.org.uk wrote: And the unit tests live here: https://metacpan.org/source/PEVANS/Protocol-CassandraCQL-0.11/t/02types.t#L111 Very cool - I'll port these examples to the gocql marshaling test suite - kudos to you

Re: CQL decimal encoding

2014-02-24 Thread Peter Lin
I did the same thing :) I inserted lots of bigDecimal in Cqlsh and read it from my C# client. Then I did the opposite, inserts BigDecimal from C# and query it from cqlsh. Once both directions worked, I had unit tests to make sure data is cross platform compatible. I know older versions of

Re: CQL decimal encoding

2014-02-24 Thread Paul LeoNerd Evans
On Mon, 24 Feb 2014 13:55:07 -0500 Peter Lin wool...@gmail.com wrote: I did the same thing :) I inserted lots of bigDecimal in Cqlsh and read it from my C# client. Then I did the opposite, inserts BigDecimal from C# and query it from cqlsh. Once both directions worked, I had unit tests to

Cassandra Version History

2014-02-24 Thread Timmy Turner
Hi, is there a history/list showing which major (as in x.y) versions of Cassandra were released on which date? Or is the list on Wikipedia complete? Did 2.0 come after 1.2? Thanks!

Re: CQL decimal encoding

2014-02-24 Thread Ben Hood
On Mon, Feb 24, 2014 at 7:02 PM, Paul LeoNerd Evans leon...@leonerd.org.uk wrote: On Mon, 24 Feb 2014 13:55:07 -0500 Peter Lin wool...@gmail.com wrote: I did the same thing :) I inserted lots of bigDecimal in Cqlsh and read it from my C# client. Then I did the opposite, inserts BigDecimal

CQLException ?

2014-02-24 Thread Andrew Cobley
I’m just converting some code from SQL to CQL. The code can throw a SQLException. however I note that there is no equivalent in CQL, I’m just wondering whys this is the case ? Regards Andy The University of Dundee is a registered Scottish Charity, No: SC015096

Re: Cassandra Version History

2014-02-24 Thread Jonathan Lacefield
Hello, Check out the full version list here: https://issues.apache.org/jira/browse/CASSANDRA?selectedTab=com.atlassian.jira.plugin.system.project:versions-panelsubset=-1 Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield

Re: CQL decimal encoding

2014-02-24 Thread Paul LeoNerd Evans
On Mon, 24 Feb 2014 19:14:48 + Ben Hood 0x6e6...@gmail.com wrote: So I have a question about the encoding of 0: \x00\x00\x00\x00\x00. The first four octets are the decimal shift (0), and the remaining ones (one in this case) encode a varint - 0 in this case. So it's 0 * 10**0 literally

Re: CQL decimal encoding

2014-02-24 Thread Theo Hultberg
I don't know if it's by design or if it's by oversight that the data types aren't part of the binary protocol specification. I had to reverse engineer how to encode and decode all of them for the Ruby driver. There were definitely a few bugs in the first few versions that could have been avoided

How should clients handle the user defined types in 2.1?

2014-02-24 Thread Theo Hultberg
(I posted this on the client-dev list the other day, but that list seems dead so I'm cross posting, sorry if it's the wrong thing to do) Hi, Is there any documentation on how CQL clients should handle the new user defined types coming in 2.1? There's nothing in the protocol specification on how

Re: Update multiple rows in a CQL lightweight transaction

2014-02-24 Thread Clint Kelly
Hi Tupshin, Thanks for your help; I appreciate it. Could I do something like the following? Given the same table you started with: x | y | t | z ---+---+---+ a | 1 | 2 | 10 a | 2 | 2 | 20 I'd like to write a compare-and-set that does something like: If there is a row with (x,y,t,z) =

Re: CQL decimal encoding

2014-02-24 Thread Ben Hood
On Mon, Feb 24, 2014 at 7:43 PM, Paul LeoNerd Evans leon...@leonerd.org.uk wrote: On Mon, 24 Feb 2014 19:14:48 + Ben Hood 0x6e6...@gmail.com wrote: So I have a question about the encoding of 0: \x00\x00\x00\x00\x00. The first four octets are the decimal shift (0), and the remaining ones

Re: CQL decimal encoding

2014-02-24 Thread Ben Hood
On Mon, Feb 24, 2014 at 7:50 PM, Theo Hultberg t...@iconara.net wrote: I don't know if it's by design or if it's by oversight that the data types aren't part of the binary protocol specification. I had to reverse engineer how to encode and decode all of them for the Ruby driver. There were

Re: How should clients handle the user defined types in 2.1?

2014-02-24 Thread Ben Hood
On Mon, Feb 24, 2014 at 7:52 PM, Theo Hultberg t...@iconara.net wrote: (I posted this on the client-dev list the other day, but that list seems dead so I'm cross posting, sorry if it's the wrong thing to do) I didn't even realize there was a list for driver implementors - is this used at all?

Re: Update multiple rows in a CQL lightweight transaction

2014-02-24 Thread Tupshin Harper
Hi Clint, That does appear to be an omission in CQL3. It would be possible to simulate it by doing BEGIN BATCH UPDATE foo SET z = 10 WHERE x = 'a' AND y = 1 IF t= 2 AND z=10; UPDATE foo SET t = 5,z=6 where x = 'a' AND y = 4 APPLY BATCH; However, this does a redundant write to the first

Re: Update multiple rows in a CQL lightweight transaction

2014-02-24 Thread Tupshin Harper
And, FWIW, I was just informed that the ticket that would have the actual functionality you are looking for exists, but is not scheduled for implementation due to lack of agreement about syntax to make it work: https://issues.apache.org/jira/browse/CASSANDRA-5633 -Tupshin On Mon, Feb 24, 2014

Re: abusing cassandra's multi DC abilities

2014-02-24 Thread Jared Biel
Have you heard of this https://github.com/Comcast/cmb? Maybe it's along the path of what you're looking for. On 22 February 2014 22:33, Jonathan Haddad j...@jonhaddad.com wrote: Upfront TLDR: We want to do stuff (reindex documents, bust cache) when changed data from DC1 shows up in DC2.

Cassandra 2.0.5 Configuration

2014-02-24 Thread Timmy Turner
Hi, when building and running Cassandra 2.0.5 from the git repository, the log is full of lines like these 00:01:42.286 [CompactionExecutor:1] DEBUG o.a.c.d.compaction.CompactionManager - Checking system.local When building and running 2.1.0/trunk the log settings are however fine. Is there any

Re: Handling data consistency

2014-02-24 Thread Steven A Robenalt
Hi Kasper, I am assuming that your friend list is symmetric (i.e. If I am your friend then you are also my friend), which your comments seem to indicate. First, I would suggest that you drop the friends score as a part of the clustering key, which eliminates the need to read-before-write. With

RE: Bootstrap stuck: vnode enabled 1.2.12

2014-02-24 Thread Arindam Barua
The host would not join the ring after more clean bootstrap attempts. Noticed nodetool netstats, even though doesn't repair any streaming, does constantly report Nothing streaming from 3 specific hosts in the ring. $ nodetool netstats xss = -ea -d64

Re: Cassandra 2.0.5 Configuration

2014-02-24 Thread Robert Coli
On Mon, Feb 24, 2014 at 4:27 PM, Timmy Turner timm.t...@gmail.com wrote: I already tried setting log4j.rootLogger=ERROR,stdout,R it in conf/log4j-server.properties, but that did not seem to have any effect. Not sure why this isn't working, but you can set log levels via JMX. Use

Cassandra Data Model and Surrogate Keys

2014-02-24 Thread John Stager
Hello, We are working on our data model for Cassandra and we have a need to use surrogate keys (timeuuid) and not the natural key for one of our tables but this causes a possible timing issue when determining if a row already exists.Are there any best practices or patterns for Cassandra for using

Re: Cassandra Data Model and Surrogate Keys

2014-02-24 Thread Michael Shuler
On 02/24/2014 09:00 PM, John Stager wrote: Hello, We are working on our data model for Cassandra and we have a need to use surrogate keys (timeuuid) and not the natural key for one of our tables but this causes a possible timing issue when determining if a row already exists.Are there any best

Re: Cassandra Data Model and Surrogate Keys

2014-02-24 Thread john . stager
Thanks Michael, I will take a look at LWT for the future but unfortunately we are using Cassandra 1.2 ( I should have stated that, sorry). Are there any recommendations for 1.2, or do you just have to deal with him the race condition and possible duplicate data.  Thanks again Sent from my

Re: abusing cassandra's multi DC abilities

2014-02-24 Thread Todd Fast
Hi Jonathan-- First, best wishes for success with your platform. Frankly, I think the architecture you described is only going to cause you major trouble. I'm left wondering why you don't either use something like XMPP (of which several implementations can handle this kind of federated scenario)

Re: Cassandra Data Model and Surrogate Keys

2014-02-24 Thread Michael Shuler
On 02/24/2014 09:24 PM, john.sta...@gmail.com wrote: Thanks Michael, I will take a look at LWT for the future but unfortunately we are using Cassandra 1.2 ( I should have stated that, sorry). Are there any recommendations for 1.2, or do you just have to deal with him the race condition and

Re: abusing cassandra's multi DC abilities

2014-02-24 Thread Jonathan Haddad
Thanks for the input Todd. I've considered a few of the options you've listed. I've ruled out redis because it's not really built for multi DC. I've got nothing against XMPP, or SQS. However, they introduce race conditions as well as all sorts of edge cases (missed messages, for instance).

Re: How should clients handle the user defined types in 2.1?

2014-02-24 Thread Theo Hultberg
There hasn't been any activity (apart from my question) since december, and only sporadic activity before that, so I think it's essentially dead. http://www.mail-archive.com/client-dev@cassandra.apache.org/ T# On Mon, Feb 24, 2014 at 10:34 PM, Ben Hood 0x6e6...@gmail.com wrote: On Mon, Feb

Mixing CAS and TTL.

2014-02-24 Thread J Robert Ray
Hi, I am trying to mix CAS and TTL and am wondering if this behavior that I am seeing is expected. I'm on 2.0.2 and using the java datastax 2.0.0-rc3 client. In my application, a server claims a row by assigning a value to a row using CAS, expecting the column to start out null. The column has a

RE: Mixing CAS and TTL.

2014-02-24 Thread Daniel Shelepov
For the case where you don't get the update, is your whole row removed when TTL expires? If so, you're essentially looking at a non-existing row, and I think it's not too surprising that a if col=null test will behave differently; I personally wouldn't call it a bug. If you're dealing with