lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Gerasimov <dgerasi...@kommunion.com>
Subject Re: Parallel SQL: GROUP BY throws exception
Date Tue, 17 Oct 2017 10:48:10 GMT
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 <joelsolr@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 <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
View raw message