I don't think you can. Problem is that the "pseudo join" capability can work "cross core", which meas with two separate cores, but last I knew distributed joins aren't supported which is what you're asking for.
Really think about flattening your data if at all possible. Best Erick On Thu, May 2, 2013 at 11:03 PM, Benjamin Ryan <benjamin.r...@manchester.ac.uk> wrote: > Hi, > Sorry for the basic question - I can't get to the WiKi to find the answer. > Version Solr 3.3.0 > I have two separate indexes (currently in two cores but can be moved to > shards) > One core holds metadata about educational resources, the other usage > statistics > They have a common value named "id" in one core and "search.resourceid" in > the other core. > How can I construct a shard query (once I have moved one the cores to a > different node) so that I can effectively get the statistics for each > educational resource grouped by each resource? > This is an offline reporting job that needs to list the usage events for > educational resources over a time period (the usage events have a date/time > field. > > Regards, > Ben > > ------------------------------------------------------------------ > Dr Ben Ryan > Jorum Technical Manager > > 5.12 Roscoe Building > The University of Manchester > Oxford Road > Manchester > M13 9PL > Tel: 0160 275 6039 > E-mail: > benjamin.r...@manchester.ac.uk<https://outlook.manchester.ac.uk/owa/redir.aspx?C=b28b5bdd1a91425abf8e32748c93f487&URL=mailto%3abenjamin.ryan%40manchester.ac.uk> > ------------------------------------------------------------------ >