AW: boosting score by child document and returning only parents

2023-07-18 Thread nedyalko.zhe...@freelance.de.INVALID
Hello Mikhail,



thank you for your answer. Though we were not able to get it working, we 
understood the strategy you followed and this helped us to understand Solr 
more. In fact we could write a query that doesn't do exactly what we asked, but 
it's very similar and takes into account child documents to boost the results 
dynamically. As it could be interesting to other developers I paste it here:



q=+{!edismax qf='title^5 description' v='great'} {!parent which='_parent_:true' 
score=max v=$q1}
&q1={!boost b=rating score=max v=$q2}
&q2=country:AU



Thank you again for your assistance!

Ned

Von: Mikhail Khludnev 
Gesendet: Sonntag, 9. Juli 2023 11:29
An: users@solr.apache.org 
Betreff: Re: boosting score by child document and returning only parents

q=+{!edismax qf='title^5 summary' v=$pq} {!parent which='parent:true'
score=max v=$favorsAU}&pq=great&favorsAU=#_parent_:false
{!func}product(field(rating),query($AU,1))&AU=country:AU^=2


>
> On Tue, Jul 4, 2023 at 9:43 PM Mikhail Khludnev  wrote:
>
>> Hello Ned.
>> Make sure you check the guide first
>> https://deu01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsolr.apache.org%2Fguide%2Fsolr%2Flatest%2Fquery-guide%2Fsearching-nested-documents.html%23parent-query-parser&data=05%7C01%7Cnedyalko.zhekov%40freelance.de%7Cc01cda2a0d2a4f663e4808db805f0fd2%7C5846b1298c984422b5285c15a8f724b7%7C0%7C0%7C638244917995286164%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2FKiiPy6c7tRfJfldr5HdVSVNtTINpA1f81WY0aymhdo%3D&reserved=0
>> Note that Solr syntax is cumbersome.
>> Basically you need to combine two queries parent and joined parents.
>> q=+{!edismax qf='title^5 summary' v=$pq} {!parent which='parent:true'
>> score=max v='+docType:author country:Au^=10'}&pq=great
>> After every attempt check debugQuery=true output to make sure the query
>> is pared as expected.
>> It make sense to start with JSON Query DSL.
>> Good luck.
>>
>> On Tue, Jul 4, 2023 at 5:44 PM nedyalko.zhe...@freelance.de.INVALID
>>  wrote:
>>
>>>
>>> Hello everyone,
>>>
>>> we are using Solr for about 2 years and now we want to extend our
>>> queries to improve the relevance. In our case we have parent and child
>>> documents and in some cases child documents could help us to improve the
>>> way we are sorting the results. The problem is we didn't find at the moment
>>> an easy way to boost parent documents based on their child documents and we
>>> think we are doing something wrong, as this is a common use case. This
>>> could be an example of parent and child document:
>>>
>>> - Parent document
>>> {
>>> "_parent_": true,
>>> "_root_": "book/1"
>>> "id": "book/1",
>>> "docType": "book",
>>> "title": "Great expectations"
>>> "summary": "... some text ..."
>>> }
>>>
>>> - Child document
>>> {
>>> "_parent_": false,
>>> "_root_": "book/1"
>>> "id": "author/1",
>>> "docType": "author",
>>> "name": "Charles Dickens"
>>> "country": "England"
>>> "rating": 4.6
>>> }
>>>
>>> This could be a query:
>>> q=great
>>> &defType=edismax
>>> &qf=title^5 summary
>>> &fq=docType:book
>>> &fl=*,score
>>>
>>> Now, how to extend this query if we want to add the rating field from
>>> author document to the related book document score? Furthermore, what if we
>>> want to boost books written by Australian authors adding two times their
>>> rating value? In both cases, how to get only parent documents in the result?
>>>
>>> Thank you in advance.
>>> Ned
>>>
>>
>>
>> --
>> Sincerely yours
>> Mikhail Khludnev
>>
>
>
> --
> Sincerely yours
> Mikhail Khludnev
>


--
Sincerely yours
Mikhail Khludnev


RE: authentication for Leader/Follower replication

2023-07-18 Thread Oakley, Craig (NIH/NLM/NCBI) [C]
I am wondering whether anyone yet has any suggestions how to proceed

-Original Message-
From: Oakley, Craig (NIH/NLM/NCBI) [C]  
Sent: Thursday, July 6, 2023 4:00 PM
To: users@solr.apache.org
Subject: authentication for Leader/Follower replication

We are having problems transitioning Leader/Follower replication to Solr9.2.1

In Solr8.5 and below, what was then called Master/Slave replication had the 
annoying problem that, even though we specified httpBasicAuthUser and 
httpBasicAuthPassword, it would always attempt to connect first without a 
password before retrying with a password. This made solr.log noisy with lots of 
unnecessary login failures: but at least it worked.

When we transitioned to Solr8.11 (with the nomenclature changed to be less 
oppressive) we found that this version of Leader/Follower replication refused 
to retry (and refused to do anything with the values specified 
httpBasicAuthUser and httpBasicAuthPassword). We needed to open up replication 
in security.json to be available without password.

Now when we are preparing to upgrade to Solr9.2.1, we are having issues with 
the following:
2023-07-06 15:46:53.315 INFO  (indexFetcher-39-thread-1) [   ] 
o.a.s.h.IndexFetcher Last replication failed, so I'll force replication
2023-07-06 15:46:53.320 WARN  (indexFetcher-39-thread-1) [   ] 
o.a.s.h.IndexFetcher Leader at: 
http://[REDACTED]/solr/sequence2_shard1_replica_n1 is not available. Index 
fetch failed by exception: 
org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException: Error 
from server at http://[REDACTED]/solr/sequence2_shard1_replica_n1: Expected 
mime type in [application/octet-stream, application/vnd.apache.solr.javabin] 
but got text/html. 


Error 401 Could not load principal from SolrAuthV2 header.

HTTP ERROR 401 Could not load principal from SolrAuthV2 header.

URI:/solr/sequence2_shard1_replica_n1/replication
STATUS:401
MESSAGE:Could not load principal from SolrAuthV2 
header.
SERVLET:default





I have added "blockUnknown":false to security.json and have confirmed that the 
replication?command=indexversion command can be run without a password, and 
that it can be run with the login and password specified in httpBasicAuthUser 
and httpBasicAuthPassword

I have tried tweaking security.json with forwardCredentials values, but that 
has not helped

Any suggestions?





knn parser not working as expected

2023-07-18 Thread gnandre
Hi,

I am trying to use the knn parser in Solr 9.2.1 as follows:

curl -X POST -H "Content-Type: application/json" -d '{
  "params": {
"q": "{!knn f=dense_vector
topK=1}[0.06525743007659912,0.015727980062365532,0.003069591475650668,-0.016254400834441185,0.003478930564597249,-0.02475954219698906,0.020238326862454414,0.010255611501634121,0.05522076040506363,0.020635411143302917,0.05825875699520111,-0.05110647529363632,-0.04696913808584213,0.05991407483816147,-0.0003015052934642881,0.03625837340950966,-0.044656239449977875,-0.06582673639059067,-0.06842341274023056,-0.022927379235625267,0.048230838030576706,-0.12659960985183716,-0.019311215728521347,-0.04432906210422516,0.03600681200623512,0.010301047936081886,0.08415472507476807,0.04727723449468613,-0.0584205724298954,-0.045265913009643555,0.012285877950489521,0.0034233061596751213,-0.00982636958360672,-0.013216182589530945,-0.038882751017808914,-0.05872005969285965,-0.029350444674491882,0.04930287227034569,0.0022274062503129244,0.01728842593729496,-0.08762819767,-0.045831114053726196,0.072530098259449,0.03804686293005943,0.0021682181395590305,-0.05424166098237038,-0.004494055639952421,0.05843663960695267,0.058729417622089386,0.016252348199486732,0.0019551776349544525,-0.012190568260848522,-0.08235936611890793,-0.003848800901323557,0.028969185426831245,0.047798849642276764,-0.04074695333838463,-0.10175333172082901,0.06699151545763016,-0.06788542866706848,-0.01607389748096466,0.07294511049985886,0.007754810154438019,0.039606861770153046,0.07451225817203522,-0.02967959391212,0.014015864580869675,0.08055979013442993,0.0010412412229925394,0.13284511864185333,-0.013288799673318863,-0.05446619912981987,-0.03510258346796036,-0.12459734082221985,-0.017629574984312057,-0.04287091642618179,-0.019087448716163635,0.027409998700022697,-0.040427371859550476,-0.1713477075099945,-0.0035959691740572453,0.01750982739031315,-0.06452985852956772,0.10622204840183258,-0.06865541636943817,0.06022517383098602,0.03378240391612053,0.02320132404565811,0.02072194404900074,0.03390982002019882,0.0051648980006575584,0.05843415856361389,-0.07012602686882019,0.046549294143915176,0.005304296966642141,0.09183698892593384,0.060101959854364395,-0.031673040241003036,0.03126641735434532,0.10213921219110489,0.07624002546072006,-0.09995660930871964,0.03316718339920044,-0.040208760648965836,-0.016963355243206024,-0.01603076048195362,-0.00566966412588954,0.0570228286087513,0.006566803902387619,0.028397461399435997,-0.03737075999379158,-0.03357473015785217,-0.05060608312487602,0.0882791057229042,0.14182551205158234,0.01651209406554699,0.047577112913131714,-0.028357332572340965,-0.12397051602602005,0.03264006972312927,0.030581200495362282,0.025287700816988945,-0.08509892970323563,0.032361947267,-0.06732083112001419,0.0193667970597744,0.07096285372972488,-5.732041797079612e-33,0.033934514969587326,0.029480531811714172,-0.024119360372424126,0.03248802572488785,0.060654137283563614,-0.04089922457933426,-0.06845896691083908,0.015865417197346687,-0.03816983848810196,0.12768638134002686,-0.047979939728975296,0.01888129487633705,0.01966758444905281,-0.021792754530906677,-0.00209379056468606,-0.060791824012994766,0.07595516741275787,-0.05137578397989273,-0.020345840603113174,0.02730456180870533,-0.08421282470226288,0.0052170781418681145,-0.0396740548312664,0.013655638322234154,0.043763574212789536,0.0368662029504776,-0.021710995584726334,0.03603581339120865,0.04991370812058449,-0.007524373475462198,0.033250145614147186,0.0669487863779068,-0.012807670049369335,-0.08904062211513519,-0.04803512617945671,-0.0461772084236145,0.018098553642630577,0.01096352282911539,0.0617918036878109,0.014066621661186218,-0.03305654972791672,-0.08129353821277618,-0.025270603597164154,0.03537251427769661,0.06029881164431572,0.06169535592198372,0.0355769582092762,0.03534447401762009,-0.047377053648233414,0.053076375275850296,-0.019250469282269478,-0.03837420791387558,-0.00834209006279707,0.031550273299217224,0.004682184662669897,0.0590718574821949,0.0326957181096077,-0.041941817849874496,-0.04179370403289795,-0.010403091087937355,0.11914990842342377,-0.049126915633678436,0.015761952847242355,-0.012162514962255955,-0.05942496284842491,0.04794146493077278,-0.06834675371646881,-0.03294386342167854,0.02242257259786129,0.0774146020412445,-0.1095564718246,0.023828692734241486,0.054935190826654434,0.0202674251049757,-0.057155776768922806,-0.009578827768564224,-0.051850661635398865,0.09117215871810913,-0.07315851002931595,-0.0019339871359989047,-0.05835318937897682,-0.058747921139001846,-0.05519327148795128,-0.014699703082442284,-0.0020833320450037718,-0.05721793323755264,0.055632084608078,0.006448595318943262,0.0034963993821293116,-0.031087594106793404,-0.09541762620210648,0.03679275885224342,-0.012651922181248665,-0.038976479321718216,-0.013171667233109474,3.5278054836115376e-33,-0.057552605867385864,0.15763822197914124,0.008786757476627827,0.029096176847815514,-0.011134237051010132,0.030201362445950508,0.011168091557919