RE: Complex JSON objects

2013-09-16 Thread Hartzman, Leslie
: Complex JSON objects A way to do this would be to express the JSON structure as (path, value) tuples and then use a map to store them. For example, your JSON above can be expressed as shown below where the path is a list of keys/indices and the value is a scalar. You could also concatenate the

Re: Complex JSON objects

2013-09-11 Thread Laing, Michael
A way to do this would be to express the JSON structure as (path, value) tuples and then use a map to store them. For example, your JSON above can be expressed as shown below where the path is a list of keys/indices and the value is a scalar. You could also concatenate the path elements and use t

Re: Complex JSON objects

2013-09-11 Thread Paulo Motta
What you can do to store a complex json object in a C* skinny row is to serialize each field independently as a Json String and store each field as a C* column within the same row (representing a JSON object). So using the example you mentioned, you could store it in cassandra as: ColumnFamily["o

Re: Complex JSON objects

2013-09-11 Thread Edward Capriolo
I was playing a while back with the concept of storing JSON into cassandra columns in a sortable way. Warning: This is kinda just a cool idea, I never productionized it. https://github.com/edwardcapriolo/Cassandra-AnyType On Wed, Sep 11, 2013 at 2:26 PM, Hartzman, Leslie < leslie.d.hartz...@med

Complex JSON objects

2013-09-11 Thread Hartzman, Leslie
Hi, What would be the recommended way to deal with a complex JSON structure, short of storing the whole JSON as a value to a column? What options are there to store dynamic data like this? e.g., { " readings": [ { "value" : 20, "ra