Re: Aggregations on nested array types

2014-04-03 Thread dazraf
I thought it may be useful to summarise what we're trying to do: Let the document structure be: contest: contestant: // [array] id: string data: // [array] run: integer // note that I've added this to highlight one of our usecases timing: integer // ... othe

Re: Aggregations on nested array types

2014-04-03 Thread dazraf
I thought it may be useful to summarise what we're trying to do: Let the document structure be: contest: contestant: // [array] id: string data: // [array] run: integer // note that I've added this to highlight one of our usecases timing: integer // ... othe

Re: Aggregations on nested array types

2014-04-03 Thread dazraf
Hi Mark, thanks again for helping with this. I'm wondering why, in the solution, the mapping doesn't include the data node in the tree. In fact when I explicitly state the data node as a property of contestant, the aggregations come back blank.Gist: https://gist.github.com/dazraf/9957039 many

Re: Aggregations on nested array types

2014-04-02 Thread dazraf
Thanks very much Mark! I'll study this and respond back on this thread. On Wednesday, 2 April 2014 18:31:29 UTC+1, Mark Harwood wrote: > > A rough Gist here that sums OK with one level of nesting: > https://gist.github.com/markharwood/9938890 > > > > On Wednesday, April 2, 2014 5:13:22 PM UTC+1,

Re: Aggregations on nested array types

2014-04-02 Thread Mark Harwood
A rough Gist here that sums OK with one level of nesting: https://gist.github.com/markharwood/9938890 On Wednesday, April 2, 2014 5:13:22 PM UTC+1, dazraf wrote: > > Hi, > I've also experimented with nested types using dynamic templates. > Interesting (empty!) aggregation results! > Gist: http

Re: Aggregations on nested array types

2014-04-02 Thread dazraf
Hi, I've also experimented with nested types using dynamic templates. Interesting (empty!) aggregation results! Gist: https://gist.github.com/dazraf/9937198 Would be grateful if anyone can shed some light on this please? Thank you. On Wednesday, 2 April 2014 16:05:00 UTC+1, dazraf wrote: > > Hi

Aggregations on nested array types

2014-04-02 Thread dazraf
Hi, Gist: https://gist.github.com/dazraf/9935814 Basically, I'd like to be able to aggregate a field of an array of observations, grouped by an ancestor/parent id. So for example (see gist): Aggregate the timings per contestant across a set of contests. I realise that the data can be structur