Hi Everyone, We have a unique situation at my workplace while storing data. We are using Cassandra as a write through cache where we keep real time data in Cassandra for around 10 - 20 days and rest we archive it to another data store as archived data. The current data which we are going to store has around 20 columns, of which 3 would be used in primary key and 2 more would be read by systems which would query while working on Cassandra, rest of the columns are of no use, only use of these columns are when these would be required re-construct the data to be archived in our archive store which would be accessed by our legacy applications. The question here is - Should we store these inconsequential data as blob or JSON in one column or create separate columns for them, which one should be the preferred way here ? We are currently using Cassandra 3.x version.
Thanks, Abhinav
