Hi All,
It seems that it's not possible to compare fields from different collections.
I have another question:
Is it possible to use join to get all documents which existe in the first
collection but not in the second.It's equivalent to SQL statement:
Select A.* From Collection1 A LEFT OUTER JOIN Collection2 B on A.id=B.idWhere
B.Id is NULL;
Regards,NKI.
De : nabil Kouici <koui...@yahoo.fr.INVALID>
À : "solr-user@lucene.apache.org" <solr-user@lucene.apache.org>
Envoyé le : Vendredi 20 janvier 2017 14h42
Objet : Re: Joining Across Collections
Hi Mikhail,
I'm not we can do a negation because Field1 and Field2 are not in the join
condition.
Regards,Nabil.
De : Mikhail Khludnev <m...@apache.org>
À : solr-user <solr-user@lucene.apache.org>; nabil Kouici <koui...@yahoo.fr>
Envoyé le : Jeudi 19 janvier 2017 9h00
Objet : 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 <koui...@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
