Well to throw fire on the debate, that was actually really simple in Thrift.
On Jun 13, 2014, at 10:50 PM, Kevin Burton <bur...@spinn3r.com> wrote: > I could see just saying screw it and storing a serialized json object that > gets read back in automatically as a map. That wouldn't be too painful but > just not super pretty in terms of representing the data in cassandra. > > > On Fri, Jun 13, 2014 at 8:45 PM, Jack Krupansky <j...@basetechnology.com> > wrote: > The first question is how you need to access this data. Do you need to > directly access “bar” from a SELECT? Do you need to access “foo” as... what – > Java Map, or what? > > That said, you can always flatten a map of maps by simply concatenating the > keys, such as {“foo_bar”: “hello”} and then you can select ‘foo_bar’. Ditto > for additional levels. And if you want each of the intermediate levels, pick > a serialization format such as JSON or BSON in addition to the flattened leaf > values. Anything in your use case(s) that doesn’t cover? > > -- Jack Krupansky > > From: Kevin Burton > Sent: Friday, June 13, 2014 8:17 PM > To: user@cassandra.apache.org > Subject: Pattern to store maps of maps... > > So the cassandra map support in CQL is nice but it's got me wanting deeper > nesting. > > For example { "foo": { "bar": "hello" } } > > … but that's not possible with CQL. > > Of course… one solution is something like avro, and then store your entire > record as a blob. > > I guess that's not TOO bad but that means all my data is somewhat opaque to > cqlsh. > > What are my options here? What are you guys doing to work around this > problem? > > -- > > Founder/CEO Spinn3r.com > Location: San Francisco, CA > Skype: burtonator > blog: http://burtonator.wordpress.com > … or check out my Google+ profile > > War is peace. Freedom is slavery. Ignorance is strength. Corporations are > people. > > > > -- > > Founder/CEO Spinn3r.com > Location: San Francisco, CA > Skype: burtonator > blog: http://burtonator.wordpress.com > … or check out my Google+ profile > > War is peace. Freedom is slavery. Ignorance is strength. Corporations are > people. >