You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@solr.apache.org by 邵长城 <ch...@126.com> on 2022/10/19 11:59:31 UTC
Solr 8.11 join and crossCollection join about q.op
Hi, Solr team
I am using Solr 8.11 to change join query to crossCollection join.
When I compare the query and result, I noticed something different.
If the join query is: q.op=AND&q=network_id:144750 AND {!join fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND index_type:ADV'}
When query the fromIndex(company), the q.op=AND will work on name:(sky vip), so the value of name must contains sky and vip.
If the crossCollection join query is: q.op=AND&q=network_id:144750 AND {!join method='crossCollection' fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND index_type:ADV'}
When query the fromIndex(company), the q.op=AND not work on name:(sky vip). In other workds, the value of name shoud contains sky or vip, It used q.op=OR.
So I want to ask, how I shoud configure the solr configure file or how do I write the query, the q.op=AND will apply to the fromIndex query.
Hope to get you response, thanks!
Re: Solr 8.11 join and crossCollection join about q.op
Posted by Mikhail Khludnev <mk...@apache.org>.
Ok. I've got it after all.
method=crossCollection doesn't pass query params into join query see
https://github.com/apache/solr/blob/main/solr/core/src/java/org/apache/solr/search/join/CrossCollectionJoinQParser.java#L106
Notice there is no usage of `params` member over there.
Presumably it can be a jira ticket for crossCore join improvement.
However q.op can be passed via local params. Something like:
q={!join method='crossCollection' fromIndex=company from=id
to=advertiser_id v='{!q.op=AND}name:(nbc advertiser)'}
On Thu, Oct 20, 2022 at 3:26 PM Changcheng Shao <ch...@126.com>
wrote:
> Hi，Solr team
>
>
> About the join and crossCollection query, I open the debugQuery, and the
> query, log and result is:
>
>
> 1. crossCollection Join
> query:
>
> http://localhost:8983/solr/advertising/select?indent=true&q.op=AND&q=%7B!join%20method%3D%27crossCollection%27%20fromIndex%3Dcompany%20from%3Did%20to%3Dadvertiser_id%20v%3D%27name%3A(nbc%20advertiser)%27%7D&debugQuery=true
>
>
> Result:
> Query numFound is 719
> And in fromIndex(company), query is: name:(nbc advertiser), and numFound
> is 44.
>
>
> Log:
> INFO - 2022-10-20 10:46:59.238; org.apache.solr.core.SolrCore.Request;
> [advertising_shard1_replica_n1] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2833&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666262819235&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false
> <http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2833&version=2&q=%7B!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'%7D&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666262819235&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false>}
> hits=197 status=0 QTime=0
> INFO - 2022-10-20 10:46:59.239; org.apache.solr.core.SolrCore.Request;
> [advertising_shard2_replica_n2] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2833&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666262819235&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false
> <http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2833&version=2&q=%7B!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'%7D&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666262819235&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false>}
> hits=522 status=0 QTime=0
> INFO - 2022-10-20 10:46:59.253; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=1
> INFO - 2022-10-20 10:46:59.260; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=1
> INFO - 2022-10-20 10:46:59.267; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=1
> INFO - 2022-10-20 10:46:59.275; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=1
> INFO - 2022-10-20 10:46:59.279; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=0
> INFO - 2022-10-20 10:46:59.286; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=0
> INFO - 2022-10-20 10:46:59.291; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=1
> INFO - 2022-10-20 10:46:59.296; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=0
> INFO - 2022-10-20 10:46:59.301; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=0
> INFO - 2022-10-20 10:46:59.306; org.apache.solr.core.SolrCore.Request;
> [company_shard1_replica_n1] webapp=/solr path=/export
> params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=44 status=0 QTime=0
> INFO - 2022-10-20 10:46:59.311; org.apache.solr.core.SolrCore.Request;
> [advertising_shard1_replica_n1] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2833&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666262819235&ids=CAM15469827,CAM15469826,CAM15469175,CAM500855,CAM500408,CAM15469797,CAM15469675,CAM15469768,CAM15469855,CAM15469613&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true
> <http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2833&version=2&q=%7B!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'%7D&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666262819235&ids=CAM15469827,CAM15469826,CAM15469175,CAM500855,CAM500408,CAM15469797,CAM15469675,CAM15469768,CAM15469855,CAM15469613&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true>}
> status=0 QTime=67
> INFO - 2022-10-20 10:46:59.312; org.apache.solr.core.SolrCore.Request;
> [advertising_shard2_replica_n2] webapp=/solr path=/select
> params={q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&indent=true&q.op=AND&debugQuery=true}
> rid=-2833 hits=719 status=0 QTime=77
>
>
> But when I change the query:
>
> http://localhost:8983/solr/advertising/select?indent=true&q.op=AND&q=%7B!join%20method%3D%27crossCollection%27%20fromIndex%3Dcompany%20from%3Did%20to%3Dadvertiser_id%20v%3D%27name%3A(nbc%20AND%20advertiser)%27%7D&debugQuery=true
>
>
> Result:
> Query numFound is 16
> And in fromIndex(company), query is: name:(nbc AND advertiser), and
> numFound is 2.
>
>
> Log:
> INFO - 2022-10-20 10:55:49.208; org.apache.solr.core.SolrCore.Request;
> [advertising_shard2_replica_n2] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263349194&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false
> <http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2901&version=2&q=%7B!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'%7D&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263349194&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false>}
> hits=13 status=0 QTime=1 INFO - 2022-10-20 10:55:49.208;
> org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1]
> webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263349194&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false
> <http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2901&version=2&q=%7B!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'%7D&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263349194&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false>}
> hits=3 status=0 QTime=1 INFO - 2022-10-20 10:55:49.233;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=12 INFO - 2022-10-20 10:55:49.233;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=11 INFO - 2022-10-20 10:55:49.241;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.241;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.247;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.247;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.252;
> org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1]
> webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263349194&ids=IO500409,CAM500408,PLC500410&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true
> <http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2901&version=2&q=%7B!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'%7D&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263349194&ids=IO500409,CAM500408,PLC500410&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true>}
> status=0 QTime=37 INFO - 2022-10-20 10:55:49.253;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.258;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.262;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.270;
> org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1]
> webapp=/solr path=/export
> params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2}
> hits=2 status=0 QTime=3 INFO - 2022-10-20 10:55:49.274;
> org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2]
> webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263349194&ids=IO501020,IO500477,IO501015,CAM501012,CAM500476,PLC500478,CAM501017&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true
> <http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2901&version=2&q=%7B!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'%7D&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263349194&ids=IO501020,IO500477,IO501015,CAM501012,CAM500476,PLC500478,CAM501017&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true>}
> status=0 QTime=59 INFO - 2022-10-20 10:55:49.286;
> org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2]
> webapp=/solr path=/select
> params={q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&indent=true&q.op=AND&debugQuery=true}
> rid=-2901 hits=16 status=0 QTime=91
>
>
> 2. Join query
> query :
>
> http://localhost:8983/solr/advertising/select?indent=true&q.op=AND&q=%7B!join%20fromIndex%3Dcompany%20from%3Did%20to%3Dadvertiser_id%20v%3D%27name%3A(nbc%20advertiser)%27%7D&debugQuery=true
>
>
> Result:
> Query numFound is 16
>
>
> log:
> INFO - 2022-10-20 10:50:45.614; org.apache.solr.core.SolrCore.Request;
> [advertising_shard2_replica_n2] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263045601&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false
> <http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2858&version=2&q=%7B!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'%7D&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263045601&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false>}
> hits=13 status=0 QTime=0
> INFO - 2022-10-20 10:50:45.614; org.apache.solr.core.SolrCore.Request;
> [advertising_shard1_replica_n1] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263045601&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false
> <http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2858&version=2&q=%7B!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'%7D&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263045601&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false>}
> hits=3 status=0 QTime=1
> INFO - 2022-10-20 10:50:45.632; org.apache.solr.core.SolrCore.Request;
> [advertising_shard1_replica_n1] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263045601&ids=IO500409,CAM500408,PLC500410&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true
> <http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2858&version=2&q=%7B!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'%7D&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263045601&ids=IO500409,CAM500408,PLC500410&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true>}
> status=0 QTime=12
> INFO - 2022-10-20 10:50:45.633; org.apache.solr.core.SolrCore.Request;
> [advertising_shard2_replica_n2] webapp=/solr path=/select
> params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=
> http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263045601&ids=IO501020,IO500477,IO501015,CAM501012,CAM500476,PLC500478,CAM501017&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true
> <http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2858&version=2&q=%7B!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'%7D&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263045601&ids=IO501020,IO500477,IO501015,CAM501012,CAM500476,PLC500478,CAM501017&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true>}
> status=0 QTime=13
> INFO - 2022-10-20 10:50:45.634; org.apache.solr.core.SolrCore.Request;
> [advertising_shard1_replica_n1] webapp=/solr path=/select
> params={q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&indent=true&q.op=AND&debugQuery=true}
> rid=-2858 hits=16 status=0 QTime=33
>
>
> 3. Collection company query:
> q,op=OR query:
> http://localhost:8983/solr/company/select?indent=true&q.op=OR&q=name%3A(nbc%20advertiser)
> numFound: 44
> q,op=AND query:
> http://localhost:8983/solr/company/select?indent=true&q.op=AND&q=name%3A(nbc%20advertiser)
> numFound: 2
> 4. The Conslusion
> In join query, the q.op=AND in query parameters can apply to the fromIndex
> query.
> But in crossCollection join, the q.op=AND in query parameters can not
> apply to the fromIndex query, fromIndex query use q.op=OR
> So, using crossCollection join, If I don not change the fromIndex query
> from name:(nbc, advertiser) to name:(nbc AND advertiser).
> How I shoud configure the solr configure file, the q.op=AND will apply to
> the fromIndex query? Or is this a bug for crossCollection join?
> Hope to get you response, thanks!
>
>
>
>
>
> At 2022-10-19 19:59:31, "邵长城" <ch...@126.com> wrote:
>
> Hi, Solr team
>
>
> I am using Solr 8.11 to change join query to crossCollection join.
> When I compare the query and result, I noticed something different.
>
>
> If the join query is: q.op=AND&q=network_id:144750 AND {!join
> fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND
> index_type:ADV'}
> When query the fromIndex(company), the q.op=AND will work on name:(sky
> vip), so the value of name must contains sky and vip.
>
>
> If the crossCollection join query is: q.op=AND&q=network_id:144750 AND
> {!join method='crossCollection' fromIndex=company from=id to=advertiser_id
> v='name:(sky vip) AND index_type:ADV'}
> When query the fromIndex(company), the q.op=AND not work on name:(sky
> vip). In other workds, the value of name shoud contains sky or vip, It
> used q.op=OR.
>
>
> So I want to ask, how I shoud configure the solr configure file or how do
> I write the query, the q.op=AND will apply to the fromIndex query.
>
>
> Hope to get you response, thanks!
--
Sincerely yours
Mikhail Khludnev
Re:Solr 8.11 join and crossCollection join about q.op
Posted by Changcheng Shao <ch...@126.com>.
Hi，Solr team
About the join and crossCollection query, I open the debugQuery, and the query, log and result is:
1. crossCollection Join
query:
http://localhost:8983/solr/advertising/select?indent=true&q.op=AND&q=%7B!join%20method%3D%27crossCollection%27%20fromIndex%3Dcompany%20from%3Did%20to%3Dadvertiser_id%20v%3D%27name%3A(nbc%20advertiser)%27%7D&debugQuery=true
Result:
Query numFound is 719
And in fromIndex(company), query is: name:(nbc advertiser), and numFound is 44.
Log:
INFO - 2022-10-20 10:46:59.238; org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2833&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666262819235&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false} hits=197 status=0 QTime=0
INFO - 2022-10-20 10:46:59.239; org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2833&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666262819235&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false} hits=522 status=0 QTime=0
INFO - 2022-10-20 10:46:59.253; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=1
INFO - 2022-10-20 10:46:59.260; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=1
INFO - 2022-10-20 10:46:59.267; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=1
INFO - 2022-10-20 10:46:59.275; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=1
INFO - 2022-10-20 10:46:59.279; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=0
INFO - 2022-10-20 10:46:59.286; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=0
INFO - 2022-10-20 10:46:59.291; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=1
INFO - 2022-10-20 10:46:59.296; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=0
INFO - 2022-10-20 10:46:59.301; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=0
INFO - 2022-10-20 10:46:59.306; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=44 status=0 QTime=0
INFO - 2022-10-20 10:46:59.311; org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2833&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666262819235&ids=CAM15469827,CAM15469826,CAM15469175,CAM500855,CAM500408,CAM15469797,CAM15469675,CAM15469768,CAM15469855,CAM15469613&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true} status=0 QTime=67
INFO - 2022-10-20 10:46:59.312; org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2] webapp=/solr path=/select params={q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&indent=true&q.op=AND&debugQuery=true} rid=-2833 hits=719 status=0 QTime=77
But when I change the query:
http://localhost:8983/solr/advertising/select?indent=true&q.op=AND&q=%7B!join%20method%3D%27crossCollection%27%20fromIndex%3Dcompany%20from%3Did%20to%3Dadvertiser_id%20v%3D%27name%3A(nbc%20AND%20advertiser)%27%7D&debugQuery=true
Result:
Query numFound is 16
And in fromIndex(company), query is: name:(nbc AND advertiser), and numFound is 2.
Log:
INFO - 2022-10-20 10:55:49.208; org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263349194&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false} hits=13 status=0 QTime=1 INFO - 2022-10-20 10:55:49.208; org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263349194&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false} hits=3 status=0 QTime=1 INFO - 2022-10-20 10:55:49.233; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=12 INFO - 2022-10-20 10:55:49.233; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=11 INFO - 2022-10-20 10:55:49.241; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.241; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.247; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.247; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.252; org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263349194&ids=IO500409,CAM500408,PLC500410&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true} status=0 QTime=37 INFO - 2022-10-20 10:55:49.253; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.258; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.262; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=0 INFO - 2022-10-20 10:55:49.270; org.apache.solr.core.SolrCore.Request; [company_shard1_replica_n1] webapp=/solr path=/export params={q=name:(nbc+AND+advertiser)&distrib=false&method=crossCollection&indent=off&fl=id&sort=id+asc&wt=javabin&version=2.2} hits=2 status=0 QTime=3 INFO - 2022-10-20 10:55:49.274; org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2901&version=2&q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263349194&ids=IO501020,IO500477,IO501015,CAM501012,CAM500476,PLC500478,CAM501017&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true} status=0 QTime=59 INFO - 2022-10-20 10:55:49.286; org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2] webapp=/solr path=/select params={q={!join+method%3D'crossCollection'+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+AND+advertiser)'}&indent=true&q.op=AND&debugQuery=true} rid=-2901 hits=16 status=0 QTime=91
2. Join query
query :
http://localhost:8983/solr/advertising/select?indent=true&q.op=AND&q=%7B!join%20fromIndex%3Dcompany%20from%3Did%20to%3Dadvertiser_id%20v%3D%27name%3A(nbc%20advertiser)%27%7D&debugQuery=true
Result:
Query numFound is 16
log:
INFO - 2022-10-20 10:50:45.614; org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263045601&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false} hits=13 status=0 QTime=0
INFO - 2022-10-20 10:50:45.614; org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=false&debug=timing&debug=track&fl=uid&fl=score&shards.purpose=16388&start=0&fsv=true&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_TOP_IDS,SET_TERM_STATS&NOW=1666263045601&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=false} hits=3 status=0 QTime=1
INFO - 2022-10-20 10:50:45.632; org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard1_replica_n1/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263045601&ids=IO500409,CAM500408,PLC500410&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true} status=0 QTime=12
INFO - 2022-10-20 10:50:45.633; org.apache.solr.core.SolrCore.Request; [advertising_shard2_replica_n2] webapp=/solr path=/select params={df=name&distrib=false&preferLocalShards=false&debug=timing&debug=track&shards.purpose=16704&q.op=AND&shard.url=http://172.20.0.10:8983/solr/advertising_shard2_replica_n2/&rows=10&rid=-2858&version=2&q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&omitHeader=false&requestPurpose=GET_FIELDS,GET_DEBUG,SET_TERM_STATS&NOW=1666263045601&ids=IO501020,IO500477,IO501015,CAM501012,CAM500476,PLC500478,CAM501017&isShard=true&timeAllowed=15000&wt=javabin&debugQuery=true} status=0 QTime=13
INFO - 2022-10-20 10:50:45.634; org.apache.solr.core.SolrCore.Request; [advertising_shard1_replica_n1] webapp=/solr path=/select params={q={!join+fromIndex%3Dcompany+from%3Did+to%3Dadvertiser_id+v%3D'name:(nbc+advertiser)'}&indent=true&q.op=AND&debugQuery=true} rid=-2858 hits=16 status=0 QTime=33
3. Collection company query:
q,op=OR query: http://localhost:8983/solr/company/select?indent=true&q.op=OR&q=name%3A(nbc%20advertiser)
numFound: 44
q,op=AND query: http://localhost:8983/solr/company/select?indent=true&q.op=AND&q=name%3A(nbc%20advertiser)
numFound: 2
4. The Conslusion
In join query, the q.op=AND in query parameters can apply to the fromIndex query.
But in crossCollection join, the q.op=AND in query parameters can not apply to the fromIndex query, fromIndex query use q.op=OR
So, using crossCollection join, If I don not change the fromIndex query from name:(nbc, advertiser) to name:(nbc AND advertiser).
How I shoud configure the solr configure file, the q.op=AND will apply to the fromIndex query? Or is this a bug for crossCollection join?
Hope to get you response, thanks!
At 2022-10-19 19:59:31, "邵长城" <ch...@126.com> wrote:
Hi, Solr team
I am using Solr 8.11 to change join query to crossCollection join.
When I compare the query and result, I noticed something different.
If the join query is: q.op=AND&q=network_id:144750 AND {!join fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND index_type:ADV'}
When query the fromIndex(company), the q.op=AND will work on name:(sky vip), so the value of name must contains sky and vip.
If the crossCollection join query is: q.op=AND&q=network_id:144750 AND {!join method='crossCollection' fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND index_type:ADV'}
When query the fromIndex(company), the q.op=AND not work on name:(sky vip). In other workds, the value of name shoud contains sky or vip, It used q.op=OR.
So I want to ask, how I shoud configure the solr configure file or how do I write the query, the q.op=AND will apply to the fromIndex query.
Hope to get you response, thanks!
Re: Solr 8.11 join and crossCollection join about q.op
Posted by Mikhail Khludnev <mk...@apache.org>.
Hello,
The situation is not clear. Can you check the particular parsed query in
debugQuery=true output for both these cases?
If query is n't parsed as expected, cant' you make more explicit eg
name:(sky AND vip) AND index_type:ADV
or even
+name:(+sky +vip) +index_type:ADV
On Wed, Oct 19, 2022 at 3:18 PM 邵长城 <ch...@126.com> wrote:
> Hi, Solr team
>
>
> I am using Solr 8.11 to change join query to crossCollection join.
> When I compare the query and result, I noticed something different.
>
>
> If the join query is: q.op=AND&q=network_id:144750 AND {!join
> fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND
> index_type:ADV'}
> When query the fromIndex(company), the q.op=AND will work on name:(sky
> vip), so the value of name must contains sky and vip.
>
>
> If the crossCollection join query is: q.op=AND&q=network_id:144750 AND
> {!join method='crossCollection' fromIndex=company from=id to=advertiser_id
> v='name:(sky vip) AND index_type:ADV'}
> When query the fromIndex(company), the q.op=AND not work on name:(sky
> vip). In other workds, the value of name shoud contains sky or vip, It
> used q.op=OR.
>
>
> So I want to ask, how I shoud configure the solr configure file or how do
> I write the query, the q.op=AND will apply to the fromIndex query.
>
>
> Hope to get you response, thanks!
--
Sincerely yours
Mikhail Khludnev