Looks like the "del" command in CLI does not properly support function
calls. Can you create a ticket?
In the meantime William's suggestion to use assume should work.
On Fri, Jun 24, 2011 at 5:51 AM, Sasha Dolgy <sdo...@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.do...@gmail.com
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com
