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 15:16:28 GMT
Ok, I just the read the query again.

Try the failing query like this:

SELECT people_person_id, sum(amount) as total FROM donation GROUP BY
people_person_id

That is the correct syntax for the SQL group by aggregation.

It looks like you found a null pointer though where a proper error message
is needed.


Joel Bernstein
http://joelsolr.blogspot.com/

On Mon, Oct 16, 2017 at 9:49 AM, Joel Bernstein <joelsolr@gmail.com> wrote:

> Also what version are you using?
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Mon, Oct 16, 2017 at 9:49 AM, Joel Bernstein <joelsolr@gmail.com>
> wrote:
>
>> 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