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 2689317A70 for ; Wed, 11 Feb 2015 17:40:02 +0000 (UTC) Received: (qmail 63456 invoked by uid 500); 11 Feb 2015 17:39:59 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 63388 invoked by uid 500); 11 Feb 2015 17:39:59 -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 Delivered-To: moderator for user@hbase.apache.org Received: (qmail 21685 invoked by uid 99); 11 Feb 2015 16:49:52 -0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=SPF_SOFTFAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of shobhitpal48amity@gmail.com does not designate 162.253.133.43 as permitted sender) Date: Wed, 11 Feb 2015 09:48:24 -0700 (MST) From: "shobhitpal48amity@gmail.com" To: user@hbase.apache.org Message-ID: <1423673304335-4068224.post@n3.nabble.com> Subject: Delete multiple records column family for particular rowkey of hbase table MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi All, I have started learning Hbase, and came across a situation, where i have to delete all records of column family. Is there is any way in Hbase shell to delete records from column family for a particular rowkey? I have tried delete and deleteall commands of hbase shell as follows, deleteall : By using deleteall, i am able to delete entire row ,including all column families for that row. So it doesn't serve my purpose hbase(main) > deleteall 'name_of_table','row-key' This will delete the entire "row-key" with all its column family. delete : With delete I am able to delete records one by one as I am passing them as parameter in delete query. hbase(main) > delete 'name_of_table','row-key','testcf:record-from-column-family' This will delete the "record-from-column-family" record of testcf column family . This one serves my purpose of deleting records from column family but only if the records count is very small, provided i have to pass that record in query. If I have 10000 records in "testcf", to be deleted then, i can't execute the delete query 10000 times , with different records as query parameter. Is there is any way to achieve this, either by using wildcard of something similar to that in delete query,so that it will delete all 10000 records in one shot. Thanks for your valuable suggestions. Regards, Shobhit Pal -- View this message in context: http://apache-hbase.679495.n3.nabble.com/Delete-multiple-records-column-family-for-particular-rowkey-of-hbase-table-tp4068224.html Sent from the HBase User mailing list archive at Nabble.com.