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! >
