Also what version are you using? Joel Bernstein http://joelsolr.blogspot.com/
On Mon, Oct 16, 2017 at 9:49 AM, Joel Bernstein <joels...@gmail.com> wrote: > Can you provide the stack trace? > > Are you in SolrCloud mode? > > > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Mon, Oct 16, 2017 at 9:20 AM, Dmitry Gerasimov < > dgerasi...@kommunion.com> wrote: > >> Hi all! >> >> This query works as expected: >> SELECT sum(amount) as total FROM donation >> >> Adding GROUP BY: >> SELECT sum(amount) as total FROM donation GROUP BY people_person_id >> >> Now I get response: >> { >> "result-set":{ >> "docs":[{ >> "EXCEPTION":"Failed to execute sqlQuery 'SELECT sum(amount) as >> total FROM donation GROUP BY people_person_id' against JDBC connection >> 'jdbc:calcitesolr:'.\nError while executing SQL \"SELECT sum(amount) as >> total FROM donation GROUP BY people_person_id\": null", >> "EOF":true, >> "RESPONSE_TIME":279}]} >> } >> >> Any ideas on what is causing this? Or how to debug? >> >> >> Here is the collection structure: >> >> <field name="id" type="string" indexed="true" stored="true" >> required="true" >> multiValued="false"/> >> <field name="people_person_id" type="int" indexed="true" stored="true" >> required="true" multiValued="false" docValues="true"/> >> <field name="group_id" type="int" indexed="true" stored="false" >> required="true" multiValued="false"/> >> <field name=“amount" type="float" indexed="true" stored="true" >> multiValued="false" docValues="true"/> >> >> >> Thanks! >> > >
