Sort by field from another collection

Hi! I have one main collection of people and a few more collections with additional data. All search queries are on the main collection with joins to one or more additional collections. A simple example would be: (*:* {!join from=people_person_id to=people_person_id fromIndex=fundraising_donor_in

Sort by field from another collection

Hi! I have one main collection of people and a few more collections with additional data. All search queries are on the main collection with joins to one or more additional collections. A simple example would be: (*:* {!join from=people_person_id to=people_person_id fromIndex=fundraising_donor_in

Re: Parallel SQL: GROUP BY throws exception

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

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