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 21B0D633D for ; Sun, 5 Jun 2011 17:12:58 +0000 (UTC) Received: (qmail 26178 invoked by uid 500); 5 Jun 2011 17:12:56 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 26157 invoked by uid 500); 5 Jun 2011 17:12:56 -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 26149 invoked by uid 99); 5 Jun 2011 17:12:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Jun 2011 17:12:56 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of thebachellor@gmail.com designates 209.85.216.172 as permitted sender) Received: from [209.85.216.172] (HELO mail-qy0-f172.google.com) (209.85.216.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Jun 2011 17:12:48 +0000 Received: by qyk29 with SMTP id 29so699218qyk.10 for ; Sun, 05 Jun 2011 10:12:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:from:to:references:in-reply-to:subject:date :message-id:mime-version:content-type:content-transfer-encoding :x-mailer:thread-index:content-language; bh=5nyHmi65dwILt8swa16rB4xiRGl7tVS+kCgxLlhpccA=; b=RMBuyJIh0XmhpS0NuUl+zewZCBxnjLL1mF/T19l8IXvxGX7Vl/yQFBNcD7eTUM+t8Y 7knQGugW1JzwUdTG9uLMkgvnzT8MofSHrC6JsA1s/elGhc3OZkm/i64Q/lYJ9KwMi3jc YA0xrJ5yj5PEsZ9qFwsYcvdxlrekypRakaLFU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:content-transfer-encoding:x-mailer:thread-index :content-language; b=Bq6wWCRjlIOtc9cCFjbyvAX6dRf7stmFZbq784BshzEbkcc9gTRcud4dG4L1teRTuM YXvU1ckxLxqI20/Ufr3pj1Ii1Hmjur9ZWKxhjPd0ZOe6t57+9ud+h0WvzXErFrTDUmWr a9ZMnUJqPD4SpT85iEErv54iGD1laLsD3h7Rs= Received: by 10.229.77.166 with SMTP id g38mr2983334qck.60.1307293947922; Sun, 05 Jun 2011 10:12:27 -0700 (PDT) Received: from KevinPC ([74.72.145.187]) by mx.google.com with ESMTPS id 12sm2329620qcb.46.2011.06.05.10.12.27 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 05 Jun 2011 10:12:27 -0700 (PDT) From: "Kevin" To: References: <001101cc231a$55d906b0$018b1410$@gmail.com> In-Reply-To: Subject: RE: How to delete UUIDs from the CLI? Date: Sun, 5 Jun 2011 13:12:21 -0400 Message-ID: <001e01cc23a3$bc80c9a0$35825ce0$@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQGukK7lmQjBGSJHKrv65BI3i+a5swHaJUz/lNtRISA= Content-Language: en-us X-Virus-Checked: Checked by ClamAV on apache.org Jonathan, I've upgraded to 0.8.0 and the problem got worse. Now, I can't delete any rows from the CLI, regardless of the type they're stored as. -----Original Message----- From: Jonathan Ellis [mailto:jbellis@gmail.com] Sent: Sunday, June 05, 2011 10:56 AM To: user@cassandra.apache.org Subject: Re: How to delete UUIDs from the CLI? 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 > them 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 > "assume as" to list the rows in column families with UUID row keys, > but deleting the displayed row keys does not delete the entries. > > > > I can view columns with UUID values without "assume as" (provided > they're not contained in rows with UUID keys), but I am unable to > delete them from the CLI as well. Is it not possible to do this from > the CLI, or is there something I'm overlooking? -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com