Batchwise deletion of malformed HBase row keys. It will not stop when done so it needs monitoring.

batch_deleter.py

import happybase

connection = happybase.Connection(HBASE_MASTER_IP)
table = connection.table(TABLE_NAME)
while True:
  batch = table.batch()
  for key, _ in table.scan(columns=[COLUMN_NAMES], filter="RowFilter(=, 'regexstring:.*\x09.*')", limit=10000):
    batch.delete(key)
  batch.send()
  print(key)
connection.close()