Hello HBase Community,
We are facing a requirement for bulk deletion in HBase using full row keys. Our table contains a large amount of data, and since we are unsure of the content within the table, we cannot pass the complete row keys directly. Typically, in our scripts, each row is deleted individually, which results in significant processing time. Additionally, we are using TTL (Time-to-Live) for some data in the table. However, due to the size of the tables, it is not feasible for us to have a list of all row keys. While normal deletion through sqline (e.g., using WHERE offerid=value) works, it is impacting query performance and causing delays. Can you suggest any work around is there? Could anyone suggest an alternative approach or best practices for efficiently handling bulk deletions in HBase. Thank you
