Regarding suggestion of best schema for a cassandra table?

Author: Yash Tandon

I want to have a table in Cassandra that has a partition key say column 'A', and a column say 'B' which is of 'set' type and can have up to 10000 elements in the set.

But when i retrieve a row from this table then the whole set is retrieved at once and because of that the JVM heap increases rapidly. So should i stick to this schema or go with other schema where 'A' is partition key and i make dynamic columns for each element in the set in my other schema say 'B1', 'B2' ..... 'B10,000'where each of this column is a clustering key.

Which schema is suited best and will give the optimal performance please recommend.

NOTE: cqlsh 5.0.1v

Originally Sourced from: https://stackoverflow.com/questions/57883604/regarding-suggestion-of-best-schema-for-a-cassandra-table