Hello If i have a colum of type Map, then with many insertions, the map grows, but after compation, as the full map is 1 column of a table, will it be contained fully in 1 SSTable? I guess yes cause the map is contained in a single row. Am I right? Versus if we use a clustering key + a standard column instead of a map, insertions will create many rows, 1 per clustering key value, so even after compaction the partition could be splitted in several SSTables. Can you tell me if i understood correctly please? Because if it is right then it means the pb of big partitions can be enhanced using Map as it will induce much more CPU and disk resources to perform compaction (on the other hand you will have lower read amplification factor with map).
Thanks, Sébastien
