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 D64B810462 for ; Tue, 10 Sep 2013 08:02:12 +0000 (UTC) Received: (qmail 34462 invoked by uid 500); 10 Sep 2013 08:02:09 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 34142 invoked by uid 500); 10 Sep 2013 08:02:09 -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 34134 invoked by uid 99); 10 Sep 2013 08:02:08 -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:02:08 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ramasubramanian.narayanan@gmail.com designates 209.85.212.44 as permitted sender) Received: from [209.85.212.44] (HELO mail-vb0-f44.google.com) (209.85.212.44) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Sep 2013 08:02:01 +0000 Received: by mail-vb0-f44.google.com with SMTP id e13so4825519vbg.31 for ; Tue, 10 Sep 2013 01:01:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=mUyQDT9AeJcfqpa+O7Jq99ZL0AunEVwz+H+og+kF/mY=; b=y0eC35eNmmIyngJ4q4ohEWokJoeWIq0zfC6QCdK0VFG1xTJr1duygsHcj32bkjwqMW qsLAEW0QpLKINadYUciaLF+kK1TrBZs9GmZXOXTPbtTr0uC+y/092Y7hoEwFrHZCFkql PB22XZS2TliJRkJOoVvBDHqcuuQIR6DChiHZLcqrd9GuzGYlTCYXFyAIifllXrEsULB4 kVm9JN/p40PDCnF57hqrw7r4Syw38TECpC8AVPiv2vndeEoj43YvY3q60Z0W61lfHte7 TwnTI8k6qpk26+ZWnwaKdv/5Yw8XUkgEYCna45s0hYQu8Nnng2RxY56YzIvZ2SpE9ClV RZ4w== MIME-Version: 1.0 X-Received: by 10.52.116.74 with SMTP id ju10mr18128864vdb.20.1378800100463; Tue, 10 Sep 2013 01:01:40 -0700 (PDT) Received: by 10.58.56.168 with HTTP; Tue, 10 Sep 2013 01:01:40 -0700 (PDT) Date: Tue, 10 Sep 2013 13:31:40 +0530 Message-ID: Subject: Command to delete based on column Family + rowkey From: Ramasubramanian Narayanan To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=20cf307d01dc345e0604e602eab5 X-Virus-Checked: Checked by ClamAV on apache.org --20cf307d01dc345e0604e602eab5 Content-Type: text/plain; charset=ISO-8859-1 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 --20cf307d01dc345e0604e602eab5--