You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Parkirat <pa...@gmail.com> on 2014/04/07 14:47:42 UTC

Bulk Delete not deleting the data in storefile

Hi,

I have deleted around 5 Million Row's using the Bulk Delete Coprocessor from
a HBase Table consisting of 10 region's spread over 2 machines.

Now when, I count the row's in the table, it is showing lesser row's(few
thousand) and I am not able to get the row's as well which were deleted.
This part is working fine.

But, when I check the file sizes of all the regions, from HDFS, there seems
to be no impact in file size.
Even the regions, where all the rows were deleted, showing the sizes of 200
to 500 MB's. 

I know that, deleting the row, dont delete the regions, but the region size
should have been reduced.

Even the Major Compaction has not reduced the size of the file.

How can, I reduce the size of the table?

Regards,
Parkirat Singh Bagga.



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Bulk-Delete-not-deleting-the-data-in-storefile-tp4057937.html
Sent from the HBase User mailing list archive at Nabble.com.

Re: Bulk Delete not deleting the data in storefile

Posted by Parkirat <pa...@gmail.com>.
Hi,

Got the solution to the problem.

I was not doing flush, before doing the major_compact.

After doing flush before major_compact, the size of the store file got
reduced.

Regards,
Parkirat Singh Bagga



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Bulk-Delete-not-deleting-the-data-in-storefile-tp4057937p4057944.html
Sent from the HBase User mailing list archive at Nabble.com.

Re: Bulk Delete not deleting the data in storefile

Posted by Parkirat <pa...@gmail.com>.
Hi,

Is the above behaviour due to the below JIRA raised:

https://issues.apache.org/jira/browse/HBASE-4721

If it is, then could anybody answer, when will the table's *storefile* get
cleaned up as I have not configured any TTL for the Column Family or Column
Cells.

Will it be automatically cleaned up in Major Compaction or I need to
manually run it?

Regards,
Parkirat Singh Bagga.



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Bulk-Delete-not-deleting-the-data-in-storefile-tp4057937p4057943.html
Sent from the HBase User mailing list archive at Nabble.com.