lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joel Bernstein <joels...@gmail.com>
Subject Re: Parallel SQL: GROUP BY throws exception
Date Mon, 16 Oct 2017 13:49:04 GMT
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 <dgerasimov@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!
>

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