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 <[email protected]>: > > 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
