Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of liushaohui@xiaomi.com
 designates 58.68.235.87 as permitted sender)
Message-ID: <5200C86A.8080908@xiaomi.com>
Date: Tue, 6 Aug 2013 17:56:58 +0800
From: liushaohui <liushaohui@xiaomi.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130623 Thunderbird/17.0.7
MIME-Version: 1.0
To: <dev@hbase.apache.org>
Subject: Re: how to clean all data in hbase table without truncate
References: <51FF8C63.6010609@xiaomi.com>
 <CAPQV63UazwmN6QiA2ncKExcQENUgfXugBzUh4w_C9vsfHMPJxA@mail.gmail.com>
In-Reply-To: 
 <CAPQV63UazwmN6QiA2ncKExcQENUgfXugBzUh4w_C9vsfHMPJxA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"; format=flowed
Content-Transfer-Encoding: 7bit

Thanks, Jean-Marc.

There is  truncate_preserve in HBASE-5525. But it drops the acls info.

I will try to impl truncate_preserver_acl by add a new api in hmaster.

HBASE-8332 discussed this problem, too. But no implement.


On 08/05/2013 08:03 PM, Jean-Marc Spaggiari wrote:
> truncate_preserve (from shell) will still do the disable, but it will not
> drop the regions split. Can you try and see if it keep he ACLs too? If not,
> might be a good idea to do something like "truncate_preserve_acl" too...
>
> JM
>
> 2013/8/5 liushaohui <liushaohui@xiaomi.com>
>
>> hi all:
>>
>>      In our shared secure hbase cluster,  users often wants to clean all
>> tested data in their tables.  Currently, hbase supports the
>>
>> truncate method , but its impl is based on disable table-> delete table ->
>> create table.
>>
>> There are two drawbacks in this impl.
>>
>> 1, Region split info. Truncate creates a new table with just a region. It
>> loses the region split info, which is not suitable for pre-split tables.
>>
>> 2, Table ACLs.  In the deletion of table, the tables' acls will be deleted
>> too. So every truncate need to be operated by hbase admin.
>>
>>
>> Is there any other effective method to clean all data of a table?
>>
>> What about implement a real truncate method in hmaster which keeps region
>> split info and table acls?
>>
>> Thanks
>>
>>
>> - liushaohui
>>
>>
>>
>>
>>