You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Sam Hodgson <ho...@hotmail.com> on 2011/10/24 14:23:13 UTC
Updates Question
Hi,
Im currently experimenting with Cassandra on a single node using phpcassa and im having issues when trying to update data in existing columns. I can write new columns/rows etc no problem however when updating I get no errors back and the update does not occur. I've also tried updating manually using the Cassandra cluster admin gui and the same thing happens. I can write but updates do not work, the gui even reports a success but the data remains unchanged.
Any suggestions on where to start looking would be appreciated. Im creating my CF's in the cli with default params (ie not specifying any comparator etc)
Cheers
Sam
Re: Updates Question
Posted by Erik Forkalsrud <ef...@cj.com>.
On 10/24/2011 05:23 AM, Sam Hodgson wrote:
> I can write new columns/rows etc no problem however when updating I
> get no errors back and the update does not occur. I've also tried
> updating manually using the Cassandra cluster admin gui and the same
> thing happens. I can write but updates do not work, the gui even
> reports a success but the data remains unchanged.
A basic thing to check is that the updates have a higher timestamp than
the initial write. I was scratching my head with a similar problem a
while back, and it turned out that cassandra-cli used java's
System.currentTimeMillis() * 1000 for timestamps while the application
code used just System.currentTimeMillis() and those values would always
be lower.
- Erik -
Re: Updates Question
Posted by Tyler Hobbs <ty...@datastax.com>.
It sounds like you're looking at different rows in the CLI compared to
phpcassa and Cassandra Cluster Admin. My guess is that this is due to the
CLI using a hex encoding by default:
http://stackoverflow.com/questions/4662940/cassandra-cli-returning-weird-code
On Mon, Oct 24, 2011 at 7:23 AM, Sam Hodgson <ho...@hotmail.com>wrote:
> Hi,
>
> Im currently experimenting with Cassandra on a single node using phpcassa
> and im having issues when trying to update data in existing columns. I can
> write new columns/rows etc no problem however when updating I get no errors
> back and the update does not occur. I've also tried updating manually using
> the Cassandra cluster admin gui and the same thing happens. I can write but
> updates do not work, the gui even reports a success but the data remains
> unchanged.
>
> Any suggestions on where to start looking would be appreciated. Im
> creating my CF's in the cli with default params (ie not specifying any
> comparator etc)
>
> Cheers
>
> Sam
>
--
Tyler Hobbs
DataStax <http://datastax.com/>