Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=TNT1ADXnlzw5BslXcsmqb+U8APOHUKgSSOTWe8w9hdWu51gHYulJRUxhrm7yN5uosp
         ltVg5irUH3PLp3vcprRksyo6ocVDXdeIm98CFPs+JnpIyFcCkuuprA+AYUGrIYiORwpB
         xqgEbgxeiQZ0eLfdsvEszM0xbfusGaYjPg3dI=
MIME-Version: 1.0
In-Reply-To: <BANLkTi=dx3QoV9eULiG5wmy3gHOy5e4u_w@mail.gmail.com>
References: <BANLkTi=dx3QoV9eULiG5wmy3gHOy5e4u_w@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Fri, 24 Jun 2011 08:29:06 -0500
Message-ID: <BANLkTi=W5ztxCJAHi7JL0k3atUk+4jA6cA@mail.gmail.com>
Subject: Re: how to remove a "null" column
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 <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. =A0CH for
> example, or GB. =A0Using 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. =A0I 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
> =3D> (counter=3D6e756c6c, value=3D1)
>
> 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
>


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com