Inner .Aggregations() with .Sum() can't get "Sum" values

[Dem0n2die4]

Hello. Use nest 1.2.2 with elastic 1.3.2.

Do this request:

var histogram = client.Search( s => s
.Query( q => q.
.Filtered( qf => qf
.Query( qq => qq.MatchAll())
.Filter( f => f.Range( r => r.OnField( rf => rf.Time).Greater(from).Lower(to)))
)
)
.Aggregations( a => a.Histogram("hist", h => h.Field(f => f.Time)
.Interval(3000)
.Aggregations( agg => agg
.Sum("sizes", aggs => aggs.Field(sf => sf.Size))
)
)
);

var result = histogram.Aggs.Histogram("hist");

foreach( var interval in result.Items){
    var sizes = hour.Sum("sizes"); // in this string was an exeption something like "Aggregations in interval = null"
}

"interval" is correct,

If I do this request manualy response looks like:

{
"key": 1417168800,
"doc_count": 28,
"sizes": {
"value": 900
}
},
{
"key": 1417172400,
"doc_count": 21,
"sizes": {
"value": 1228
}
},


Don't understand what is wrong with it. Can You help me?

[Dem0n2die4]

Try to do it with FacetHistogram instead FacetDateHistogram (need custom time interval) but FacetHistogram return only key, can't get value_field count Total. Facets already doesn't supported?

[gmarz]

@Dem0n2die4 I can't quite reproduce this. Either I don't understand the issue entirely, or it may have something to do with your data?

Would you mind taking a look at this test and see if you can get it to fail?

[Dem0n2die4]

ok, thx, I'll try it later)

[Dem0n2die4]

Test works fine.
Don't understand why the same code doesn't work with my data.

[Dem0n2die4]

The only difference in histogram field type. It's Int, not DateTime.

[Dem0n2die4]

Yep, if "StartedOn" replace with "IntValues" then there is an exception

[gmarz]

@Dem0n2die4 thanks for looking at the test.

I was able to confirm the same thing, getting a NullReferenceException when aggregating on IntValues.

This seems to be different issue than the error you were encountering though? What is the data type of your Time field?

[Dem0n2die4]

It's Int. Think that problem just in type. But if I remove geting inner aggregation values(Sum) like this:

 public void InnerSumAggregationTest()
 {
     var response = this.Client.Search<ElasticsearchProject>(s => s
         .Aggregations(a => a
             .Histogram("hist", h => h
             .Field(p => p.IntValues)
             .Interval(3000)
             .Aggregations(aa => aa
                 .Sum("sizes", sa => sa
                 .Field(p => p.LongValue)
                 )
             )
             )
         )
     );

     var hist = response.Aggs.Histogram("hist");
//     foreach (var interval in hist.Items)
//     {
//         var sizes = interval.Sum("sizes");
//     }
 }

it'll work perfect. Don't know whether it's different issue or not. But inner aggregation is null when "main" aggregation field type is Int

[Dem0n2die4]

Maybe I doing something wrong, but bucket in _SetInnerAggregation which fills with selector is always null

[gmarz]

@Dem0n2die4 I was able to get to the bottom of this. The problem was that inner aggregations were totally ignored when converting from KeyItem to HistogramItem in AggregationHelper.Histogram().

Just pushed the fix above; thank you for reporting this. 👍

[Dem0n2die4]

Thx for help)