Re: Query Regarding SOLR cross collection join

2020-01-29 Thread Mikhail Khludnev
It's time to enforce and document field type constraints https://issues.apache.org/jira/browse/SOLR-14230. On Mon, Jan 27, 2020 at 4:12 PM Doss wrote: > @ Alessandro Benedetti , Thanks for your input! > > @ Mikhail Khludnev , I made docValues="true" for from & to and did a index > rotation, now

Re: Query Regarding SOLR cross collection join

2020-01-27 Thread Doss
@ Alessandro Benedetti , Thanks for your input! @ Mikhail Khludnev , I made docValues="true" for from & to and did a index rotation, now the score join works perfectly! Saw 7x performance increase. Thanks! On Thu, Jan 23, 2020 at 9:53 PM Mikhail Khludnev wrote: > On Wed, Jan 22, 2020 at 4:27

Re: Query Regarding SOLR cross collection join

2020-01-23 Thread Mikhail Khludnev
On Wed, Jan 22, 2020 at 4:27 PM Doss wrote: > HI, > > SOLR version 8.3.1 (10 nodes), zookeeper ensemble (3 nodes) > > Read somewhere that the score join parser will be faster, but for me it > produces no results. I am using string type fields for from and to. > That's odd. Can you try to enable

Re: Query Regarding SOLR cross collection join

2020-01-23 Thread Alessandro Benedetti
>From the Join Query Parser code: "// most of these statistics are only used for the enum method int fromSetSize; // number of docs in the fromSet (that match the from query) long resultListDocs; // total number of docs collected int fromTermCount; long fromTermTotalDf; int fromTerm

Query Regarding SOLR cross collection join

2020-01-22 Thread Doss
HI, SOLR version 8.3.1 (10 nodes), zookeeper ensemble (3 nodes) One of our use cases requires joins, we are joining 2 large indexes. As required by SOLR one index (2GB) has one shared and 10 replicas and the other has 10 shard (40GB / Shard). The query takes too much time, some times in minutes