lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Moenieb Davids <Moenieb.Dav...@gpaa.gov.za>
Subject RE: Joining Across Collections
Date Thu, 19 Jan 2017 11:09:19 GMT
Hi Guys

Just a quick question on search and join:

I have a few cores which is based on a mainframe extract, 1 core per extracted file which
resembles a "DB Table"
The cores are all somehow linked via 1 to many fields, with a structure similar to a normal
ERD

Is it possible to return the result from a query that joins lets say 3 cores in the following
format:

        "core1_id":"XXX",
        "_childDocuments_":[
        {
          "core2_id":"yyy",
          "core_2_fieldx":"ABC",
                  "_childDocuments_":[
                  {
                    "core3_id":"zzz",
                    "core_3_fieldx":"ABC",
                    "core3_fieldy":"123",
                  {
          "core2_fieldy":"123",
        {

Regards
Moenieb Davids

-----Original Message-----
From: Mikhail Khludnev [mailto:mkhl@apache.org] 
Sent: 19 January 2017 10:00 AM
To: solr-user; nabil Kouici
Subject: Re: Joining Across Collections

It seems like it can be done by just negating join query or I'm missing something.

On Wed, Jan 18, 2017 at 11:32 AM, nabil Kouici <kouicin@yahoo.fr.invalid>
wrote:

> Hi All,
> I'm using  join across collection feature to do an inner join between 
> 2 collections. It works fine.
> Is it possible to use this feature to compare between fields from 
> different collections. For exemple:
> Collection1 Field1Collection2 Field2
> search document from Collection1 where Field1 != Field2 In sql, this 
> will translated to:
> Select A.* From Collection1 A inner join Collection2 B on  
> A.id=B.idWhere
> A.Field1<>B.Field2
>
> Thank you.
> Regards,NKI.
>



--
Sincerely yours
Mikhail Khludnev










===========================================================================
GPAA e-mail Disclaimers and confidential note 

This e-mail is intended for the exclusive use of the addressee only.
If you are not the intended recipient, you should not use the contents 
or disclose them to any other person. Please notify the sender immediately 
and delete the e-mail. This e-mail is not intended nor 
shall it be taken to create any legal relations, contractual or otherwise. 
Legally binding obligations can only arise for the GPAA by means of 
a written instrument signed by an authorised signatory.
===========================================================================
Mime
View raw message