kbr-scylla
commented
2 months ago cc @kostja @avikivity @bhalevy
from the meeting it seems there are multiple ways to approach this: implementing new type of column on storage level, or somehow reuse existing storage capabilities and add special handling to query layer level / repair etc. (based on the column name?), or some mix of both.
It is useful to have a place to store metadata per partition. One such example is paxos state for LWT operations. Having a static column in a partition that is not accessible from regular CQL queries (at least with a standard syntax), but can only be manipulated by internal APIs can be used to store such metadata.
Since the metadata is local per node repair should skip it. CDC should ignore it as well. It should be omitted from describe output and table metadata available to the drivers (since it is hidden).