Scylla introduces JSON support to SELECT and INSERT statements. But not able to understand how to execute them?

ScyllaDB
1

Hi @denesb,

I am not able to understand how to execute JSON queries. Any example would be helpful along with prerequisite queries.

image
image1191×210 13.6 KB

2

This works:

cqlsh> INSERT INTO ks.tbl_json JSON '{"scores": {"11": 112}, "id": 0}';

Note, that object keys are always string in JSON, even if in this case, the map represented by the JSON object is map<int, int>.