Hey, Thanks for the reply. I had gone through the link but unable to understand how can i use facets in the following query
Select duration from tableName where solr_query='{"q":"(appName:\"test\")"}' I want the query something like Select SUM(duration) from tableName where solr_query='{"q":"(appName:\" test\")"}' Can you help on this. On Mon, Jan 28, 2019 at 5:55 PM Scott Stults < sstu...@opensourceconnections.com> wrote: > Yes. Have a look at the Facet API: > https://lucene.apache.org/solr/guide/7_5/json-facet-api.html > > > On Mon, Jan 28, 2019 at 6:07 AM naga pradeep dhulipalla < > naga.prade...@gmail.com> wrote: > > > Hi Team, > > > > > > > > Can we use SUM aggregate function in our SOLR queries. If not is there an > > alternative to achieve this. > > > > My sample query looks like this as mentioned below. > > > > > > > > Select duration from tableName where > > solr_query='{"q":"(appName:\"test\")"}' > > > > > > > > I need the aggregate SUM value of duration column. Thanks for your quick > > help. > > > > > > > > Regards > > > > Pradeep > > > > +917204007740 > > > > > -- > Scott Stults | Founder & Solutions Architect | OpenSource Connections, LLC > | 434.409.2780 > http://www.opensourceconnections.com >