I'm working on a project with an existing cassandra database. The schema looks like this:
partition key (big int) | clustering key1 (timestamp) | data (text) |
---|---|---|
1 | 2021-03-10 11:54:00.000 | {a:"somedata", b:2, ...} |
My question is: Is there any advantage storing data in a json string? Will it save some space?
Until now I discovered disadvantages only:
No, there is no real advantage to storing JSON as string in Cassandra unless the underlying data in the JSON is really schema-less. It will also not save space but in fact use more because each item has to have a key+value instead of just storing the value.
If you can, I would recommend mapping the keys to CQL columns so you can store the values natively and accessing the data is more flexible. Cheers!