RE: Solr 8.6.2 - single query on 2 cores ?

2021-05-02 Thread ufuk yılmaz
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
,
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
,
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
,
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
,
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 
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
>
> Fro

Re: Solr 8.6.2 - single query on 2 cores ?

2021-05-02 Thread Anuj Bhargava
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 
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
>  >,
> 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 
> 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:

Re: [VOTE] Solr Operator Logo

2021-05-02 Thread David Smiley
L-3
I-3

They are all pretty good so I'll just pick my favorite. I'm not sure if
there's a possible trademark issue with including another project's logo
(k8s) inside Solr so I like that L-3 merely chooses the navigation wheel
aspect.  It also reads clearly as an "o" for Solr.

(Binding vote)

~ David Smiley
Apache Lucene/Solr Search Developer
http://www.linkedin.com/in/davidwsmiley


On Tue, Apr 27, 2021 at 5:00 PM Houston Putman  wrote:

> Hello Solr users & devs,
>
> The Solr Operator is the first subproject under Apache Solr and thus needs
> a distinguishing logo.
>
> We have multiple options to choose from for both the Solr Operator logo and
> icon. These designs have been based off of the Solr and Kubernetes logos:
>
>- https://solr.apache.org/logos-and-assets.html
>- https://github.com/kubernetes/kubernetes/tree/master/logo
>
> The winning Logo and Icon will be finalized with dark & light options, in
> SVG format after they are selected. So please don't factor in blurry lines
> into your vote.
>
> *Please read the following rules carefully* before submitting your vote.
>
> *Who can vote?*
>
> Anyone is welcome to cast a vote in support of their favorite
> submission(s). Note that only Solr PMC member's votes are binding. If you
> are a Solr PMC member, please indicate with your vote that the vote is
> binding, to ease collection of votes. In tallying the votes, I will attempt
> to verify only those marked as binding.
>
>
> *How do I vote?*
> Votes can be cast simply by replying to this email. It is a ranked-choice
> vote [rank-choice-voting]. Multiple selections may be made, where the order
> of preference must be specified. If an entry gets more than half the votes,
> it is the winner. Otherwise, the entry with the lowest number of votes is
> removed, and the votes are retallied, taking into account the next
> preferred entry for those whose first entry was removed. This process
> repeats until there is a winner.
>
> The entries are broken up by type, then entry. The entry identifiers are
> first either "L" for logo or "I" for icon, followed by an id for that
> entry. You can vote for multiple entries, with your highest preference
> sorted first.
>
> Please vote for the logo and icon separately.
>
> (binding)
> logo vote: L-1, L-3, L-4
> icon vote: I-3, I-2
>
> *Entries*
>
> All entries are submitted by Mona Chang.
>
> The entries are as follows:
>
> Logos:
>
> [L-1]
>
> https://user-images.githubusercontent.com/64094885/116154447-49f14100-a6ae-11eb-9d05-b4fa7aeb94e6.png
> [L-2]
>
> https://user-images.githubusercontent.com/64094885/116311387-d19f8400-a770-11eb-96da-65891a6df5aa.png
> L-2 is merely an alternative color for L-1.
> [L-3]
>
> https://user-images.githubusercontent.com/64094885/116153995-bf104680-a6ad-11eb-8fee-c29d4612a86c.png
> [L-4]
>
> https://user-images.githubusercontent.com/64094885/116154426-452c8d00-a6ae-11eb-8dc2-080d7b5e04af.png
>
> Icons:
>
> All icons are similar, with different colors and gradients used.
>
> [I-1]
>
> https://user-images.githubusercontent.com/64094885/114226789-ad9f0e80-9939-11eb-97d6-945bf79b8ce7.png
> [I-2]
>
> https://user-images.githubusercontent.com/64094885/116154026-c899ae80-a6ad-11eb-8e47-900adfde9654.png
> [I-3]
>
> https://user-images.githubusercontent.com/64094885/116311474-e9770800-a770-11eb-9402-74e6c1263290.png
> [I-4]
>
> https://user-images.githubusercontent.com/64094885/116154021-c6cfeb00-a6ad-11eb-83c6-384d66500f49.png
>
> Please vote for one logo and one icon from the above choices. This vote
> will close about one week from today, Tue, May 4, 2021 at 11:59PM.
>
> - Houston Putman
>
> This vote is based off of the Lucene logo contest, run by Ryan Ernst.
>


RE: Solr 8.6.2 - single query on 2 cores ?

2021-05-02 Thread ufuk yılmaz
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 
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
>  >,
> 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:410

Re: Solr 8.6.2 - single query on 2 cores ?

2021-05-02 Thread Anuj Bhargava
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 
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 
> 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":[