I understand that Scylla has support for storing JSON data and getting data in JSON form but from what I can see this is only schemafull. Every field in the JSON object will map to a column. Is it possible to store schemaless JSON in a single columns? for e.g store {a:“B”} in column3
It is, but then you will not be able to update a subset of the stored JSON document.
how is it possible? I only need to insert said data
Just create a text or blob column in your schema and dump the JSON in it. You will have to serialize/unserialize on the client side.
That’s what I’ve been doing uptill now. Not exactly the solution I was hoping for. Hope the team adds support for pure schemaless JSON data soon
That’s true. If you store the entire document as JSON, updating a specific subset can become more challenging.