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...@medtronic.com> wrote: > 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,**** > > “rate_of_change” : 0.05,**** > > “timestamp” : 1378686742465**** > > },**** > > {**** > > “value” : 22,**** > > “rate_of_change” : 0.05,**** > > “timestamp” : 1378686742466**** > > },**** > > {**** > > “value” : 21,**** > > “rate_of_change” : 0.05,**** > > “timestamp” : 1378686742467**** > > }**** > > ],**** > > “events” : [**** > > {**** > > “type” : “direction_change”,**** > > “version” : 0.1,**** > > “timestamp”: 1378686742465**** > > “data” : {**** > > “units” : “miles”,**** > > “direction” : “NW”,**** > > “offset” : 23**** > > }**** > > },**** > > {**** > > “type” : “altitude_change”,**** > > “version” : 0.1,**** > > “timestamp”: 1378686742465**** > > “data” : {**** > > “rate”: 0.2,**** > > “duration” : 18923**** > > }**** > > }**** > > ]**** > > }**** > > ** ** > > **** > > [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email > is proprietary to Medtronic and is intended for use only by the individual > or entity to which it is addressed, and may contain information that is > private, privileged, confidential or exempt from disclosure under > applicable law. If you are not the intended recipient or it appears that > this mail has been forwarded to you without proper authority, you are > notified that any use or dissemination of this information in any manner is > strictly prohibited. In such cases, please delete this mail from your > records. To view this notice in other languages you can either select the > following link or manually copy and paste the link into the address bar of > a web browser: http://emaildisclaimer.medtronic.com >
