Try looking at range JSON facets:
https://lucene.apache.org/solr/guide/8_2/json-facet-api.html#range-facet.
If you facet over the eventTimeStamp with a gap of 1 day, you should
then be able to use a sub facet to return a min and max value
(https://lucene.apache.org/solr/guide/8_2/json-facet-api
I hope you do not plan to use Solr as a primary repository. Solr is NOT a
database. If you use Solr as a database, you will lose data at some point.
The Solr feature set is very different from MySQL. There is no guarantee that a
SQL query can be translated into a Solr query.
wunder
Walter Under
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(eventTimeSt
