Re: Windows monitoring software for Solr recommendation

[azharuddin]

Visit here to get more information on  Apache SOLR
  .



--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Apache and Apache Solr together

[azharuddin]

I've got a question: I came across  Apache Solr
   as requirement for a module
I'm installing and even after reading the documentation on Apache Solr's
official homepage I'm still not sure whether Apache runs alongside regular
Apache or does it require it own server? If it does work alongside Apache,
is there any known issues/problems that I should be aware of? How would this
architecture (Apache and Apache Solr) in terms of file system and serving
pages? I'm sorry if the question might sound silly but I'm very new to the
whole server-side programming/setup world.



--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

support need in solr for min and max

[Mohamed Azharuddin]

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