lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vadim Ivanov" <vadim.iva...@spb.ntk-intourist.ru>
Subject RE: join query in same collection
Date Fri, 14 Sep 2018 19:57:52 GMT
Hi,
AFAIK Solr can  join only local indexes. No matter whether you join the same collection or
two different ones.
So, in your case shard1 will be joined to shard1  and shard2 to shard2.
Unfortunately it's hard to say from your data  which document resides in which shard, but
you can test using &distrib=false
-- 
BR, Vadim



-----Original Message-----
From: Steve Pruitt [mailto:bpruitt@opentext.com] 
Sent: Friday, September 14, 2018 9:22 PM
To: solr-user@lucene.apache.org
Subject: join query in same collection

I see nothing in the documentation suggesting a query with a join filter doesn't work when
a single collection is involved.  There is the special deployment instructions when joining
across two distinct collections, but this is not my case.

I have a single collection:
I have two VM's, both running Solrcloud.
My collection has 2 shards on two different nodes.  Max shards per node is set to 1 and replication
factor is set to 1.

The join filter is: {!join from=expctr-label-memberIds to=expctr-id}expctr-id:4b6f7d34-a58b-3399-b077-685951d06738

When I run the query, I get back only the document with expctr-id: 2087d22a-6157-306f-8386-8352e7d8e4d4
This looks, maybe, like it only finds a document on the replica handling the query.  Shouldn't
it search and filter across the entire collection?

The documents:
       {
        "expctr-name":"online account opening",
        "expctr-description":["Journey for online customers"],
        "expctr-created":1536947719132,
        "expctr-to-date":1546232400000,
        "expctr-from-date":1538366400000,
        "expctr-id":"89ec679b-24df-3559-8428-124640c96230",
        "expctr-creator":"SP",
        "expctr-type":"journey",
        "_version_":1611606406752894976},
      {
        "expctr-name":"drop-in account opening",
        "expctr-description":["Journey for dropin customers"],
        "expctr-created":1536947827643,
        "expctr-to-date":1546232400000,
        "expctr-from-date":1538366400000,
        "expctr-id":"2087d22a-6157-306f-8386-8352e7d8e4d4",
        "expctr-creator":"SP",
        "expctr-type":"journey",
        "_version_":1611606520475156480},
      {
        "expctr-name":"placeholder",
        "expctr-label":"customers",
        "expctr-created":1536947679984,
        "expctr-to-date":0,
        "expctr-from-date":0,
        "expctr-id":"4b6f7d34-a58b-3399-b077-685951d06738",
        "expctr-creator":"SP",
        "expctr-type":"label",
        "expctr-label-memberIds":["89ec679b-24df-3559-8428-124640c96230", "2087d22a-6157-306f-8386-8352e7d8e4d4"],
        "_version_":1611606544788488192}]
  }


Mime
View raw message