thread hijack: Erick, wdyt about writing query-time analog of [child] https://cwiki.apache.org/confluence/display/solr/Transforming+Result+Documents ?
On Thu, Oct 22, 2015 at 6:32 PM, Erick Erickson <erickerick...@gmail.com> wrote: > You will NOT get the stored fields from the child record > with the join operation, it's called "pseudo join" for a > good reason. > > It's usually a mistake to try to force Solr to performa just > like a database. I would seriously consider flattening > (denormalizing) the data if at all possible. > > Best, > Erick > > On Wed, Oct 21, 2015 at 10:36 PM, cai xingliang <caixingli...@gmail.com> > wrote: > > {!join fromIndex=parent from=id to=parent_id}tag:hoge > > > > That should work. > > On Oct 22, 2015 12:35 PM, "Shuhei Suzuki" <hum2....@gmail.com> wrote: > > > >> hello, > >> What can I do to throw a query such as the following in Solr? > >> > >> SELECT > >> child. *, parent. * > >> FROM child > >> JOIN parent > >> WHERE child.parent_id = parent.id AND parent.tag = 'hoge'` > >> > >> child and parent is not that parent is more than in a many-to-one > >> relationship. > >> I try this but can not. > >> > >> /select/?q={!join from=parent_id to=id fromIndex=parent}id:1+tag:hoge > >> > >> > >> > >> > >> > >> -- > >> View this message in context: > >> > http://lucene.472066.n3.nabble.com/How-to-get-the-join-data-by-multiple-cores-tp4235799.html > >> Sent from the Solr - User mailing list archive at Nabble.com. > >> > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>