I have tested this with latest released ver 7.4.0 -- Jan Høydahl, search solution architect Cominvent AS - www.cominvent.com
> 4. sep. 2018 kl. 16:32 skrev Joel Bernstein <joels...@gmail.com>: > > Which version are you using? > > I remember addressing this issue, but it may have been in Alfresco's > version of Solr and never got ported back. > > I do agree that in a time series a null value is not what people want. It > is a very small change to populate with zeros if it has not already been > done in the latest versions. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > > On Mon, Sep 3, 2018 at 8:58 AM Jan Høydahl <jan....@cominvent.com> wrote: > >> Hi >> >> We have a timeseries expression with gap="+1DAY" and a sum(imps_l) to >> aggregate sums of an integer for each bucket. >> Now, some day buckets do not contain any documents at all, and instead of >> returning a tuple with value 0, it returns >> a tuple with no entry at all for the sum, see the bucket for date_dt >> 2018-06-22 below: >> >> { >> "result-set": { >> "docs": [ >> { >> "sum(imps_l)": 0, >> "date_dt": "2018-06-21", >> "count(*)": 5 >> }, >> { >> "date_dt": "2018-06-22", >> "count(*)": 0 >> }, >> { >> "EOF": true, >> "RESPONSE_TIME": 3 >> } >> ] >> } >> } >> >> >> Now when we want to convert this into a column using col(a,'sum(imps_l)') >> then that array will get mostly numbers >> but also some string entries 'sum(imps_l)' which is the key name. I need >> purely integers in the column. >> >> Should the timeseries() have output values for all functions even if there >> are no documents in the bucket? >> Or is there something similar to the select() expression that can take a >> stream of tuples not originating directly >> from search() and replace values? Or is there perhaps a function that can >> loop through the column produced by col() >> and replace non-numeric values with 0? >> >> -- >> Jan Høydahl, search solution architect >> Cominvent AS - www.cominvent.com >> >>
