You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@solr.apache.org by Anuj Bhargava <an...@gmail.com> on 2021/04/30 13:25:22 UTC
Solr 8.6.2 - single query on 2 cores ?
I have 2 cores '*live*' and '*archive*' with exactly the same fields.
I want to query on a unique id - '*posting_id*'. First it should check
*live* and if not found then in *archive* and show the results.
The following is doing a search on *live* and not on *archive*
http://xxx:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=archive
The following gives an error -
http://xxx.yyy.zzz.aaa:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=xxx.yyy.zzz.aaa:8983/solr/archive
<response>
<lst name="responseHeader">
<int name="status">401</int>
<int name="QTime">10</int>
<lst name="params">
<str name="q">*:*</str>
<str name="shards">xxx.yyy.zzz.aaa:8983/solr/archive</str>
<str name="indent">true</str>
<str name="fq">posting_id:41009261</str>
<str name="wt">xml</str>
</lst>
</lst>
<lst name="error">
<lst name="metadata">
<str
name="error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
<str
name="root-error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
</lst>
<str name="msg">Error from server at null: Expected mime type
application/octet-stream but got text/html. <html> <head> <meta
http-equiv="Content-Type" content="text/html;charset=utf-8"/> <title>Error
401 Unauthorized</title> </head> <body><h2>HTTP ERROR 401 Unauthorized</h2>
<table> <tr><th>URI:</th><td>/solr/archive/select</td></tr>
<tr><th>STATUS:</th><td>401</td></tr>
<tr><th>MESSAGE:</th><td>Unauthorized</td></tr>
<tr><th>SERVLET:</th><td>default</td></tr> </table> </body> </html> </str>
<int name="code">401</int>
</lst>
</response>
How can I do a single query on 2 cores
Have added the following in solr.in.sh - SOLR_OPTS="$SOLR_OPTS
-Dsolr.disable.shardsWhitelist=true"
Re: Solr 8.6.2 - single query on 2 cores ?
Posted by Anuj Bhargava <an...@gmail.com>.
We are not running in cloud mode.
There is no Stream on the left.
*Logout admin*
*Dashboard*
*Logging*
*Core Admin*
*Java Properties*
*Thread Dump*
*Overview*
*Analysis*
*Dataimport*
*Documents*
*Files*
*Ping*
*Plugins / Stats*
*Query*
*Replication*
*Schema*
*Segments info*
Regards,
ANuj
On Mon, 3 May 2021 at 04:28, ufuk yılmaz <uy...@vivaldi.net.invalid>
wrote:
> My quess is that it’s not related to streaming expression. Are you running
> solr in cloud mode? Any problems with your zookeeper?
>
> Can you run the expression in solr admin ui? Select any collection and
> choose stream from the left
>
> Can you run this very simple expression: echo("Hello World")
>
>
>
> Sent from Mail for Windows 10
>
> From: Anuj Bhargava
> Sent: 02 May 2021 14:21
> To: users@solr.apache.org
> Subject: Re: Solr 8.6.2 - single query on 2 cores ?
>
> Hi,
>
> Got the following message -
>
> {
> "result-set":{
> "docs":[{
> "EXCEPTION":"java.util.concurrent.TimeoutException: Could not
> connect to ZooKeeper null within 15000 ms",
> "EOF":true,
> "RESPONSE_TIME":15512}]}}
>
> Regards,
>
> Anuj
>
> On Sun, 2 May 2021 at 16:36, ufuk yılmaz <uy...@vivaldi.net.invalid>
> wrote:
>
> > Hi, can you try like this:
> >
> > /solr/live/stream?expr=leftOuterJoin(search(archive,
> > q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> > asc"),search(live, q="posting_id:41009261", qt="/select",
> fl="posting_id",
> > sort="posting_id asc"),on="posting_id")
> >
> > Also don’t forget to urlencode special chars if your http client is not
> > doing it automatically for you.
> >
> > Sent from Mail for Windows 10
> >
> > From: Anuj Bhargava
> > Sent: 02 May 2021 07:40
> > To: users@solr.apache.org
> > Subject: Re: Solr 8.6.2 - single query on 2 cores ?
> >
> > Thanks. How can I use it in URL. Have tried the following -
> >
> > *Try -1*
> > *
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
> > <
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
> > >,
> > q="posting_id:44605514", qt="/select", fl="posting_id", sort="posting_id
> > asc"),search(live, q="posting_id:44605514", qt="/select",
> fl="posting_id",
> > sort="posting_id asc")on="posting_id")*
> >
> > *Result -1*
> > *{*
> > * "responseHeader":{*
> > * "status":0,*
> > * "QTime":0,*
> > * "params":{*
> > * "leftOuterJoin(search(archive, q":"\"posting_id:44605514\",
> > qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
> > q=\"posting_id:44605514\", qt=\"/select\", fl=\"posting_id\",
> > sort=\"posting_id asc\")on=\"posting_id\")"}},*
> > * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> > * }}*
> >
> > Try -2
> >
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive,
> > q="*:*", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live,
> > q="*:*", qt="/select", fl="posting_id", sort="posting_id
> > asc")on="posting_id=44605514")
> >
> > Result -2
> > {
> > "responseHeader":{
> > "status":0,
> > "QTime":0,
> > "params":{
> > "leftOuterJoin(search(archive, q":"\"*:*\", qt=\"/select\",
> > fl=\"posting_id\", sort=\"posting_id asc\"),search(live, q=\"*:*\",
> > qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
> > asc\")on=\"posting_id=44605514\")"}},
> > "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]
> > }}
> >
> > *Try -3*
> > *
> >
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
> > <
> >
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
> > >,
> > q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> > asc"),search(live, q="posting_id:41009261", qt="/select",
> fl="posting_id",
> > sort="posting_id asc"),on="posting_id")*
> >
> > *Result-3*
> > *{*
> > * "responseHeader":{*
> > * "status":0,*
> > * "QTime":0,*
> > * "params":{*
> > * "expr":"leftOuterJoin(search(archive, q=\"posting_id:41009261\",
> > qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
> > q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
> > sort=\"posting_id asc\"),on=\"posting_id\")"}},*
> > * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> > * }}*
> >
> >
> > *Try -4*
> > *
> >
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
> > <
> >
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
> > >,
> > fl=posting_id),on=posting_id)*
> >
> > *Result-4*
> > *{*
> > * "responseHeader":{*
> > * "status":0,*
> > * "QTime":0,*
> > * "params":{*
> > *
> >
> >
> "expr":"leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261,
> > fl=posting_id),on=posting_id)"}},*
> > * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> > * }}*
> >
> > *Try -5*
> > *
> >
> http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
> > <
> >
> http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
> > >,
> > q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> > asc"),search(live, q="posting_id:41009261", qt="/select",
> fl="posting_id",
> > sort="posting_id asc"),on="posting_id"*
> >
> > *Result -5*
> > *{*
> > * "result-set":{*
> > * "docs":[{*
> > * "EXCEPTION":"'leftOuterJoin(search(archive,
> > q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
> > sort=\"posting_id asc\"),search(live, q=\"posting_id:41009261\",
> > qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
> > asc\"),on=\"posting_id\"' is not a proper expression clause",*
> > * "EOF":true}]}}*
> >
> >
> > On Sat, 1 May 2021 at 04:14, ufuk yılmaz <uy...@vivaldi.net.invalid>
> > wrote:
> >
> > > Hi Anuj,
> > >
> > > First solution that comes to my mind is using streaming expressions.
> > >
> > > leftOuterJoin can do this:
> > >
> > >
> > >
> >
> https://solr.apache.org/guide/8_6/stream-decorator-reference.html#leftouterjoin
> > >
> > > Example:
> > >
> > > leftOuterJoin(
> > > search(archive, q=”postings_id:123”, qt=”/select”,
> > > fl=”postings_id”, sort=”postings_id asc”)
> > > search(live, q=”postings_id:123”, qt=”/select”,
> fl=”postings_id”,
> > > sort=”postings_id asc”)
> > > on=”postings_id”
> > > )
> > >
> > > If a document with postings_id:123 is found on live, it is used,
> > otherwise
> > > document from archive collection is returned because documents from
> > “right”
> > > (live) overwrites values onto “left” (archive). Add other required
> fields
> > > to fl parameter.
> > >
> > > Hope it helps
> > >
> > > Sent from Mail for Windows 10
> > >
> > > From: Anuj Bhargava
> > > Sent: 30 April 2021 16:25
> > > To: solr-user@lucene.apache.org
> > > Subject: Solr 8.6.2 - single query on 2 cores ?
> > >
> > > I have 2 cores '*live*' and '*archive*' with exactly the same fields.
> > >
> > > I want to query on a unique id - '*posting_id*'. First it should check
> > > *live* and if not found then in *archive* and show the results.
> > >
> > > The following is doing a search on *live* and not on *archive*
> > >
> > >
> >
> http://xxx:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=archive
> > >
> > > The following gives an error -
> > >
> > >
> >
> http://xxx.yyy.zzz.aaa:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=xxx.yyy.zzz.aaa:8983/solr/archive
> > >
> > > <response>
> > > <lst name="responseHeader">
> > > <int name="status">401</int>
> > > <int name="QTime">10</int>
> > > <lst name="params">
> > > <str name="q">*:*</str>
> > > <str name="shards">xxx.yyy.zzz.aaa:8983/solr/archive</str>
> > > <str name="indent">true</str>
> > > <str name="fq">posting_id:41009261</str>
> > > <str name="wt">xml</str>
> > > </lst>
> > > </lst>
> > > <lst name="error">
> > > <lst name="metadata">
> > > <str
> > >
> > >
> >
> name="error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> > > <str
> > >
> > >
> >
> name="root-error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> > > </lst>
> > > <str name="msg">Error from server at null: Expected mime type
> > > application/octet-stream but got text/html. <html> <head> <meta
> > > http-equiv="Content-Type" content="text/html;charset=utf-8"/>
> > <title>Error
> > > 401 Unauthorized</title> </head> <body><h2>HTTP ERROR 401
> > Unauthorized</h2>
> > > <table> <tr><th>URI:</th><td>/solr/archive/select</td></tr>
> > > <tr><th>STATUS:</th><td>401</td></tr>
> > > <tr><th>MESSAGE:</th><td>Unauthorized</td></tr>
> > > <tr><th>SERVLET:</th><td>default</td></tr> </table> </body> </html>
> > </str>
> > > <int name="code">401</int>
> > > </lst>
> > > </response>
> > >
> > > How can I do a single query on 2 cores
> > >
> > > Have added the following in solr.in.sh - SOLR_OPTS="$SOLR_OPTS
> > > -Dsolr.disable.shardsWhitelist=true"
> > >
> > >
> >
> >
>
>
RE: Solr 8.6.2 - single query on 2 cores ?
Posted by ufuk yılmaz <uy...@vivaldi.net.INVALID>.
My quess is that it’s not related to streaming expression. Are you running solr in cloud mode? Any problems with your zookeeper?
Can you run the expression in solr admin ui? Select any collection and choose stream from the left
Can you run this very simple expression: echo("Hello World")
Sent from Mail for Windows 10
From: Anuj Bhargava
Sent: 02 May 2021 14:21
To: users@solr.apache.org
Subject: Re: Solr 8.6.2 - single query on 2 cores ?
Hi,
Got the following message -
{
"result-set":{
"docs":[{
"EXCEPTION":"java.util.concurrent.TimeoutException: Could not
connect to ZooKeeper null within 15000 ms",
"EOF":true,
"RESPONSE_TIME":15512}]}}
Regards,
Anuj
On Sun, 2 May 2021 at 16:36, ufuk yılmaz <uy...@vivaldi.net.invalid>
wrote:
> Hi, can you try like this:
>
> /solr/live/stream?expr=leftOuterJoin(search(archive,
> q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
> sort="posting_id asc"),on="posting_id")
>
> Also don’t forget to urlencode special chars if your http client is not
> doing it automatically for you.
>
> Sent from Mail for Windows 10
>
> From: Anuj Bhargava
> Sent: 02 May 2021 07:40
> To: users@solr.apache.org
> Subject: Re: Solr 8.6.2 - single query on 2 cores ?
>
> Thanks. How can I use it in URL. Have tried the following -
>
> *Try -1*
> *http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
> <http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
> >,
> q="posting_id:44605514", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:44605514", qt="/select", fl="posting_id",
> sort="posting_id asc")on="posting_id")*
>
> *Result -1*
> *{*
> * "responseHeader":{*
> * "status":0,*
> * "QTime":0,*
> * "params":{*
> * "leftOuterJoin(search(archive, q":"\"posting_id:44605514\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
> q=\"posting_id:44605514\", qt=\"/select\", fl=\"posting_id\",
> sort=\"posting_id asc\")on=\"posting_id\")"}},*
> * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> * }}*
>
> Try -2
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive,
> q="*:*", qt="/select", fl="posting_id", sort="posting_id asc"),search(live,
> q="*:*", qt="/select", fl="posting_id", sort="posting_id
> asc")on="posting_id=44605514")
>
> Result -2
> {
> "responseHeader":{
> "status":0,
> "QTime":0,
> "params":{
> "leftOuterJoin(search(archive, q":"\"*:*\", qt=\"/select\",
> fl=\"posting_id\", sort=\"posting_id asc\"),search(live, q=\"*:*\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
> asc\")on=\"posting_id=44605514\")"}},
> "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]
> }}
>
> *Try -3*
> *
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
> <
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
> >,
> q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
> sort="posting_id asc"),on="posting_id")*
>
> *Result-3*
> *{*
> * "responseHeader":{*
> * "status":0,*
> * "QTime":0,*
> * "params":{*
> * "expr":"leftOuterJoin(search(archive, q=\"posting_id:41009261\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
> q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
> sort=\"posting_id asc\"),on=\"posting_id\")"}},*
> * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> * }}*
>
>
> *Try -4*
> *
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
> <
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
> >,
> fl=posting_id),on=posting_id)*
>
> *Result-4*
> *{*
> * "responseHeader":{*
> * "status":0,*
> * "QTime":0,*
> * "params":{*
> *
>
> "expr":"leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261,
> fl=posting_id),on=posting_id)"}},*
> * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> * }}*
>
> *Try -5*
> *
> http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
> <
> http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
> >,
> q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
> sort="posting_id asc"),on="posting_id"*
>
> *Result -5*
> *{*
> * "result-set":{*
> * "docs":[{*
> * "EXCEPTION":"'leftOuterJoin(search(archive,
> q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
> sort=\"posting_id asc\"),search(live, q=\"posting_id:41009261\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
> asc\"),on=\"posting_id\"' is not a proper expression clause",*
> * "EOF":true}]}}*
>
>
> On Sat, 1 May 2021 at 04:14, ufuk yılmaz <uy...@vivaldi.net.invalid>
> wrote:
>
> > Hi Anuj,
> >
> > First solution that comes to my mind is using streaming expressions.
> >
> > leftOuterJoin can do this:
> >
> >
> >
> https://solr.apache.org/guide/8_6/stream-decorator-reference.html#leftouterjoin
> >
> > Example:
> >
> > leftOuterJoin(
> > search(archive, q=”postings_id:123”, qt=”/select”,
> > fl=”postings_id”, sort=”postings_id asc”)
> > search(live, q=”postings_id:123”, qt=”/select”, fl=”postings_id”,
> > sort=”postings_id asc”)
> > on=”postings_id”
> > )
> >
> > If a document with postings_id:123 is found on live, it is used,
> otherwise
> > document from archive collection is returned because documents from
> “right”
> > (live) overwrites values onto “left” (archive). Add other required fields
> > to fl parameter.
> >
> > Hope it helps
> >
> > Sent from Mail for Windows 10
> >
> > From: Anuj Bhargava
> > Sent: 30 April 2021 16:25
> > To: solr-user@lucene.apache.org
> > Subject: Solr 8.6.2 - single query on 2 cores ?
> >
> > I have 2 cores '*live*' and '*archive*' with exactly the same fields.
> >
> > I want to query on a unique id - '*posting_id*'. First it should check
> > *live* and if not found then in *archive* and show the results.
> >
> > The following is doing a search on *live* and not on *archive*
> >
> >
> http://xxx:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=archive
> >
> > The following gives an error -
> >
> >
> http://xxx.yyy.zzz.aaa:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=xxx.yyy.zzz.aaa:8983/solr/archive
> >
> > <response>
> > <lst name="responseHeader">
> > <int name="status">401</int>
> > <int name="QTime">10</int>
> > <lst name="params">
> > <str name="q">*:*</str>
> > <str name="shards">xxx.yyy.zzz.aaa:8983/solr/archive</str>
> > <str name="indent">true</str>
> > <str name="fq">posting_id:41009261</str>
> > <str name="wt">xml</str>
> > </lst>
> > </lst>
> > <lst name="error">
> > <lst name="metadata">
> > <str
> >
> >
> name="error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> > <str
> >
> >
> name="root-error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> > </lst>
> > <str name="msg">Error from server at null: Expected mime type
> > application/octet-stream but got text/html. <html> <head> <meta
> > http-equiv="Content-Type" content="text/html;charset=utf-8"/>
> <title>Error
> > 401 Unauthorized</title> </head> <body><h2>HTTP ERROR 401
> Unauthorized</h2>
> > <table> <tr><th>URI:</th><td>/solr/archive/select</td></tr>
> > <tr><th>STATUS:</th><td>401</td></tr>
> > <tr><th>MESSAGE:</th><td>Unauthorized</td></tr>
> > <tr><th>SERVLET:</th><td>default</td></tr> </table> </body> </html>
> </str>
> > <int name="code">401</int>
> > </lst>
> > </response>
> >
> > How can I do a single query on 2 cores
> >
> > Have added the following in solr.in.sh - SOLR_OPTS="$SOLR_OPTS
> > -Dsolr.disable.shardsWhitelist=true"
> >
> >
>
>
Re: Solr 8.6.2 - single query on 2 cores ?
Posted by Anuj Bhargava <an...@gmail.com>.
Hi,
Got the following message -
{
"result-set":{
"docs":[{
"EXCEPTION":"java.util.concurrent.TimeoutException: Could not
connect to ZooKeeper null within 15000 ms",
"EOF":true,
"RESPONSE_TIME":15512}]}}
Regards,
Anuj
On Sun, 2 May 2021 at 16:36, ufuk yılmaz <uy...@vivaldi.net.invalid>
wrote:
> Hi, can you try like this:
>
> /solr/live/stream?expr=leftOuterJoin(search(archive,
> q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
> sort="posting_id asc"),on="posting_id")
>
> Also don’t forget to urlencode special chars if your http client is not
> doing it automatically for you.
>
> Sent from Mail for Windows 10
>
> From: Anuj Bhargava
> Sent: 02 May 2021 07:40
> To: users@solr.apache.org
> Subject: Re: Solr 8.6.2 - single query on 2 cores ?
>
> Thanks. How can I use it in URL. Have tried the following -
>
> *Try -1*
> *http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
> <http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
> >,
> q="posting_id:44605514", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:44605514", qt="/select", fl="posting_id",
> sort="posting_id asc")on="posting_id")*
>
> *Result -1*
> *{*
> * "responseHeader":{*
> * "status":0,*
> * "QTime":0,*
> * "params":{*
> * "leftOuterJoin(search(archive, q":"\"posting_id:44605514\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
> q=\"posting_id:44605514\", qt=\"/select\", fl=\"posting_id\",
> sort=\"posting_id asc\")on=\"posting_id\")"}},*
> * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> * }}*
>
> Try -2
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive,
> q="*:*", qt="/select", fl="posting_id", sort="posting_id asc"),search(live,
> q="*:*", qt="/select", fl="posting_id", sort="posting_id
> asc")on="posting_id=44605514")
>
> Result -2
> {
> "responseHeader":{
> "status":0,
> "QTime":0,
> "params":{
> "leftOuterJoin(search(archive, q":"\"*:*\", qt=\"/select\",
> fl=\"posting_id\", sort=\"posting_id asc\"),search(live, q=\"*:*\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
> asc\")on=\"posting_id=44605514\")"}},
> "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]
> }}
>
> *Try -3*
> *
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
> <
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
> >,
> q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
> sort="posting_id asc"),on="posting_id")*
>
> *Result-3*
> *{*
> * "responseHeader":{*
> * "status":0,*
> * "QTime":0,*
> * "params":{*
> * "expr":"leftOuterJoin(search(archive, q=\"posting_id:41009261\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
> q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
> sort=\"posting_id asc\"),on=\"posting_id\")"}},*
> * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> * }}*
>
>
> *Try -4*
> *
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
> <
> http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
> >,
> fl=posting_id),on=posting_id)*
>
> *Result-4*
> *{*
> * "responseHeader":{*
> * "status":0,*
> * "QTime":0,*
> * "params":{*
> *
>
> "expr":"leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261,
> fl=posting_id),on=posting_id)"}},*
> * "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
> * }}*
>
> *Try -5*
> *
> http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
> <
> http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
> >,
> q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
> asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
> sort="posting_id asc"),on="posting_id"*
>
> *Result -5*
> *{*
> * "result-set":{*
> * "docs":[{*
> * "EXCEPTION":"'leftOuterJoin(search(archive,
> q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
> sort=\"posting_id asc\"),search(live, q=\"posting_id:41009261\",
> qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
> asc\"),on=\"posting_id\"' is not a proper expression clause",*
> * "EOF":true}]}}*
>
>
> On Sat, 1 May 2021 at 04:14, ufuk yılmaz <uy...@vivaldi.net.invalid>
> wrote:
>
> > Hi Anuj,
> >
> > First solution that comes to my mind is using streaming expressions.
> >
> > leftOuterJoin can do this:
> >
> >
> >
> https://solr.apache.org/guide/8_6/stream-decorator-reference.html#leftouterjoin
> >
> > Example:
> >
> > leftOuterJoin(
> > search(archive, q=”postings_id:123”, qt=”/select”,
> > fl=”postings_id”, sort=”postings_id asc”)
> > search(live, q=”postings_id:123”, qt=”/select”, fl=”postings_id”,
> > sort=”postings_id asc”)
> > on=”postings_id”
> > )
> >
> > If a document with postings_id:123 is found on live, it is used,
> otherwise
> > document from archive collection is returned because documents from
> “right”
> > (live) overwrites values onto “left” (archive). Add other required fields
> > to fl parameter.
> >
> > Hope it helps
> >
> > Sent from Mail for Windows 10
> >
> > From: Anuj Bhargava
> > Sent: 30 April 2021 16:25
> > To: solr-user@lucene.apache.org
> > Subject: Solr 8.6.2 - single query on 2 cores ?
> >
> > I have 2 cores '*live*' and '*archive*' with exactly the same fields.
> >
> > I want to query on a unique id - '*posting_id*'. First it should check
> > *live* and if not found then in *archive* and show the results.
> >
> > The following is doing a search on *live* and not on *archive*
> >
> >
> http://xxx:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=archive
> >
> > The following gives an error -
> >
> >
> http://xxx.yyy.zzz.aaa:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=xxx.yyy.zzz.aaa:8983/solr/archive
> >
> > <response>
> > <lst name="responseHeader">
> > <int name="status">401</int>
> > <int name="QTime">10</int>
> > <lst name="params">
> > <str name="q">*:*</str>
> > <str name="shards">xxx.yyy.zzz.aaa:8983/solr/archive</str>
> > <str name="indent">true</str>
> > <str name="fq">posting_id:41009261</str>
> > <str name="wt">xml</str>
> > </lst>
> > </lst>
> > <lst name="error">
> > <lst name="metadata">
> > <str
> >
> >
> name="error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> > <str
> >
> >
> name="root-error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> > </lst>
> > <str name="msg">Error from server at null: Expected mime type
> > application/octet-stream but got text/html. <html> <head> <meta
> > http-equiv="Content-Type" content="text/html;charset=utf-8"/>
> <title>Error
> > 401 Unauthorized</title> </head> <body><h2>HTTP ERROR 401
> Unauthorized</h2>
> > <table> <tr><th>URI:</th><td>/solr/archive/select</td></tr>
> > <tr><th>STATUS:</th><td>401</td></tr>
> > <tr><th>MESSAGE:</th><td>Unauthorized</td></tr>
> > <tr><th>SERVLET:</th><td>default</td></tr> </table> </body> </html>
> </str>
> > <int name="code">401</int>
> > </lst>
> > </response>
> >
> > How can I do a single query on 2 cores
> >
> > Have added the following in solr.in.sh - SOLR_OPTS="$SOLR_OPTS
> > -Dsolr.disable.shardsWhitelist=true"
> >
> >
>
>
RE: Solr 8.6.2 - single query on 2 cores ?
Posted by ufuk yılmaz <uy...@vivaldi.net.INVALID>.
Hi, can you try like this:
/solr/live/stream?expr=leftOuterJoin(search(archive, q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id asc"),on="posting_id")
Also don’t forget to urlencode special chars if your http client is not doing it automatically for you.
Sent from Mail for Windows 10
From: Anuj Bhargava
Sent: 02 May 2021 07:40
To: users@solr.apache.org
Subject: Re: Solr 8.6.2 - single query on 2 cores ?
Thanks. How can I use it in URL. Have tried the following -
*Try -1*
*http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
<http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive>,
q="posting_id:44605514", qt="/select", fl="posting_id", sort="posting_id
asc"),search(live, q="posting_id:44605514", qt="/select", fl="posting_id",
sort="posting_id asc")on="posting_id")*
*Result -1*
*{*
* "responseHeader":{*
* "status":0,*
* "QTime":0,*
* "params":{*
* "leftOuterJoin(search(archive, q":"\"posting_id:44605514\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
q=\"posting_id:44605514\", qt=\"/select\", fl=\"posting_id\",
sort=\"posting_id asc\")on=\"posting_id\")"}},*
* "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
* }}*
Try -2
http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive,
q="*:*", qt="/select", fl="posting_id", sort="posting_id asc"),search(live,
q="*:*", qt="/select", fl="posting_id", sort="posting_id
asc")on="posting_id=44605514")
Result -2
{
"responseHeader":{
"status":0,
"QTime":0,
"params":{
"leftOuterJoin(search(archive, q":"\"*:*\", qt=\"/select\",
fl=\"posting_id\", sort=\"posting_id asc\"),search(live, q=\"*:*\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
asc\")on=\"posting_id=44605514\")"}},
"response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]
}}
*Try -3*
*http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
<http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive>,
q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
sort="posting_id asc"),on="posting_id")*
*Result-3*
*{*
* "responseHeader":{*
* "status":0,*
* "QTime":0,*
* "params":{*
* "expr":"leftOuterJoin(search(archive, q=\"posting_id:41009261\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
sort=\"posting_id asc\"),on=\"posting_id\")"}},*
* "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
* }}*
*Try -4*
*http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
<http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261>,
fl=posting_id),on=posting_id)*
*Result-4*
*{*
* "responseHeader":{*
* "status":0,*
* "QTime":0,*
* "params":{*
*
"expr":"leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261,
fl=posting_id),on=posting_id)"}},*
* "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
* }}*
*Try -5*
*http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
<http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive>,
q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
sort="posting_id asc"),on="posting_id"*
*Result -5*
*{*
* "result-set":{*
* "docs":[{*
* "EXCEPTION":"'leftOuterJoin(search(archive,
q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
sort=\"posting_id asc\"),search(live, q=\"posting_id:41009261\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
asc\"),on=\"posting_id\"' is not a proper expression clause",*
* "EOF":true}]}}*
On Sat, 1 May 2021 at 04:14, ufuk yılmaz <uy...@vivaldi.net.invalid>
wrote:
> Hi Anuj,
>
> First solution that comes to my mind is using streaming expressions.
>
> leftOuterJoin can do this:
>
>
> https://solr.apache.org/guide/8_6/stream-decorator-reference.html#leftouterjoin
>
> Example:
>
> leftOuterJoin(
> search(archive, q=”postings_id:123”, qt=”/select”,
> fl=”postings_id”, sort=”postings_id asc”)
> search(live, q=”postings_id:123”, qt=”/select”, fl=”postings_id”,
> sort=”postings_id asc”)
> on=”postings_id”
> )
>
> If a document with postings_id:123 is found on live, it is used, otherwise
> document from archive collection is returned because documents from “right”
> (live) overwrites values onto “left” (archive). Add other required fields
> to fl parameter.
>
> Hope it helps
>
> Sent from Mail for Windows 10
>
> From: Anuj Bhargava
> Sent: 30 April 2021 16:25
> To: solr-user@lucene.apache.org
> Subject: Solr 8.6.2 - single query on 2 cores ?
>
> I have 2 cores '*live*' and '*archive*' with exactly the same fields.
>
> I want to query on a unique id - '*posting_id*'. First it should check
> *live* and if not found then in *archive* and show the results.
>
> The following is doing a search on *live* and not on *archive*
>
> http://xxx:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=archive
>
> The following gives an error -
>
> http://xxx.yyy.zzz.aaa:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=xxx.yyy.zzz.aaa:8983/solr/archive
>
> <response>
> <lst name="responseHeader">
> <int name="status">401</int>
> <int name="QTime">10</int>
> <lst name="params">
> <str name="q">*:*</str>
> <str name="shards">xxx.yyy.zzz.aaa:8983/solr/archive</str>
> <str name="indent">true</str>
> <str name="fq">posting_id:41009261</str>
> <str name="wt">xml</str>
> </lst>
> </lst>
> <lst name="error">
> <lst name="metadata">
> <str
>
> name="error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> <str
>
> name="root-error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> </lst>
> <str name="msg">Error from server at null: Expected mime type
> application/octet-stream but got text/html. <html> <head> <meta
> http-equiv="Content-Type" content="text/html;charset=utf-8"/> <title>Error
> 401 Unauthorized</title> </head> <body><h2>HTTP ERROR 401 Unauthorized</h2>
> <table> <tr><th>URI:</th><td>/solr/archive/select</td></tr>
> <tr><th>STATUS:</th><td>401</td></tr>
> <tr><th>MESSAGE:</th><td>Unauthorized</td></tr>
> <tr><th>SERVLET:</th><td>default</td></tr> </table> </body> </html> </str>
> <int name="code">401</int>
> </lst>
> </response>
>
> How can I do a single query on 2 cores
>
> Have added the following in solr.in.sh - SOLR_OPTS="$SOLR_OPTS
> -Dsolr.disable.shardsWhitelist=true"
>
>
Re: Solr 8.6.2 - single query on 2 cores ?
Posted by Anuj Bhargava <an...@gmail.com>.
Thanks. How can I use it in URL. Have tried the following -
*Try -1*
*http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive
<http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive>,
q="posting_id:44605514", qt="/select", fl="posting_id", sort="posting_id
asc"),search(live, q="posting_id:44605514", qt="/select", fl="posting_id",
sort="posting_id asc")on="posting_id")*
*Result -1*
*{*
* "responseHeader":{*
* "status":0,*
* "QTime":0,*
* "params":{*
* "leftOuterJoin(search(archive, q":"\"posting_id:44605514\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
q=\"posting_id:44605514\", qt=\"/select\", fl=\"posting_id\",
sort=\"posting_id asc\")on=\"posting_id\")"}},*
* "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
* }}*
Try -2
http://aaa.bbb.ccc.ddd:8983/solr/live/select?leftOuterJoin(search(archive,
q="*:*", qt="/select", fl="posting_id", sort="posting_id asc"),search(live,
q="*:*", qt="/select", fl="posting_id", sort="posting_id
asc")on="posting_id=44605514")
Result -2
{
"responseHeader":{
"status":0,
"QTime":0,
"params":{
"leftOuterJoin(search(archive, q":"\"*:*\", qt=\"/select\",
fl=\"posting_id\", sort=\"posting_id asc\"),search(live, q=\"*:*\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
asc\")on=\"posting_id=44605514\")"}},
"response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]
}}
*Try -3*
*http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive
<http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive>,
q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
sort="posting_id asc"),on="posting_id")*
*Result-3*
*{*
* "responseHeader":{*
* "status":0,*
* "QTime":0,*
* "params":{*
* "expr":"leftOuterJoin(search(archive, q=\"posting_id:41009261\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id asc\"),search(live,
q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
sort=\"posting_id asc\"),on=\"posting_id\")"}},*
* "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
* }}*
*Try -4*
*http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261
<http://aaa.bbb.ccc.ddd:8983/solr/live/select?expr=leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261>,
fl=posting_id),on=posting_id)*
*Result-4*
*{*
* "responseHeader":{*
* "status":0,*
* "QTime":0,*
* "params":{*
*
"expr":"leftOuterJoin(search(archive,q=posting_id:41009261,fl=posting_id),search(live,q=posting_id:41009261,
fl=posting_id),on=posting_id)"}},*
* "response":{"numFound":0,"start":0,"numFoundExact":true,"docs":[]*
* }}*
*Try -5*
*http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive
<http://aaa.bbb.ccc.ddd:8983/solr/live/stream?expr=leftOuterJoin(search(archive>,
q="posting_id:41009261", qt="/select", fl="posting_id", sort="posting_id
asc"),search(live, q="posting_id:41009261", qt="/select", fl="posting_id",
sort="posting_id asc"),on="posting_id"*
*Result -5*
*{*
* "result-set":{*
* "docs":[{*
* "EXCEPTION":"'leftOuterJoin(search(archive,
q=\"posting_id:41009261\", qt=\"/select\", fl=\"posting_id\",
sort=\"posting_id asc\"),search(live, q=\"posting_id:41009261\",
qt=\"/select\", fl=\"posting_id\", sort=\"posting_id
asc\"),on=\"posting_id\"' is not a proper expression clause",*
* "EOF":true}]}}*
On Sat, 1 May 2021 at 04:14, ufuk yılmaz <uy...@vivaldi.net.invalid>
wrote:
> Hi Anuj,
>
> First solution that comes to my mind is using streaming expressions.
>
> leftOuterJoin can do this:
>
>
> https://solr.apache.org/guide/8_6/stream-decorator-reference.html#leftouterjoin
>
> Example:
>
> leftOuterJoin(
> search(archive, q=”postings_id:123”, qt=”/select”,
> fl=”postings_id”, sort=”postings_id asc”)
> search(live, q=”postings_id:123”, qt=”/select”, fl=”postings_id”,
> sort=”postings_id asc”)
> on=”postings_id”
> )
>
> If a document with postings_id:123 is found on live, it is used, otherwise
> document from archive collection is returned because documents from “right”
> (live) overwrites values onto “left” (archive). Add other required fields
> to fl parameter.
>
> Hope it helps
>
> Sent from Mail for Windows 10
>
> From: Anuj Bhargava
> Sent: 30 April 2021 16:25
> To: solr-user@lucene.apache.org
> Subject: Solr 8.6.2 - single query on 2 cores ?
>
> I have 2 cores '*live*' and '*archive*' with exactly the same fields.
>
> I want to query on a unique id - '*posting_id*'. First it should check
> *live* and if not found then in *archive* and show the results.
>
> The following is doing a search on *live* and not on *archive*
>
> http://xxx:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=archive
>
> The following gives an error -
>
> http://xxx.yyy.zzz.aaa:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=xxx.yyy.zzz.aaa:8983/solr/archive
>
> <response>
> <lst name="responseHeader">
> <int name="status">401</int>
> <int name="QTime">10</int>
> <lst name="params">
> <str name="q">*:*</str>
> <str name="shards">xxx.yyy.zzz.aaa:8983/solr/archive</str>
> <str name="indent">true</str>
> <str name="fq">posting_id:41009261</str>
> <str name="wt">xml</str>
> </lst>
> </lst>
> <lst name="error">
> <lst name="metadata">
> <str
>
> name="error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> <str
>
> name="root-error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
> </lst>
> <str name="msg">Error from server at null: Expected mime type
> application/octet-stream but got text/html. <html> <head> <meta
> http-equiv="Content-Type" content="text/html;charset=utf-8"/> <title>Error
> 401 Unauthorized</title> </head> <body><h2>HTTP ERROR 401 Unauthorized</h2>
> <table> <tr><th>URI:</th><td>/solr/archive/select</td></tr>
> <tr><th>STATUS:</th><td>401</td></tr>
> <tr><th>MESSAGE:</th><td>Unauthorized</td></tr>
> <tr><th>SERVLET:</th><td>default</td></tr> </table> </body> </html> </str>
> <int name="code">401</int>
> </lst>
> </response>
>
> How can I do a single query on 2 cores
>
> Have added the following in solr.in.sh - SOLR_OPTS="$SOLR_OPTS
> -Dsolr.disable.shardsWhitelist=true"
>
>
RE: Solr 8.6.2 - single query on 2 cores ?
Posted by ufuk yılmaz <uy...@vivaldi.net.INVALID>.
Hi Anuj,
First solution that comes to my mind is using streaming expressions.
leftOuterJoin can do this:
https://solr.apache.org/guide/8_6/stream-decorator-reference.html#leftouterjoin
Example:
leftOuterJoin(
search(archive, q=”postings_id:123”, qt=”/select”, fl=”postings_id”, sort=”postings_id asc”)
search(live, q=”postings_id:123”, qt=”/select”, fl=”postings_id”, sort=”postings_id asc”)
on=”postings_id”
)
If a document with postings_id:123 is found on live, it is used, otherwise document from archive collection is returned because documents from “right” (live) overwrites values onto “left” (archive). Add other required fields to fl parameter.
Hope it helps
Sent from Mail for Windows 10
From: Anuj Bhargava
Sent: 30 April 2021 16:25
To: solr-user@lucene.apache.org
Subject: Solr 8.6.2 - single query on 2 cores ?
I have 2 cores '*live*' and '*archive*' with exactly the same fields.
I want to query on a unique id - '*posting_id*'. First it should check
*live* and if not found then in *archive* and show the results.
The following is doing a search on *live* and not on *archive*
http://xxx:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=archive
The following gives an error -
http://xxx.yyy.zzz.aaa:8983/solr/live/select?q=*:*&fq=posting_id:41009261&indent=true&shards=xxx.yyy.zzz.aaa:8983/solr/archive
<response>
<lst name="responseHeader">
<int name="status">401</int>
<int name="QTime">10</int>
<lst name="params">
<str name="q">*:*</str>
<str name="shards">xxx.yyy.zzz.aaa:8983/solr/archive</str>
<str name="indent">true</str>
<str name="fq">posting_id:41009261</str>
<str name="wt">xml</str>
</lst>
</lst>
<lst name="error">
<lst name="metadata">
<str
name="error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
<str
name="root-error-class">org.apache.solr.client.solrj.impl.BaseHttpSolrClient$RemoteSolrException</str>
</lst>
<str name="msg">Error from server at null: Expected mime type
application/octet-stream but got text/html. <html> <head> <meta
http-equiv="Content-Type" content="text/html;charset=utf-8"/> <title>Error
401 Unauthorized</title> </head> <body><h2>HTTP ERROR 401 Unauthorized</h2>
<table> <tr><th>URI:</th><td>/solr/archive/select</td></tr>
<tr><th>STATUS:</th><td>401</td></tr>
<tr><th>MESSAGE:</th><td>Unauthorized</td></tr>
<tr><th>SERVLET:</th><td>default</td></tr> </table> </body> </html> </str>
<int name="code">401</int>
</lst>
</response>
How can I do a single query on 2 cores
Have added the following in solr.in.sh - SOLR_OPTS="$SOLR_OPTS
-Dsolr.disable.shardsWhitelist=true"