cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <>
Subject Re: Setting column to null
Date Fri, 08 Jun 2012 23:20:59 GMT
Your best bet is to define the column as a composite column where one part
represents is null and the other part is the data.

On Friday, June 8, 2012, shashwat shriparv <>
> What you can do is you can define some specific variable like "NULLDATA"
some thing like that to update in columns that does have value
> On Fri, Jun 8, 2012 at 11:58 PM, aaron morton <>
> You don't nee to set columns to null, delete the column instead.
> Cheers
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> On 8/06/2012, at 9:34 AM, Leonid Ilyevsky wrote:
> Is it possible to explicitly set a column value to null?
> I see that if insert statement does not include a specific column, that
column comes up as null (assuming we are creating a record with new unique
> But if we want to update a record, how we set it to null?
> Another situation is when I use prepared cql3 statement (in Java) and
send parameters when I execute it. If I want to leave some column
unassigned, I need a special statement without that column.
> What I would like is, prepare one statement including all columns, and
then be able to set some of them to null. I tried to set corresponding
ByteBuffer parameter to null, obviously got an exception.
> ________________________________
> This email, along with any attachments, is confidential and may be
legally privileged or otherwise protected from disclosure. Any unauthorized
dissemination, copying or use of the contents of this email is strictly
prohibited and may be in violation of law. If you are not the intended
recipient, any disclosure, copying, forwarding or distribution of this
email is strictly prohibited and this email and any attachments should be
deleted immediately. This email and any attachments do not constitute an
offer to sell or a solicitation of an offer to purchase any interest in any
investment vehicle sponsored by Moon Capital Management LP (“Moon
Capital”). Moon Capital does not provide legal, accounting or tax advice.
Any statement regarding legal, accounting or tax matters was not intended
or written to be relied upon by any person as advice. Moon Capital does not
waive confidentiality or privilege as a result of this email.
> --
> ∞
> Shashwat Shriparv

View raw message