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 <bur...@spinn3r.com>
> *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
> <https://plus.google.com/102718274791889610666/posts>
> <http://spinn3r.com>
> 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
<https://plus.google.com/102718274791889610666/posts>
<http://spinn3r.com>
War is peace. Freedom is slavery. Ignorance is strength. Corporations are
people.
