cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From William Oberman <ober...@civicscience.com>
Subject Re: how to remove a "null" column
Date Fri, 24 Jun 2011 13:17:53 GMT
I think you have to do:

assume counters comparator as bytes;
del counters['EU'][0];

will

On Fri, Jun 24, 2011 at 6:51 AM, Sasha Dolgy <sdolgy@gmail.com> wrote:

> I have implemented counters in a limited capacity to record the number
> of 'hits' that are received from a given ISO country code.  CH for
> example, or GB.  Using phpcassa, these counts are incremented ... all
> works great, except, due to a programmatic error, it was possible to
> send a "null" country code across and eventually it ends up in
> Cassandra.  I am unable to remove the null column.
>
> This is being cleaned up on my end in the code... but found I could
> reproduce through the CLI
>
> [default@sdo] incr counters[ascii('EU')][ascii('null')];
> Value incremented.
> [default@sdo] list counters;
> Using default limit of 100
> -------------------
> RowKey: 4555
> => (counter=6e756c6c, value=1)
>
> 1 Row Returned.
> [default@sdo] del counters[ascii('EU')][ascii('null')];
> org.apache.cassandra.db.marshal.MarshalException: cannot parse
> 'FUNCTION_CALL' as hex bytes
> [default@sdo]
>
> How to remove a null column or a column called null...?
>
> --
> Sasha Dolgy
> sasha.dolgy@gmail.com
>



-- 
Will Oberman
Civic Science, Inc.
3030 Penn Avenue., First Floor
Pittsburgh, PA 15201
(M) 412-480-7835
(E) oberman@civicscience.com

Mime
View raw message