lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joel Bernstein <joels...@gmail.com>
Subject Re: Streaming timeseries() and buckets with no docs
Date Tue, 04 Sep 2018 14:32:54 GMT
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.asf@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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message