Re: Pattern to store maps of maps...

2014-06-14 Thread DuyHai Doan
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

Re: Pattern to store maps of maps...

2014-06-14 Thread Kevin Burton
) 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

Pattern to store maps of maps...

2014-06-13 Thread Kevin Burton
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

Re: Pattern to store maps of maps...

2014-06-13 Thread graham sanderson
My personal opinion is that unless you are doing map operations on a CQL3 map and will always intend to read the whole thing (you don’t have any choice today), don’t use one at all - use a blob of whatever variety makes sense (e.g. Json, AVRO, Protobuf etc) On Jun 13, 2014, at 7:17 PM, Kevin

Re: Pattern to store maps of maps...

2014-06-13 Thread Johan Edstrom
We treat this on an Object level in Java as a new table with separate Hydration. On a Map level we currently utilize an Internal CQL3 map where we replace the non scalar values with separate tables - we just stick the ID in. Same for Sets, Arrays and such. You get more writes but you also have

Re: Pattern to store maps of maps...

2014-06-13 Thread Jack Krupansky
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

Re: Pattern to store maps of maps...

2014-06-13 Thread Kevin Burton
On Fri, Jun 13, 2014 at 7:26 PM, Johan Edstrom seij...@gmail.com wrote: We treat this on an Object level in Java as a new table with separate Hydration. On a Map level we currently utilize an Internal CQL3 map where we replace the non scalar values with separate tables - we just stick the ID

Re: Pattern to store maps of maps...

2014-06-13 Thread Kevin Burton
...@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

Re: Pattern to store maps of maps...

2014-06-13 Thread Johan Edstrom
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