lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Risden <kris...@apache.org>
Subject Re: Parallel SQL: GROUP BY throws exception
Date Tue, 17 Oct 2017 14:17:17 GMT
Calcite might support this in 0.14. I know group by support was improved
lately. It might be as simple as upgrading the dependency? A test case
showing the NPE would be helpful. We are using MySQL dialect under the hood
with Calcite.

Kevin Risden

On Tue, Oct 17, 2017 at 8:09 AM, Joel Bernstein <joelsolr@gmail.com> wrote:

> This would be a good jira to create at (
> https://issues.apache.org/jira/projects/SOLR)
>
> Interesting that the query works in MySQL. I'm assuming MySQL automatically
> adds the group by field to the field list. We can look at doing this as
> well.
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Tue, Oct 17, 2017 at 6:48 AM, Dmitry Gerasimov <
> dgerasimov@kommunion.com>
> wrote:
>
> > 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message