Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-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 C706E10582 for ; Tue, 10 Sep 2013 08:36:58 +0000 (UTC) Received: (qmail 71018 invoked by uid 500); 10 Sep 2013 08:36:52 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 70923 invoked by uid 500); 10 Sep 2013 08:36:51 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 70908 invoked by uid 99); 10 Sep 2013 08:36:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Sep 2013 08:36:51 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of manishd207@gmail.com designates 209.85.214.44 as permitted sender) Received: from [209.85.214.44] (HELO mail-bk0-f44.google.com) (209.85.214.44) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Sep 2013 08:36:43 +0000 Received: by mail-bk0-f44.google.com with SMTP id mz10so2798484bkb.31 for ; Tue, 10 Sep 2013 01:36:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:reply-to:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=WcPJwNVpAVew8vOqpFYwCWSwXAZ43Ax8DTDpX/pGa38=; b=TUQKuE4GHv6rciZvIRLyRFK7dBQgQkvfmGlMBpKmSlaikcuOMI+SohA80fMwqMr54p S69ZF5CGWM2bE6p0X3i+cR7N9Cc4x7RAMIozC2Bdp42fB+yKuNbwmkfGOGoRPVii8P9e IHFQHiPRreF7e4HyGswsqX3tR1H1Gov3KtgAbFemhCf975f+hznqmKze0JIr8ISh4sVy zcGWb6PI0vvfk+FtBV+czfE7DzEeWgzXslYkIo/4tJGsSN+2Xrvu6Jq321f6qNmhhNxG KiJt1vX8y97PyWRD/7og7BwpMYFNdwoOyG0pS/8BFXgVaQ7dpqmR90m17FlTULpkoM7P JJmQ== MIME-Version: 1.0 X-Received: by 10.204.65.9 with SMTP id g9mr669954bki.33.1378802183378; Tue, 10 Sep 2013 01:36:23 -0700 (PDT) Received: by 10.205.67.134 with HTTP; Tue, 10 Sep 2013 01:36:23 -0700 (PDT) Reply-To: dunanimanish@gmail.com In-Reply-To: References: Date: Tue, 10 Sep 2013 14:06:23 +0530 Message-ID: Subject: Re: Command to delete based on column Family + rowkey From: manish dunani To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=001a11c3925a5b60d604e60366e4 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c3925a5b60d604e60366e4 Content-Type: text/plain; charset=ISO-8859-1 If you want to delete rowkey for particular columnfamily then you need to mention individually::>>> >delete 'ttttt','333','TWO:qualifier_name' This will definitely delete the records which you are looking for. Please revert back if it is not work. On Tue, Sep 10, 2013 at 1:40 PM, manish dunani wrote: > hey rama, > > Try this:: > > >*deleteall 'ttttt','333'* > * > * > I hope it will definitely works for you!! > > > > > On Tue, Sep 10, 2013 at 1:31 PM, Ramasubramanian Narayanan < > ramasubramanian.narayanan@gmail.com> wrote: > >> Dear All, >> >> Requirement is to delete all columns which belongs to a column family and >> for a particular rowkey. >> >> Have tried with the below command but record is not getting deleted. >> >> * hbase> deleteall 't1', 'r1', 'c1'* >> * >> * >> *Test result :* >> * >> * >> 3) Scan the table 'ttttt' >> >> hbase(main):025:0> scan 'ttttt' >> ROW COLUMN+CELL >> 111 column=ONE:ename, >> timestamp=1378459582478, value=aaaa >> 111 column=ONE:eno, >> timestamp=1378459582335, value=1000 >> 111 column=ONE:sal, >> timestamp=1378459582515, value=1500 >> 111 column=TWO:ename, >> timestamp=1378459582655, value=dddd >> 111 column=TWO:eno, >> timestamp=1378459582631, value=4000 >> 222 column=ONE:ename, >> timestamp=1378459582702, value=bbbb >> 222 column=ONE:eno, >> timestamp=1378459582683, value=2000 >> 222 column=ONE:sal, >> timestamp=1378459582723, value=2500 >> 222 column=TWO:ename, >> timestamp=1378459582779, value=gggg >> 222 column=TWO:eno, >> timestamp=1378459582754, value=4000 >> 222 column=TWO:sal, >> timestamp=1378459582798, value=7500 >> 333 column=ONE:ename, >> timestamp=1378459582880, value=sss >> 333 column=ONE:eno, >> timestamp=1378459582845, value=9000 >> 333 column=ONE:sal, >> timestamp=1378459582907, value=6500 >> 333 column=TWO:ename, >> timestamp=1378459582950, value=zzz >> 333 column=TWO:eno, >> timestamp=1378459582931, value=6666 >> 333 column=TWO:sal, >> timestamp=1378459582968, value=6500 >> 3 row(s) in 0.0440 seconds >> >> >> ------------------------------------------------------------------------------------------------------------------------------------- >> 4) Delete the records from the table 'ttttt' in the rowkey '333' in the >> column family 'TWO' >> >> >> hbase(main):027:0> deleteall 'ttttt','333','TWO' >> 0 row(s) in 0.0060 seconds >> >> >> ------------------------------------------------------------------------------------------------------------------------------------- >> >> 5) After deleting scan the table >> >> hbase(main):028:0> scan 'ttttt' >> ROW COLUMN+CELL >> 111 column=ONE:ename, >> timestamp=1378459582478, value=aaaa >> 111 column=ONE:eno, >> timestamp=1378459582335, value=1000 >> 111 column=ONE:sal, >> timestamp=1378459582515, value=1500 >> 111 column=TWO:ename, >> timestamp=1378459582655, value=dddd >> 111 column=TWO:eno, >> timestamp=1378459582631, value=4000 >> 222 column=ONE:ename, >> timestamp=1378459582702, value=bbbb >> 222 column=ONE:eno, >> timestamp=1378459582683, value=2000 >> 222 column=ONE:sal, >> timestamp=1378459582723, value=2500 >> 222 column=TWO:ename, >> timestamp=1378459582779, value=gggg >> 222 column=TWO:eno, >> timestamp=1378459582754, value=4000 >> 222 column=TWO:sal, >> timestamp=1378459582798, value=7500 >> 333 column=ONE:ename, >> timestamp=1378459582880, value=sss >> 333 column=ONE:eno, >> timestamp=1378459582845, value=9000 >> 333 column=ONE:sal, >> timestamp=1378459582907, value=6500 >> 333 column=TWO:ename, >> timestamp=1378459582950, value=zzz >> 333 column=TWO:eno, >> timestamp=1378459582931, value=6666 >> 333 column=TWO:sal, >> timestamp=1378459582968, value=6500 >> 3 row(s) in 0.0310 seconds >> >> Observation :- >> ------------------ >> No records got deleted >> >> regards, >> Rams >> > > > > -- > Regards > > *Manish Dunani* > *Contact No* : +91 9408329137 > *skype id* : manish.dunani* > * > > > -- Regards *Manish Dunani* *Contact No* : +91 9408329137 *skype id* : manish.dunani* * --001a11c3925a5b60d604e60366e4--