Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 620EA102DF for ; Wed, 11 Sep 2013 20:12:00 +0000 (UTC) Received: (qmail 29584 invoked by uid 500); 11 Sep 2013 20:11:56 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 29363 invoked by uid 500); 11 Sep 2013 20:11:56 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 29354 invoked by uid 99); 11 Sep 2013 20:11:55 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Sep 2013 20:11:55 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of edlinuxguru@gmail.com designates 74.125.82.169 as permitted sender) Received: from [74.125.82.169] (HELO mail-we0-f169.google.com) (74.125.82.169) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Sep 2013 20:11:49 +0000 Received: by mail-we0-f169.google.com with SMTP id t60so8548423wes.28 for ; Wed, 11 Sep 2013 13:11:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=T1NoPQ60gEDl0XKWpGerivc2rX0H+cPXSlWVGHBOiSQ=; b=R0wX7/mImw0WOIoxNvMqNqpJcWMx/MLfZGgaH2IDKKSEjuzKDVileZ2ORiCsBgxUDo FYvdeAH8pCrCpWAXKak1lzmVibzIDKVq+zbF8rn49ZeGNcteT8S2MMTlnMsijpn16Gev 9ZHM/faq/h1bx4FJ2x6ILP7nF5LIzbSuGzEkf7unH5EjigXO5uDkL/FGmyKX+xOdcphO 68wsTaewNsXNqlSBT8bQFc/HYbEhEcU0BaADtbXkgR6p3T6yUY3acqecfHqTQFvjl7ej DaUUnj0C3DQzncTA83zKGEZ9xEEmYdGchkIRvFIHVGTjHFSQK9XERxPPbnTR4q5sFW1K 3zmQ== MIME-Version: 1.0 X-Received: by 10.180.189.132 with SMTP id gi4mr18911204wic.19.1378930289012; Wed, 11 Sep 2013 13:11:29 -0700 (PDT) Received: by 10.194.125.116 with HTTP; Wed, 11 Sep 2013 13:11:28 -0700 (PDT) In-Reply-To: References: Date: Wed, 11 Sep 2013 16:11:28 -0400 Message-ID: Subject: Re: Complex JSON objects From: Edward Capriolo To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=001a11c352940bf5c204e6213ae9 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c352940bf5c204e6213ae9 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable 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.hartzman@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.,**** > > ** ** > > {**** > > =93 readings=94: [**** > > {**** > > =93value=94 : 20,**** > > =93rate_of_change=94 : 0.05,**** > > =93timestamp=94 : 1378686742465**** > > },**** > > {**** > > =93value=94 : 22,**** > > =93rate_of_change=94 : 0.05,**** > > =93timestamp=94 : 1378686742466**** > > },**** > > {**** > > =93value=94 : 21,**** > > =93rate_of_change=94 : 0.05,**** > > =93timestamp=94 : 1378686742467**** > > }**** > > ],**** > > =93events=94 : [**** > > {**** > > =93type=94 : =93direction_change=94,**** > > =93version=94 : 0.1,**** > > =93timestamp=94: 1378686742465**** > > =93data=94 : {**** > > =93units=94 : =93miles=94,**** > > =93direction=94 : =93NW=94,**** > > =93offset=94 : 23**** > > }**** > > },**** > > {**** > > =93type=94 : =93altitude_change=94,**** > > =93version=94 : 0.1,**** > > =93timestamp=94: 1378686742465**** > > =93data=94 : {**** > > =93rate=94: 0.2,**** > > =93duration=94 : 18923**** > > }**** > > }**** > > ]**** > > }**** > > ** ** > > **** > > [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this emai= l > is proprietary to Medtronic and is intended for use only by the individua= l > 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 o= f > a web browser: http://emaildisclaimer.medtronic.com > --001a11c352940bf5c204e6213ae9 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
I was playing a while back with the concept of storin= g JSON into cassandra columns in a sortable way.

Warning: This is kinda just a cool idea, I never productionized it.



On Wed, Sep = 11, 2013 at 2:26 PM, Hartzman, Leslie <leslie.d.hartzman@med= tronic.com> wrote:

Hi,

=A0

What would be the recommended way to deal with a com= plex JSON structure, short of storing the whole JSON as a value to a column= ? What options are there to store dynamic data like this?

=A0

e.g.,

=A0

{

=A0 =93 readings=94: [

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 {

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 =93value=94 : 20,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 =93rate_of_change=94 : 0.05,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 =93timestamp=94 :=A0 1378686742465

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 },<= u>

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 {

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 =93value=94 : 22,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 =93rate_of_change=94 : 0.05,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 =93timestamp=94 :=A0 1378686742466

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 },<= u>

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 {

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 =93value=94 : 21,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 =93rate_of_change=94 : 0.05,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 =93timestamp=94 :=A0 1378686742467

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 }

=A0 ],

=A0 =93events=94 : [

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 {=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 =93type=94 : =93direction_change=94,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 =93version=94 : 0.1,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 =93timestamp=94: 1378686742465

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 =93data=94 : {

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =93units=94 : =93miles=94,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =93direction=94 : =93NW=94,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =93offset=94 : 23

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0}

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 },=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 {=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 =93type=94 : =93altitude_change=94,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 =93version=94 : 0.1,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 =93timestamp=94: 1378686742465

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 =93data=94 : {

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =93rate=94: 0.2,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =93duration=94 : 18923

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0}

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 }

=A0=A0 ]

}

=A0

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =

[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is in= tended for use only by the individual or entity to which it is addressed, a= nd may contain information that is private, privileged, confidential or exe= mpt from disclosure under applicable law. If you are not the intended recip= ient or it appears that this mail has been forwarded to you without proper = authority, you are notified that any use or dissemination of this informati= on in any manner is strictly prohibited. In such cases, please delete this = mail from your records. =20 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 brow= ser: htt= p://emaildisclaimer.medtronic.com


--001a11c352940bf5c204e6213ae9--