lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohamed Azharuddin <az...@eitworks.com>
Subject support need in solr for min and max
Date Wed, 08 Jan 2020 11:07:35 GMT
Hi team,

We are migrating from mysql to apache solr since solr is fast in searching.
Thank you. We had a scenario to


> *find 1) difference (max-min)*

*        2) with group by date(timeStamp)*


Given below is our mysql table :
[image: Untitled.png]

And mysql query is,
*SELECT Date(eventTimeStamp), MAX(field) - MIN(field) AS Energy FROM
PowerTable GROUP BY DATE(eventTimeStamp);*

will results,
[image: Untitled2.png]

So we have to calculate difference per day, where date column is in
datetime format where we are using result grouping as
*group=true&group.query=eventTimeStamp:[2019-12-11T00:00:00Z TO
2019-12-11T23:59:59Z]&group.query=eventTimeStamp:[2019-12-12T00:00:00Z TO
2019-12-12T23:59:59Z]*

Using Apache solr statistics option, we are able to calculate max and min
for whole result, But we need max and min value per day basis.
[image: Untitled31.png]

When we try to get max and min value per day basis, we are able to fetch
either min or max using following query.
*&group.sort=event1 desc or &group.sort=event1 asc*

[image: Untitled6.png]

But we need both min and max in single query.

So kindly help us to go ahead.

-- 

Regards,
Azar@EJ

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