Let's say there is a row that has a column family and a column in it. That column family has a gc policy and all the values in the column were just expired.
Then, what happens to that row? Would that row be deleted by the garbage collector? Or, would that still remain and be accessible?
I've checked documentation but only found some vague comment on that from https://cloud.google.com/bigtable/docs/overview#empty-cells
Empty cells in a Cloud Bigtable table do not take up any space. Each row is essentially a collection of key/value entries, where the key is a combination of the column family, column qualifier and timestamp. If a row does not include a value for a specific key, the key/value entry is simply not present.
In my case, the collection would be empty according to the above text. Then, my question is whether or not the empty collection still exists.
Ideally, I want an empty row to be automatically deleted to prevent the table has too many empty rows. If an empty row is not automatically deleted, is there any way to automate that, except writing a program for scanning and removing such rows?