Re: join query limitations

This probably carried forward from a very old version organically. I am running 7.7 On Mon, Sep 14, 2020 at 6:25 PM Erick Erickson wrote: > > What version of Solr are you using? ‘cause 8x has this definition for > _version_ > > > > > and I find no text like you’re seeing in any schema file i

Re: join query limitations

What version of Solr are you using? ‘cause 8x has this definition for _version_ and I find no text like you’re seeing in any schema file in 8x…. So with a prior version, “try it and see”? See: https://issues.apache.org/jira/browse/SOLR-9449 and linked JIRAs, the _version_ can be indexed=“fal

Re: join query limitations

Yes but "the _version_ field is also a non-indexed, non-stored single valued docValues field;" <- is that a problem? My schema has this: I don't know if I use the updateLog or not. How can I find out? I think that would work for me as I could just make a dynamic fild like: --- Yes it i

Re: join query limitations

Have you seen “In-place updates”? See: https://lucene.apache.org/solr/guide/8_1/updating-parts-of-documents.html Then use the field as part of a function query. Since it’s non-indexed, you won’t be searching on it. That said, you can do a lot with function queries to satisfy use-cases. Best. Er

join query limitations

I have hit a bit of a cross-road with our usage of solr where I want to include some slightly dynamic data. I want to ask solr to find things like "text query" but only if they meet some specific criteria. When I have all of those criteria indexed, everything works great. (text contains "apples"

Retrieving Parent and Child Documents using the Bock Join Query Technique when the Child and parent Document having the identical field

Hi Solr Team, I am trying to retrieve the Parent Document by using the Block Join Parent Query Parser (q={!parent which=allParents}someChildren), but the filter condition i gave is having the same field in both the parent and the child document, So the Parser is throwing the Error : "Child qu

Re: JOIN query

at 3:42 PM Paresh wrote: > Hi, > > I have two collections: collection1 and collection2 > I have fields like - > colleciton1: id, prop1, prop2, prop3 > collection2: id, col1, col2, col3 > > I am doing a join query with collection1.prop1 = collection2.col1 on > collection2.

JOIN query

Hi, I have two collections: collection1 and collection2 I have fields like - colleciton1: id, prop1, prop2, prop3 collection2: id, col1, col2, col3 I am doing a join query with collection1.prop1 = collection2.col1 on collection2. As a result, I can get any field from collection2 in 'fl&

Exception with cross-collection join query

This has worked previously (solr 4.8) and does not work in solr 7.4. Fist query returns with proper result but index stops working from then on until restart. 13:43:02.573 [https-jsse-nio-8081-exec-6] ERROR org.apache.solr.core.SolrCore - Too many close [count:-1] on org.apache.solr.core.SolrC

RE: Solr join query

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

Re: Solr join query

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. >

RE: Solr join query

e.apache.org > Subject: Solr join query > > Can we join two solr collection based on multivalued field.

Solr join query

Can we join two solr collection based on multivalued field.

RE: join query and new searcher on joined collection

I see, thank you very much! > -Original Message- > From: Mikhail Khludnev [mailto:m...@apache.org] > Sent: Tuesday, January 15, 2019 6:45 PM > To: solr-user > Subject: Re: join query and new searcher on joined collection > > It doesn't invalidate anything. It j

Re: join query and new searcher on joined collection

It doesn't invalidate anything. It just doesn't matches to the join query from older collection2 see https://github.com/apache/lucene-solr/blob/b7f99fe55a6fb6e7b38828676750b3512d6899a1/solr/core/src/java/org/apache/solr/search/JoinQParserPlugin.java#L570 So, after commit collection2 foll

RE: join query and new searcher on joined collection

Thanx, Mikhail for reply > collection1 has no idea about new searcher in collection2. I suspected it. :) So, when "join" query arrives searcher on collection1 has no chance to use filter cache, stored before. I suppose it invalidates filter cache, am I right? &fq={!join s

Re: join query and new searcher on joined collection

> > > > -Original Message- > > From: Vadim Ivanov [mailto:vadim.iva...@spb.ntk-intourist.ru] > > Sent: Tuesday, January 15, 2019 1:00 PM > > To: solr-user@lucene.apache.org > > Subject: join query and new searcher on joined collection > > > >

RE: join query and new searcher on joined collection

impossible to use caches on collection1 and ... Does new searcher starts on collection1 as well? > -Original Message- > From: Vadim Ivanov [mailto:vadim.iva...@spb.ntk-intourist.ru] > Sent: Tuesday, January 15, 2019 1:00 PM > To: solr-user@lucene.apache.org > Subject: join

join query and new searcher on joined collection

Solr 6.3 I have a query like this: q=*:*{!join score=none from=id fromIndex=hss_4 to=rpk_hdquotes v=$qq}*:* -- Vadim

RE: join query in same collection

using &distrib=false -- BR, Vadim -Original Message- From: Steve Pruitt [mailto:bpru...@opentext.com] Sent: Friday, September 14, 2018 9:22 PM To: solr-user@lucene.apache.org Subject: join query in same collection I see nothing in the documentation suggesting a query with a jo

join query in same collection

I see nothing in the documentation suggesting a query with a join filter doesn't work when a single collection is involved. There is the special deployment instructions when joining across two distinct collections, but this is not my case. I have a single collection: I have two VM's, both runn

Re: need help with a complicated join query

I'm thinking something like this: q={!join v=id:doca_1 from=members to=id} On Fri, 24 Aug 2018 at 03:03, Steve Pruitt wrote: > At least it is complicated to me. :>) > > We are investigating how to find return a list documents whose identifier > is contained in a multi-value field in another doc

need help with a complicated join query

At least it is complicated to me. :>) We are investigating how to find return a list documents whose identifier is contained in a multi-value field in another document. The index consists of essentially two different documents sharing some common fields. To make it simple, I will refer to them

Re: Block join query parser

[child] has childFilter param. Also, mind about [subquery] On Wed, Jun 6, 2018 at 9:33 AM, Ryan Yacyshyn wrote: > Hi all, > > I'm looking for a way to query nested documents that would return the > parent documents along with its child documents nested under it, but only > the child documents th

Block join query parser

Hi all, I'm looking for a way to query nested documents that would return the parent documents along with its child documents nested under it, but only the child documents that match the query. The [child] doc transformer comes close, but it returns all child docs. I'm looking for something simil

Re: I'm unable to negate a join query using the Spring Java interface to Solr

You can try to make such "pure negative" query how it works underneath (but it's not how it's actually executed). *:* -{!join ..}.. ie Create boolean query with two legs: MatchAll and NOT Join. Unfortunately, I have no idea about those Java wrappers. On Tue, Feb 6, 2018 at 12:11 AM, Todd Stevenson

I'm unable to negate a join query using the Spring Java interface to Solr

I have the following query: {!join from=conceptNcid to=ncid fromIndex=hdd_rel_tst}relationshipNcid:364 which I implemented in Spring: Criteria criteria = new Criteria("relationshipNcid").is("364"); SimpleQuery search = new SimpleQuery(criteria, pageable); search.setJ

Re: Solr join query takes too long

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

Solr join query takes too long

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

Re: Doubts regarding usage of block join query

oblem? > > On Jan 18, 2018 1:31 AM, "Mikhail Khludnev" wrote: > > > sure > > > > On Wed, Jan 17, 2018 at 9:39 PM, Aashish Agarwal > > wrote: > > > > > Hello, > > > I tried to use block join query feature in solr 4.6.0. My da

Re: Doubts regarding usage of block join query

any way to solve the above problem? > > On Jan 18, 2018 1:31 AM, "Mikhail Khludnev" wrote: > > > sure > > > > On Wed, Jan 17, 2018 at 9:39 PM, Aashish Agarwal > > wrote: > > > > > Hello, > > > I tried to use block join query feat

Re: Doubts regarding usage of block join query

So is there any way to solve the above problem? On Jan 18, 2018 1:31 AM, "Mikhail Khludnev" wrote: > sure > > On Wed, Jan 17, 2018 at 9:39 PM, Aashish Agarwal > wrote: > > > Hello, > > I tried to use block join query feature in solr 4.6.0. My data is i

Re: Doubts regarding usage of block join query

sure On Wed, Jan 17, 2018 at 9:39 PM, Aashish Agarwal wrote: > Hello, > I tried to use block join query feature in solr 4.6.0. My data is in > database but since 4.6 does not support DIH with child=true, so I created > the csv in order list of child followed by parent. > I

Block join query with solr 4.6.0

Hi, I am using block join query to get parent object using filter on child. But when the number of results are large than the query fails with ArrayIndexOutOfBoundException. e.g in range query price:[0 TO 20] fails but price[0 TO 10], price:[10 TO 20] works fine. I am using solr 4.6.0. Thanks

Re: Question on SOLR join query

O(fromDocs) ie if subordinate query returns no result it gets back rapidly. On Tue, Sep 26, 2017 at 4:59 AM, Jaimin Patel wrote: > 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 sto

Re: Question on SOLR join query

mance 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

Question on SOLR join query

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

Re: solr join query

t; Is there a way to do this without multiple solr queries? I could do the > first query to the suggestions collection, then take the results from that > and do more queries to the products collection. But I don't think that will > meet my performance requirements. > > Is this possible with a single join query? Any other ideas? >

solr join query

t will meet my performance requirements. Is this possible with a single join query? Any other ideas?

Boost(bq) with Block Join Query Praser

Hi all, We are having Nested Documents. We want similar kind of function like 'bq'(Edismax) with Block Join Query parser. Can you please provide some inputs to achieve boost within result set based on some attribute in Solr. -- View this message in context: http://lucene

Re: JOIN query

Hi Nitin, Probably you can look at the Streaming Expressions here: https://cwiki.apache.org/confluence/display/solr/Streaming+Expressions This is available from Solr 6. Regards, Edwin On 28 February 2017 at 16:45, Nitin Kumar wrote: > Hi, > > Can we use join query for more than 2

JOIN query

Hi, Can we use join query for more than 2 cores in solr. If yes, please provide reference or example. Thanks, Nitin

Nested Document (aka Block Join) Query with Multiple Criteria

I am trying to perform a Nested Document query containing multiple criteria, which can be treated as an AND in regards to the parent document. With the structure: ParentDocument: { id:1 ChildDocument: { id:1.1 field1:value1, field2:value2 }, ChildDocument:

Re: Faceting on both Parent and Child records in Block Join Query Parser

Thanks for the information. Will try them out. Regards, Edwin On 5 October 2016 at 02:58, Mikhail Khludnev wrote: > Edwin, > It seems like you try to pull document hierarchy back. That's usually done > by searching parents and fl=[child ..],,. > > On Tue, Oct 4, 2016 at 5:22 PM, Zheng Lin Edwin

Re: Faceting on both Parent and Child records in Block Join Query Parser

Edwin, It seems like you try to pull document hierarchy back. That's usually done by searching parents and fl=[child ..],,. On Tue, Oct 4, 2016 at 5:22 PM, Zheng Lin Edwin Yeo wrote: > Some of the sample documents are like the following: > > Author is the Header, while Books are the Child > > Au

Re: Faceting on both Parent and Child records in Block Join Query Parser

I _think_ what is happening is that you are going in both parent and child directions in your filters. Try making your query ('q') define your original domain (q=type_s:author) and then 'books' goes inside the parent "author" scope and that's where you change your domain. Regards, Alex.

Re: Faceting on both Parent and Child records in Block Join Query Parser

Some of the sample documents are like the following: Author is the Header, while Books are the Child Author: Edwin Books: Book 1 Book 2 Book 3 Author: John Books: Book 4 Book 5 For this query: http://localhost:8983/solr/collection1/select?q=*:* &json.facet={

Re: Faceting on both Parent and Child records in Block Join Query Parser

Perhaps show a couple sample documents, and then what data you're looking for in a response? This stuff can be tough to pin down without concrete examples. -Yonik On Tue, Oct 4, 2016 at 5:22 AM, Zheng Lin Edwin Yeo wrote: > I have tried to use this nested query, but I still can't get results fo

Re: Faceting on both Parent and Child records in Block Join Query Parser

I have tried to use this nested query, but I still can't get results for the list of books. http://localhost:8983/solr/collection1/select?q=*:* &json.facet={ items:{ type:terms, field:author_s, domain: { blockParent : "type_s:author" }, facet:{ by1:{ type:terms, field:book_s, doma

Re: Faceting on both Parent and Child records in Block Join Query Parser

You need to switch the domain to the child records. It is somewhere in the guide or Yonik's blog linked. Regards, Alex On 4 Oct 2016 1:55 PM, "Zheng Lin Edwin Yeo" wrote: > Hi, > > Is it possible to do nested faceting on both records in parent and child in > a single query? > > For example,

Faceting on both Parent and Child records in Block Join Query Parser

Hi, Is it possible to do nested faceting on both records in parent and child in a single query? For example, I want to facet both author_s and book_s. Author is indexed as a parent, whereas Book is indexed as a child. I tried the following JSON Facet query, which is to do a facet of all the list

facet.piovt on a join query, joining two different collections

Hello, We are trying to do a pivot on the facet on two fields which exists on two different collections. We are joining the two collections using a common filed. Below is the query I'm having right now and it doesn't seem to work. Any help would be much appreciated. http://loalhost:8983/solr/

RE: IO Exception : Truncated chunk for WORKER collection for paraller stream Join Query

Exception : Truncated chunk for WORKER collection for paraller stream Join Query Does this log come from the worker node or from the shards? It would be good to see the error logs from the server that this node was talking to when the exception was thrown. Joel Bernstein http

Re: IO Exception : Truncated chunk for WORKER collection for paraller stream Join Query

kam...@smartstreamrdu.com> wrote: > Hello, > > we are using Solr 6.0.0 in CloudMode with 3 physical nodes and 3 shards > per collection. > > > we are using ParallelStream for our join searches. > > > Below error is observed when while searching with join query. > >

IO Exception : Truncated chunk for WORKER collection for paraller stream Join Query

Hello, we are using Solr 6.0.0 in CloudMode with 3 physical nodes and 3 shards per collection. we are using ParallelStream for our join searches. Below error is observed when while searching with join query. java.util.concurrent.ExecutionException: java.io.IOException: --> h

Re: Solr 5.5.0: SearchHandler: Appending a Join query

apache.org/confluence/display/solr/Parameter+Substitution Regards, Alex. Newsletter and resources for Solr beginners and intermediates: http://www.solr-start.com/ On 6 April 2016 at 20:01, Anand Chandrashekar wrote: > Greetings. > > 1) A join query creates an array of "q"

Re: Solr 5.5.0: SearchHandler: Appending a Join query

I suppose q= is singular param doesn't accept multiple values. On Wed, Apr 6, 2016 at 1:01 PM, Anand Chandrashekar wrote: > Greetings. > > 1) A join query creates an array of "q" parameter. For example, the query > > > http://localhost:8983/solr/gettingstar

Re: Solr 5.5.0: SearchHandler: Appending a Join query

Anand, have a look at the example schema, there is a section that explains "invariants" which could be one solution to your question. -Stefan On Wed, Apr 6, 2016 at 12:01 PM, Anand Chandrashekar wrote: > Greetings. > > 1) A join query creates an array of "q" para

Solr 5.5.0: SearchHandler: Appending a Join query

Greetings. 1) A join query creates an array of "q" parameter. For example, the query http://localhost:8983/solr/gettingstarted/select?q=projectdata%3A%22top+secret+data2%22&q=%7B!join+from=locatorByUser+to=locator%7Dusers=joe creates the following array elements for the "q&

Re: Block Join query

highlighting nor scoring. > > On Mon, Dec 14, 2015 at 2:45 PM, Novin Novin wrote: > > > Hi Mikhail, > > > > I'm having a little bit problem to construct the query for solr when I > have > > been trying to use block join query. As you said, i can't

Re: Block Join query

Mikhail, > > I'm having a little bit problem to construct the query for solr when I have > been trying to use block join query. As you said, i can't use + or > in front of block join query, so I have to put *{**!parent > which="doctype:200"} *in front. and after

Re: Block Join query

Hi Mikhail, I'm having a little bit problem to construct the query for solr when I have been trying to use block join query. As you said, i can't use + or in front of block join query, so I have to put *{**!parent which="doctype:200"} *in front. and after this, all fields ar

Re: Block Join query

h "Nested Queries" or so, check the post <http://blog.griddynamics.com/2013/12/grandchildren-and-siblings-with-block.html> On Fri, Dec 11, 2015 at 6:31 PM, Novin wrote: Hi Guys, I'm trying block join query, so I have tried +{!parent which="doctype:200"}flow

Re: Block Join query

th-block.html> On Fri, Dec 11, 2015 at 6:31 PM, Novin wrote: > Hi Guys, > > I'm trying block join query, so I have tried +{!parent > which="doctype:200"}flow:624 worked fine. But when i tried +{!parent > which="doctype:200"}flow:[624 TO 700] >

Block Join query

Hi Guys, I'm trying block join query, so I have tried +{!parent which="doctype:200"}flow:624 worked fine. But when i tried +{!parent which="doctype:200"}flow:[624 TO 700] Got the below error org.apache.solr.search.SyntaxError: Cannot parse 'flow_l:[624

Re: Using OR along with join query results causing NullPointerException in Solr 4.7.2

On Mon, Nov 30, 2015 at 1:51 PM, SuReN wrote: > o=id} product_name:Desire* just the first guess, try to avoid the space in the clause above -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics

Using OR along with join query results causing NullPointerException in Solr 4.7.2

Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:812) What is right to use OR along with join query r

Re: Trouble getting a solr join query done

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

Re: Trouble getting a solr join query done

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

Re: Trouble getting a solr join query done

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

Trouble getting a solr join query done

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=

Re: Block Join Query update documents, how to do it correctly?

On Thu, May 14, 2015 at 12:01 AM, Tom Devel wrote: > I tried to repost the whole modified document (the parent and ALL of its > children as one file), and it seems to work on a small toy example, but of > course I cannot be sure for a larger instance with thousands of documents, > and I would lik

Block Join Query update documents, how to do it correctly?

I am using the Block Join Query Parser with success, following the example on: https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-BlockJoinQueryParsers As this example shows, each parent document can have a number of documents embedded, and each document, be it a parent

Re: Block Join Query Parsers regular expression feature workaround req

wrote: > > > > > Hi > > > > > > I need to have a query in which I need to choose only those parent docs > > > none of whose children's field is having the specified value. > > > i.e. I need something like this: > > > http://localhost:8

Re: Block Join Query Parsers regular expression feature workaround req

docs >>>  none of whose children's field is having the specified value. >>>  i.e. I need something like this: >>>  http://localhost:8983/solr/core1/select?*q={!parent >>>  which=contentType:parent}childField:NOT value1* >>> >>>  The problem is*

Re: Block Join Query Parsers regular expression feature workaround req

need something like this: > > http://localhost:8983/solr/core1/select?*q={!parent > > which=contentType:parent}childField:NOT value1* > > > > The problem is* NOT operator is not being supported* in the Block Join > > Query Parsers. Could anyone please suggest a way to wor

Re: Block Join Query Parsers regular expression feature workaround req

dField:NOT value1* > > The problem is* NOT operator is not being supported* in the Block Join > Query Parsers. Could anyone please suggest a way to workaround this > problem? > Have also added the problem on *stackoverflow*: > > http://stackoverflow.com/questions/28562355/in-

Block Join Query Parsers regular expression feature workaround req

* NOT operator is not being supported* in the Block Join Query Parsers. Could anyone please suggest a way to workaround this problem? Have also added the problem on *stackoverflow*: http://stackoverflow.com/questions/28562355/in-solr-does-block-join-query-parsers-lack-regular-expression-feature Regards Sa

Re: Solr Block Join Query matching Parent documents that have multiple children

On Sat, Dec 20, 2014 at 1:32 AM, Jamie Johnson wrote: > > I have the following documents indexed > > > 0 > 1 > > > > physicalcharacteristics > Black > Green > > > physicalcharacteristics > Red > Brown > > > person > 1 > > > physicalcharacteristics > Pink > Purple > > > physicalcharact

Solr Block Join Query matching Parent documents that have multiple children

I have the following documents indexed 0 1 physicalcharacteristics Black Green physicalcharacteristics Red Brown person 1 physicalcharacteristics Pink Purple physicalcharacteristics Brown Blue person 2 I am able to get back all people that have child documents with brown hair and

RE: Help with a Join Query

Sent: Thursday, December 11, 2014 1:23 PM To: solr-user@lucene.apache.org Subject: Re: Help with a Join Query Thanks, That looks like a viable option, I could do something like the following: q={!join from=parent to=id} &fq={!join from=parent to=id}color:red &fq={!join from=parent to=id}color:b

Re: Help with a Join Query

f work. >> >>  Thanks >> >>  Darin >>>   On Dec 11, 2014, at 1:04 PM, Kydryavtsev Andrey >>> wrote: >>> >>>   How about something like >>> >>>   ({!join from=parent to=id}color:red) AND ({!join from=parent >>> to=id}c

Re: Help with a Join Query

gt;>  ({!join from=parent to=id}color:red) AND ({!join from=parent >> to=id}color:blue) ? >> >>  11.12.2014, 19:48, "Darin Amos" : >>>  Hello, >>> >>>  I am trying to execute a join query that I am not 100% sure how to >>> execute. Lets sa

Re: Help with a Join Query

os" : >> Hello, >> >> I am trying to execute a join query that I am not 100% sure how to execute. >> Lets say I have a bunch of parent and child documents and every one of my >> child documents has a single value field “color”. >> >> If I want

Re: Help with a Join Query

How about something like ({!join from=parent to=id}color:red) AND ({!join from=parent to=id}color:blue) ? 11.12.2014, 19:48, "Darin Amos" : > Hello, > > I am trying to execute a join query that I am not 100% sure how to execute. > Lets say I have a bunch of parent and chi

Help with a Join Query

Hello, I am trying to execute a join query that I am not 100% sure how to execute. Lets say I have a bunch of parent and child documents and every one of my child documents has a single value field “color”. If I want to search all parents that have a “red” child, tis is very easy: {!join

Re: Get matched Term in join query

Hi, Your question is a good one - I have added an option to search through results and filter that way, but it's not ideal, as very often there are 10,000 or millions of hits, with only 20 results per page returned. I've realized I run into the classic 'Terms-can't-filtered' issue. To filter Term

Re: Get matched Term in join query

Hello Peter, Let's limit or just fix the problem definition. I've got that dealing with cross core join id mandatory. Is it right? Then, do you need facets (from all resultset) or just a snippets (just from result page)? 09.12.2014 1:23 пользователь "Peter Sturge" написал: > Hi Forum, > > Is it

Get matched Term in join query

Hi Forum, Is it possible for a Solr query to return the term(s) that matched a particular field/query? For example, let's say there's a field like this: raw="This is a raw text field that happens to contain some text that's also in the action field value..." And another field in a different inde

Custom Rollup (Join) Query

hub.com/damos/SolrRollupQuery/blob/master/src/com/vast/solr/rollup/>), it still needs tuning and is definitely not finished, but I have mostly based this code off of other elements such as the join query, dismax query parser, and some of the 4.10.2 parent/child code. I want my customer to be able

Re: SOLR Join Query, Use highest weight.

from=parent%20to=id%7Dtype:child>> When I have a more specific query that actually give some meaningful weights: < q=name:(*Shirt*)%20OR%20name:(*Small*) >, it appears the rollup query assigns a weight to the parent of the last document encountered. For example, if a parents 2 childre

Re: SOLR Join Query, Use highest weight.

>> < >>>> http://localhost:8983/solr/testcore/select?q=*:*&fq=%7B!join%20from=parent%20to=id%7Dtype:child >>>> >>>> <http://localhost:8983/solr/testcore/select?q=*:*&fq=%7B!join%20from=parent%20to=id%7Dtype:child><http://localhost:89

Re: SOLR Join Query, Use highest weight.

ldren has weights of 1.4 and 0.4 without the join query, the parent has a weight of 0.4 after the join query. Is there a way that I can extend or modify the join query so it would assign the highest child weight to the parent document? Thanks!! Darin -- Sincerely yours Mikhail Khlud

Re: SOLR Join Query, Use highest weight.

join%20from=parent%20to=id%7Dtype:child> >>> >> >> When I have a more specific query that actually give some meaningful >> weights: < q=name:(*Shirt*)%20OR%20name:(*Small*) >, it appears the >> rollup query assigns a weight to the parent of the last docume

Re: SOLR Join Query, Use highest weight.

l > weights: < q=name:(*Shirt*)%20OR%20name:(*Small*) >, it appears the > rollup query assigns a weight to the parent of the last document > encountered. For example, if a parents 2 children has weights of 1.4 and > 0.4 without the join query, the parent has a weight of 0.4 after

SOLR Join Query, Use highest weight.

that actually give some meaningful weights: < q=name:(*Shirt*)%20OR%20name:(*Small*) >, it appears the rollup query assigns a weight to the parent of the last document encountered. For example, if a parents 2 children has weights of 1.4 and 0.4 without the join query, the parent has a wei

Re: Join and non-Join query give different results

ing house which gives zero results. It really took sometime to figure this out, I hope this will help someone else. -- View this message in context: http://lucene.472066.n3.nabble.com/Join-and-non-Join-query-give-different-results-tp4146922p4148131.html Sent from the Solr - User mailing list arch

Join and non-Join query give different results

ives 0 results, which is correct. So as you can see both queries are the same, the different is using the join query parser. I am a bit confused, why the first query gives results. My understanding is that this should not happen because the second query shows that there is no any available documents t

Re: "Fake" cached join query much faster than cached fq?

Thanks Mikhail, I'll try to profile it soon. As for cardinality, on a single core: created_at_tdid:[1392768001 TO 1393954400] = 241657215 text:coffee = 117593 Oddly enough, I just tried the query with &distrib=false and both return in about 50ms... hmm. On Thu, Jun 5, 2014 at 5:09 AM, Mikhai

Re: "Fake" cached join query much faster than cached fq?

Brett, It's really interesting observation. I can only speculate. It's worth to check cache hit stats and cache content via http://wiki.apache.org/solr/SolrCaching#showItems (the key question what are cached doc sets classes). Also if you tell the overall number of docs in the index, and cardinal

  1   2   >