lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Gerasimov <dgerasi...@kommunion.com>
Subject Parallel SQL: GROUP BY throws exception
Date Mon, 16 Oct 2017 13:20:03 GMT
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!

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message