Re: Parallel SQL: GROUP BY throws exception

gt; > 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

Re: Parallel SQL: GROUP BY throws exception

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

Re: Parallel SQL: GROUP BY throws exception

: 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: > > SEL

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

Re: Parallel SQL: GROUP BY throws exception

Also what version are you using? Joel Bernstein http://joelsolr.blogspot.com/ On Mon, Oct 16, 2017 at 9:49 AM, Joel Bernstein wrote: > Can you provide the stack trace? > > Are you in SolrCloud mode? > > > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Mon, Oct 16,

Re: Parallel SQL: GROUP BY throws exception

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 wrote: > Hi all! > > This query works as expected: > SELECT sum(amount) as total FROM donation > > Adding

Parallel SQL: GROUP BY throws exception

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