Re: Parallel SQL: GROUP BY throws exception

2017-10-17 Thread Kevin Risden
l Bernstein > > > 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. > > > > >

Re: Parallel SQL: GROUP BY throws exception

2017-10-17 Thread Joel Bernstein
do I post this request? > > Dmitry > > > > > > -- Forwarded message -- > > From: Joel Bernstein > > To: solr-user@lucene.apache.org > > Cc: > > Bcc: > > Date: Mon, 16 Oct 2017 11:16:28 -0400 > > Subject: Re: Parallel SQL: GROUP B

Re: Parallel SQL: GROUP BY throws exception

2017-10-17 Thread Dmitry Gerasimov
: Joel Bernstein > 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(

Re: Parallel SQL: GROUP BY throws exception

2017-10-16 Thread Joel Bernstein
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

2017-10-16 Thread Joel Bernstein
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, 2017 at 9:20 AM, Dmit

Re: Parallel SQL: GROUP BY throws exception

2017-10-16 Thread Joel Bernstein
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 GROUP BY: > SELECT sum(amount)

Parallel SQL: GROUP BY throws exception

2017-10-16 Thread Dmitry Gerasimov
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