cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Narendra Sharma <narendra.sha...@gmail.com>
Subject Re: Deleting a column vs setting it's value to empty
Date Fri, 10 Feb 2012 22:18:40 GMT
IMO deleting is always better. It is better to not store the column if
there is no value associated.

-Naren

On Fri, Feb 10, 2012 at 12:15 PM, Drew Kutcharian <drew@venarc.com> wrote:

> Hi Everyone,
>
> Let's say I have the following object which I would like to save in
> Cassandra:
>
> class User {
>  UUID id; //row key
>  String name; //columnKey: "name", columnValue: the name of the user
>  String description; //columnKey: "description", columnValue: the
> description of the user
> }
>
> Description can be nullable. What's the best approach when a user updates
> her description and sets it to null? Should I delete the description column
> or set it to an empty string?
>
> In addition, if I go with the delete column strategy, since I don't know
> what was the previous value of description (the column could not even
> exist), what would happen when I delete a non existent column?
>
> Thanks,
>
> Drew
>
>


-- 
Narendra Sharma
Software Engineer
*http://www.aeris.com <http://www.persistentsys.com>*
*http://narendrasharma.blogspot.com/*

Mime
View raw message