Joel, Thanks for the tip. That worked. I was confused since this query works just fine in MySQL. It would of course be very helpful if SOLR was responding with a proper error. What’s the process here? Where do I post this request?
Dmitry > ---------- Forwarded message ---------- > From: Joel Bernstein <joels...@gmail.com> > To: solr-user@lucene.apache.org > Cc: > Bcc: > Date: Mon, 16 Oct 2017 11:16:28 -0400 > Subject: Re: Parallel SQL: GROUP BY throws exception > 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 <joels...@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 <joels...@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 < > >> dgerasi...@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! > >>> > >> > >> > > >
