Thanks a lot Jan. Will try with 7.5 I am currently using 7.2.1 version. Is there a way to fix it?
On Fri, Oct 19, 2018 at 12:31 AM Jan Høydahl <jan....@cominvent.com> wrote: > Have you tried with Solr 7.5? I think it may have been fixed in that > version? At least for the timeseries() expression... > > -- > Jan Høydahl, search solution architect > Cominvent AS - www.cominvent.com > > > 18. okt. 2018 kl. 05:35 skrev RAUNAK AGRAWAL <agrawal.rau...@gmail.com>: > > > > Hi, > > > > I am trying to use streaming rollup expression to aggregate the sales > > values over week. Here is the query: > > > > curl http://localhost:8983/solr/metrics_data/stream -d 'expr=rollup( > > search(metrics_data, q=id:123, fl="week_no,sales,qty", qt="/export", > > sort="week_no desc"), > > over="week", > > sum(sales), > > sum(qty) > > )' > > > > But I am getting exception like: > > > > { > > "result-set": { > > "docs": [{ > > "EXCEPTION": null, > > "EOF": true, > > "RESPONSE_TIME": 169 > > }] > > } > > } > > > > The reason being some of the documents are having null as sales. One > option > > is to wrap the search with select expression > > with replace(field,null,withValue=0). Is there any other way for rollup > to > > ignore those docs which has some fields as null? > > > > Thanks in advance > >
