Parallel SQL: GROUP BY throws exception

[Dmitry Gerasimov]

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!