Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of sdolgy@gmail.com designates
 209.85.220.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type;
        b=xA4Bvz/gVIUMko7b/bxX1VWMZ+C2BrWuN+urY5mB6sQoutyreUWPn0iERYg8mYcQoO
         0U3keO8DCuqUTFUvLqf8t4+lHXRvI1dFxZvuXomFBsw2myAJvElm++9PTBbhSvG/p0Gj
         z1brM/n+dtoUDF1w6vInGoiCGfZEZpj0zgvDE=
MIME-Version: 1.0
From: Sasha Dolgy <sdolgy@gmail.com>
Date: Fri, 24 Jun 2011 12:51:22 +0200
Message-ID: <BANLkTi=dx3QoV9eULiG5wmy3gHOy5e4u_w@mail.gmail.com>
Subject: how to remove a "null" column
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

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