ilto:erickerick...@gmail.com]
> Sent: Monday, July 29, 2019 3:19 PM
> To: solr-user@lucene.apache.org
> Subject: Re: Solr join query
>
> Vadim:
>
> Are you using streaming or the special “cross collection” join that requires
> colocated collection?
>
> > On Jul
t's working pretty well
>
> --
> Vadim
>
>> -Original Message-
>> From: Rajdeep Sahoo [mailto:rajdeepsahoo2...@gmail.com]
>> Sent: Monday, July 22, 2019 9:19 PM
>> To: solr-user@lucene.apache.org
>> Subject: Solr join query
>>
>> Can we join two solr collection based on multivalued field.
>
e.apache.org
> Subject: Solr join query
>
> Can we join two solr collection based on multivalued field.
Can we join two solr collection based on multivalued field.
Hello.
There is no way to make it work fast. It executes expensive join operation
for all docs/terms and then post filters with resulting docset.
On Mon, Feb 5, 2018 at 9:53 AM, Aashish Agarwal wrote:
> Hi
>
> I am using join query that joins 2 cores to get result. Since, number of
> docs in bot
Hi
I am using join query that joins 2 cores to get result. Since, number of
docs in both the cores are too high so I want to use post filter with join
query. But that is not working by providing cost=100.
Is it implemented for join filter query? I use solr 4.6.0
Thanks,
Aashish
> I am reading similar issues and it says "initial join implementation is
O(nterms)".. What does this mean?
It enumerates all par_id terms every time. As an alternative for some of
field types you can add {!join ... score=none ...}.. to trigger Lucene's
join algorithm with O(fromDocs) ie if subord
First of all, Solr is a _search_ engine, it wasn't built to be an
RDBMS. Whenever I see this question (paraphrasing) "I've indexed my
tables and want to use Solr just like a DB" I cringe.
The join performance goes up with the number of unique values for the
join field. High-cardinality fields are
I am facing a performance problem and could narrow it down to a join query
that we are using. The join is on a unique field.
We have a person profile stored in RDB in a relational way. Like person
name table , address table etc. SOLR indexes are build using this RDB
data,Each children is stored as
You may want to look at fetch function of Streaming expressions
http://lucene.apache.org/solr/guide/6_6/stream-decorators.html
Thanks,
Susheel
On Tue, Sep 12, 2017 at 11:11 AM, Brian Yee wrote:
> I have one solr collection used for auto-suggestions. If I submit a query
> with q="coffe", I will
I have one solr collection used for auto-suggestions. If I submit a query with
q="coffe", I will get a responses back with documents that have a field
suggestion="coffee", "coffee table", "coffee maker", etc. I want to know if
those suggestions would have results if I used them to query a second
I was to comment the very same solution!
I think this will satisfy the user requirement.
Thanks Antonio!
Cheers
2015-07-13 12:22 GMT+01:00 Antonio David Pérez Morales <
adperezmora...@gmail.com>:
> Hi again Yusnel
>
> Just to confirm, I have tested your use case and the query which returns
> wha
Hi again Yusnel
Just to confirm, I have tested your use case and the query which returns
what you need is this one:
http://localhost:8983/solr/category/select?q={!join from=categoryId
fromIndex=product to=id}*:*&wt=json&indent=true&fq=name:clothes&hl=false
Please, check and let us know if it wor
Hi Yusnel
I think the query is invalid. It should be "q=clothes&fq={!join
from=type_id to=id fromIndex=products}" or "q=*:*&fq={!join from=type_id
to=id fromIndex=products}clothes" as long as you are using an edismax
parser or df param for default field, where "clothes" query is matched to.
Regar
I have 2 indexes
products {
id,
name,
type_id
..
}
and
categories {
id,
name
..
}
and I want to get all categories that match a name and have products in it.
my best guess would be:
http://localhost:8983/solr/categories/select?q=clothes&fl=*,score&fq={!join
from=type_id to=
We simply index parent and child documents with the same field value,
and group on that, querying both parent and child documents. If you
boost the parent it will show up as the first result in the group. Then
you get all related documents together. in the same group.
-Mike
On 12/02/2014 02:
Hi,
Thanks for the response, I have considered grouping often, but grouping does
not return the parent document, just the group id. I would still have to add
something to take the group id’s and get the parent documents.
Thanks
Darin
> On Dec 2, 2014, at 2:11 PM, Michael Sokolov
> wrote:
>
Have you considered using grouping? If I understand your requirements,
I think it does what you want.
https://cwiki.apache.org/confluence/display/solr/Result+Grouping
On 12/02/2014 12:59 PM, Darin Amos wrote:
Thanks!
I will take a look at this. I do have an additional question, since after a
Thanks!
I will take a look at this. I do have an additional question, since after a
bunch of digging I believe I am going to run into another dead end.
I want to execute the join (or rollup) query, but I want the facets to
represent the facets of all the child documents, not the resulting produ
Hello,
AFAIK {!join} doesn't supply any meaningful scores.
I can suggest https://issues.apache.org/jira/browse/SOLR-6234
On Tue, Dec 2, 2014 at 4:35 AM, Darin Amos wrote:
> Hello,
>
> I had sent an email a few days ago talking about implementing a custom
> rollup query component. I have changed
Hello,
I had sent an email a few days ago talking about implementing a custom rollup
query component. I have changed directions a little bit because I have learned
about the JoinQuery.
I have an index that contains a combination of parent and child documents. The
parent child relationship is a
lize the data if possible.
Best,
Erick
On Sun, Jan 12, 2014 at 9:55 PM, solr2020 wrote:
> Hi All,
>
> Can anyone please explain how solr join query works in solr4.2.
> we have 2 different documents.Both are in the same index.
>
> document1 contains the columns:
>
> docdate
anyone please explain how solr join query works in solr4.2.
we have 2 different documents.Both are in the same index.
document1 contains the columns:
docdate: 01-12-2012
previousmonthdate :01-11-2012
price:15
and some more fields.
document2 contains:
docdate :01-11-2012
previousmonthdate :01-10
Hi All,
Can anyone please explain how solr join query works in solr4.2.
we have 2 different documents.Both are in the same index.
document1 contains the columns:
docdate: 01-12-2012
previousmonthdate :01-11-2012
price:15
and some more fields.
document2 contains:
docdate :01-11-2012
that commit the join / fq functionality works as expected /
> > documented on the wiki page. After that commit it's broken.
> >
> > Any assistance is greatly appreciated!
> >
> > Thanks,
> >
> > Mike
> >
> > On Thu, Jan 26, 2012 at 11:04 AM,
the join / fq functionality works as expected /
> documented on the wiki page. After that commit it's broken.
>
> Any assistance is greatly appreciated!
>
> Thanks,
>
> Mike
>
> On Thu, Jan 26, 2012 at 11:04 AM, Mike Hugo wrote:
>
>> Hello,
>>
>>
nks,
>
> Mike
>
>
> On Thu, Jan 26, 2012 at 11:04 AM, Mike Hugo wrote:
>
>> Hello,
>>
>> I'm trying out the Solr JOIN query functionality on trunk. I have the
>> latest checkout, revision #1236272 - I did the following steps to get the
>> e
> Hello,
>
> I'm trying out the Solr JOIN query functionality on trunk. I have the
> latest checkout, revision #1236272 - I did the following steps to get the
> example up and running:
>
> cd solr
> ant example
> java -jar start.jar
> cd exampledocs
> java -j
Hello,
I'm trying out the Solr JOIN query functionality on trunk. I have the
latest checkout, revision #1236272 - I did the following steps to get the
example up and running:
cd solr
ant example
java -jar start.jar
cd exampledocs
java -jar post.jar *.xml
Then I tried a few of the s
29 matches
Mail list logo
