lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Høydahl <jan....@cominvent.com>
Subject Re: Streaming timeseries() and buckets with no docs
Date Wed, 05 Sep 2018 14:12:09 GMT
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 <joelsolr@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.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