Re: Cassandra Data Model and Surrogate Keys

2014-02-25 Thread Daniel Chia
g cql3 with the Datastax java driver > > Thanks > *From: *Daniel Chia > *Sent: *Tuesday, February 25, 2014 2:02 PM > *To: *user@cassandra.apache.org > *Reply To: *user@cassandra.apache.org > *Subject: *Re: Cassandra Data Model and Surrogate Keys > > Hi John, > > Sin

Re: Cassandra Data Model and Surrogate Keys

2014-02-25 Thread Daniel Chia
February 24, 2014 11:53 PM > To: user@cassandra.apache.org > Reply To: user@cassandra.apache.org > Subject: Re: Cassandra Data Model and Surrogate Keys > > 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 >

Re: Cassandra Data Model and Surrogate Keys

2014-02-25 Thread john . stager
example cql. ‎ Thanks‎ Sent from my BlackBerry 10 smartphone on the Rogers network.   Original Message   From: Michael Shuler Sent: Monday, February 24, 2014 11:53 PM To: user@cassandra.apache.org Reply To: user@cassandra.apache.org Subject: Re: Cassandra Data Model and Surrogate Keys On 02/24

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 possib

Re: Cassandra Data Model and Surrogate Keys

2014-02-24 Thread john . stager
BlackBerry 10 smartphone on the Rogers network.   Original Message   From: Michael Shuler Sent: Monday, February 24, 2014 10:17 PM To: user@cassandra.apache.org Reply To: user@cassandra.apache.org Subject: Re: Cassandra Data Model and Surrogate Keys On 02/24/2014 09:00 PM, John Stager wrote: > He

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 p