cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhinav Solan <>
Subject Blob or columns
Date Fri, 03 Jun 2016 15:43:05 GMT
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.


View raw message