After running an ALTER TABLE DROP <column_name>, I am unable to re-add the same column_name at a later date.
Are column_names not reusable ever?
Can you please confirm the process/conditions required to re-use a column name with or without a TYPE change as well.
I have run nodetool upgradesstables <ks> as well as nodetool compact <ks> <tbl> which is supposed to remove the tombstone information which I was under the impression is holding up the re-usability or do I need to force gc_grace_seconds before the compaction.
Full error message from CQL is
InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot re-add previously dropped column ...