From user-return-17352-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Sun Jun 5 14:56:46 2011 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3339A6DB6 for ; Sun, 5 Jun 2011 14:56:46 +0000 (UTC) Received: (qmail 6751 invoked by uid 500); 5 Jun 2011 14:56:44 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 6729 invoked by uid 500); 5 Jun 2011 14:56:44 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 6721 invoked by uid 99); 5 Jun 2011 14:56:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Jun 2011 14:56:44 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates 74.125.82.172 as permitted sender) Received: from [74.125.82.172] (HELO mail-wy0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Jun 2011 14:56:39 +0000 Received: by wyb29 with SMTP id 29so2738634wyb.31 for ; Sun, 05 Jun 2011 07:56:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type:content-transfer-encoding; bh=bJ6GKCzFakMBS0sTEdRtQ4bYtEBmCCb/LEgF73zq1R0=; b=hqaNTduX+Ok11wDJoNJGpouiE4eb3jYFLBhDTpaE21vt7cLQymO26xlD+9EjFlAFfN zk783iG/KdUKtPRlWbo5D0SV5COb25sLcTcVfJgCWhj8EvrQkZnwIJM4dzSwkzSbPzaC mkCnfOBFhfnUDFsEElFi7SLDo/uOcpyNALRUE= 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=FbcMfVLSAQ1kg6gkQsrSKH7407glO/mf/e1wO1rvzE1h3GKqwUf2P4falGyW7YT29D ShoY0CchLSBIfLl4Bd9Bs1CspsiysW9vFI5sww7pJjY6HWzGWX4vsSMg7xK8XvzATxzU esXvkWCZsyGt8LLRM3sY9wPfT4drUnO+0OrZI= Received: by 10.216.143.134 with SMTP id l6mr1486144wej.2.1307285778060; Sun, 05 Jun 2011 07:56:18 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.12.129 with HTTP; Sun, 5 Jun 2011 07:55:58 -0700 (PDT) In-Reply-To: <001101cc231a$55d906b0$018b1410$@gmail.com> References: <001101cc231a$55d906b0$018b1410$@gmail.com> From: Jonathan Ellis Date: Sun, 5 Jun 2011 09:55:58 -0500 Message-ID: Subject: Re: How to delete UUIDs from the CLI? To: user@cassandra.apache.org Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable If you're not using 0.8.0 the cli deals poorly with non-string row keys. On Sat, Jun 4, 2011 at 7:48 PM, Kevin wrote: > Currently I'm using a client (Pelops) to insert UUIDs (both lexical and > time) in to Cassandra. I haven't yet implemented a facility to remove the= m > with Pelops; i'm testing and refining the insertion mechanism. > > > > As such, I would like to use the CLI to delete test UUID values. It seems= , > however, that I'm unable to delete UUID rowkeys and columns with the del > command. Is there something I'm missing? I have to use =93assume as=94 to= list > the rows in column families with UUID row keys, but deleting the displaye= d > row keys does not delete the entries. > > > > I can view columns with UUID values without =93assume as=94 (provided the= y're > not contained in rows with UUID keys), but I am unable to delete them fro= m > the CLI as well. Is it not possible to do this from the CLI, or is there > something I'm overlooking? --=20 Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com