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!