Re: Filtered join in Solr?

Hi Edward, Thanks a lot for your reply! Subquery is what I had in mind, too, for designs 1) and 3) to bring back the other side of the relationship. Except that I always queries movies and subqueried users. If I do it the other way around, like you did, then I'm able to filter. I can't quite

Re: Filtered join in Solr?

Just for the sake of an imagined scenario, you could use the [subquery] doc transformer. A query like the one below: /select?q=family: Smith=watched_movies:[* TO *]=*, movies:[subquery]={!terms f=id v=$row.watched_movies} Would bring back the results below: { "responseHeader":{ "status":0,

Filtered join in Solr?

Hello Solr users, How would you design a filtered join scenario? Say I have a bunch of movies (excuse any inaccuracies, this is an imagined scenario): curl -XPOST -H 'Content-Type: application/json' 'localhost:8983/solr/test/update?commitWithin=1000' --data-binary ' [{ "id": "1", "title":

Re: join the Solr mailing

It’s all a self-registration process. If you followed the instructions for subscribing here: http://lucene.apache.org/solr/community.html#mailing-lists-irc you should already have an answer ;) Best, Erick > On May 19, 2019, at 12:19 AM, Vadim Karagichev > wrote: > > Hi, > > A fellow

join the Solr mailing

Hi, A fellow coworker is subscribed to the mail distribution of Solr questions, Wanted to ask if I could join as well? Thanks This email and any attachments thereto may contain private, confidential, and privileged material for the sole use of the intended

Re: Hi, happy to join this solr party.

Welcome! To subscribe, send an email to solr-user-subscr...@lucene.apache.org . More info here: http://lucene.apache.org/solr/community.html#mailing-lists-irc -- Steve www.lucidworks.com > On Jul 10, 2018, at 6:07 AM, zhenyuan wei wrote: > > I'd like to subscribe this maillist, thanks.

Hi, happy to join this solr party.

I'd like to subscribe this maillist, thanks.

Re[4]: Block Join faceting on intermediate levels with JSON Facet API (might be related to block join rollups & SOLR-8998)

>>You could add a "level2_comment_id" field to the level 2 commends and >>it's children, and then use unique() on that. OK, I see, I missed the children... Thank you for pointing out. I have introduced that "unique sub-branch identifying" field and propagated it down the subbranch (the data

Re: Cross collection join in Solr 5.x

.org Subject: Re: Cross collection join in Solr 5.x I have done it by extending the solr join plugin. Needed to override 2 methods from join plugin and it works out. Thanks, Susmit On Thu, Apr 21, 2016 at 12:01 PM, Mikhail Khludnev < mkhlud...@griddynamics.com> wrote: > Hello, > >

Re: Re[2]: Block Join faceting on intermediate levels with JSON Facet API (might be related to block join rollups & SOLR-8998)

On Fri, Apr 22, 2016 at 12:26 PM, Alisa Z. wrote: > Hi Yonik, > > Thanks a lot for your response. > > I have discussed this with Mikhail Khludnev already and tried this > suggestion. Here's what I've got: > > > > sentiment: positive > author: Bob > text: Great post about Solr >

Re[2]: Block Join faceting on intermediate levels with JSON Facet API (might be related to block join rollups & SOLR-8998)

Hi Yonik, Thanks a lot for your response.   I have discussed this with Mikhail Khludnev already and tried this suggestion. Here's what I've got:  sentiment: positive author: Bob text: Great post about Solr 2.blog-posts.comments-id: 10735-23004       //this is a new

Re: Block Join faceting on intermediate levels with JSON Facet API (might be related to block join rollups & SOLR-8998)

Hi Alisa, This was a bit too hard for me to grok on a first pass... then I saw your related blog post which includes the actual sample data and makes it more clear. More comments inline: On Wed, Apr 20, 2016 at 2:29 PM, Alisa Z. wrote: > Hi all, > > I have been stretching

Re: Cross collection join in Solr 5.x

I have done it by extending the solr join plugin. Needed to override 2 methods from join plugin and it works out. Thanks, Susmit On Thu, Apr 21, 2016 at 12:01 PM, Mikhail Khludnev < mkhlud...@griddynamics.com> wrote: > Hello, > > There is no much progress on > https://issu

Re: Cross collection join in Solr 5.x

Hello, There is no much progress on https://issues.apache.org/jira/browse/SOLR-8297 Although it's really achievable. On Thu, Apr 21, 2016 at 7:52 PM, Shikha Somani wrote: > Greetings, > > > Background: Our application is using Solr 4.10 and has multiple > collections all

Cross collection join in Solr 5.x

Greetings, Background: Our application is using Solr 4.10 and has multiple collections all of them sharded equally on Solr. These collections were joined to support complex queries. Problem: We are trying to upgrade to Solr 5.x. However from Solr 5.2 onward to join two collections it is a

Block Join faceting on intermediate levels with JSON Facet API (might be related to block join rollups & SOLR-8998)

Hi all, I have been stretching some SOLR's capabilities for nested documents handling and I've come up with the following issue... Let's say I have the following structure: { "blog-posts":{  //level 1     "leaf-fields":[     "date",     "author"],     "title":{

Re: Join in SOLR

: Join in SOLR On Wed, Dec 17, 2014 at 11:51 AM, Rajesh Panneerselvam [hidden email]/user/SendEmail.jtp?type=nodenode=4174700i=0 wrote: Yes Mikhail. This is what I want exactly. My sub-entities should be added as child document to the root entity. But will this feature be available

RE: Join in SOLR

] [mailto:ml-node+s472066n4174700...@n3.nabble.com] Sent: 17-Dec-14 15:05 To: Rajesh Panneerselvam Subject: Re: Join in SOLR On Wed, Dec 17, 2014 at 11:51 AM, Rajesh Panneerselvam [hidden email]/user/SendEmail.jtp?type=nodenode=4174700i=0 wrote: Yes Mikhail. This is what I want exactly. My sub

Re: Join in SOLR

to the general public. Is there any URL where they post their nightly build? Thanks in advance Rajesh Panneerselvam From: Mikhail Khludnev [via Lucene] [mailto: ml-node+s472066n4174700...@n3.nabble.com] Sent: 17-Dec-14 15:05 To: Rajesh Panneerselvam Subject: Re: Join in SOLR On Wed, Dec

RE: Join in SOLR

+s472066n4176668...@n3.nabble.com] Sent: 31-Dec-14 11:52 To: Rajesh Panneerselvam Subject: Re: Join in SOLR Rajesh, Nohow. Jira is still open, the patch wasn't committed anywhere. On Wed, Dec 31, 2014 at 8:27 AM, Rajesh [hidden email]/user/SendEmail.jtp?type=nodenode=4176668i=0 wrote: Mikhail, How can I

Re: Join in SOLR

On 12/30/2014 11:44 PM, Rajesh wrote: Oh! Thanks Mikhail. But I could see a comment in that JIRA, above your comment which is from Thomas champagne that the patch was committed to current trunk. Is it not for this issue Mikhail? The message from Thomas Champagne indicates that he updated the

Re: Join in SOLR

Is there a way to get the trunk and I can update the same patch to check this functionality. If so, where can I get the trunk build? -- View this message in context: http://lucene.472066.n3.nabble.com/Join-in-SOLR-tp4173930p4176678.html Sent from the Solr - User mailing list archive

Re: Join in SOLR

to check this functionality. If so, where can I get the trunk build? -- View this message in context: http://lucene.472066.n3.nabble.com/Join-in-SOLR-tp4173930p4176678.html Sent from the Solr - User mailing list archive at Nabble.com. -- Sincerely yours Mikhail Khludnev Principal Engineer

Re: Join in SOLR

On 12/31/2014 12:19 AM, Rajesh wrote: Is there a way to get the trunk and I can update the same patch to check this functionality. If so, where can I get the trunk build? http://wiki.apache.org/solr/HowToContribute#Getting_the_source_code You will need a number of software components,

Fwd: Join in SOLR

Hello Rajesh, Please find the brief below Thanks Mikhail. As per what you have mentioned can I get a list of sub entities with this new Zipper join. Because now in existing DIH I'm getting a list for individual fields of the sub entities. 1) If I get a list of sub entities how can I get it

Re: Join in SOLR

a question to committers, you can leave a comment and/or vote for an issue. Thanks Rajesh Panneerselvam *From:* Mikhail Khludnev [mailto:mkhlud...@griddynamics.com] *Sent:* 17-Dec-14 12:43 *To:* Rajesh Panneerselvam *Subject:* Re: Join in SOLR Hello Rajesh, Please find

Re: Join in SOLR

in context: http://lucene.472066.n3.nabble.com/Join-in-SOLR-tp4173930p4174679.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Join in SOLR

Thanks for your reply Tomoko. My data-config file looks like the below. document entity/entity entity/entity entity/entity /document Each entity represents a table in DB. Now, If I want to join these three tables, can I make use of the SOLR join functionality.. -- View this message

Re: Join in SOLR

Thank you for config information. Three tables have relation (by foreign key) ? You might want to have one nested entity tag in document rather than 3 entity one in document. By using nested entity tag, you may able to merge tables *before* importing them to Solr. All works done by SQL. You have

Re: Join in SOLR

for name, another list for id and another one for desc. Is there a way how I can get List of sub entities. -- View this message in context: http://lucene.472066.n3.nabble.com/Join-in-SOLR-tp4173930p4173977.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Join in SOLR

has 3 fields name, id, desc. I'm getting a list for name, another list for id and another one for desc. Is there a way how I can get List of sub entities. -- View this message in context: http://lucene.472066.n3.nabble.com/Join-in-SOLR-tp4173930p4173977.html Sent from the Solr - User

Re: Join in SOLR

On Fri, Dec 12, 2014 at 5:31 PM, Shawn Heisey apa...@elyograg.org wrote: Using a database view that does the JOIN on the server side is pretty much guaranteed to have far better performance. Database software is very good at doing joins efficiently when proper DB indexes are available ...

Join in SOLR

this message in context: http://lucene.472066.n3.nabble.com/Join-in-SOLR-tp4173930.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Join in SOLR

. If you *really* need join like RDB on Solr, you could consult with Solr's join feature. (That makes your system more complicated.) https://wiki.apache.org/solr/Join Regards, Tomoko 2014-12-12 14:36 GMT+09:00 Rajesh rajesh.panneersel...@aspiresys.com: I'm using Solr 4.10. While importing through DIH

Re: Join in solr to get data from two cores

Kishore kamal.kish...@indiamart.comwrote: Any updates guys ? On Thu, May 8, 2014 at 2:05 PM, Kamal Kishore kamal.kish...@indiamart.com wrote: Dear Team, I have two solr cores. One containing products information and second has customers points. I am looking at solr join to query on first

Re: Join in solr to get data from two cores

has customers points. I am looking at solr join to query on first product core boost the results based on customer points in second core. I am not able to frame solr query for this. Moreover, solr is not allowing to get data from both the core. With RegardsK Kamal Kishore -- - https

Re: Join in solr to get data from two cores

:05 PM, Kamal Kishore kamal.kish...@indiamart.com wrote: Dear Team, I have two solr cores. One containing products information and second has customers points. I am looking at solr join to query on first product core boost the results based on customer points in second core. I am

Re: Join in solr to get data from two cores

information and second has customers points. I am looking at solr join to query on first product core boost the results based on customer points in second core. I am not able to frame solr query for this. Moreover, solr is not allowing to get data from both the core. With RegardsK Kamal Kishore

Re: Join in solr to get data from two cores

Any updates guys ? On Thu, May 8, 2014 at 2:05 PM, Kamal Kishore kamal.kish...@indiamart.comwrote: Dear Team, I have two solr cores. One containing products information and second has customers points. I am looking at solr join to query on first product core boost the results based

Re: Join in solr to get data from two cores

products information and second has customers points. I am looking at solr join to query on first product core boost the results based on customer points in second core. I am not able to frame solr query for this. Moreover, solr is not allowing to get data from both the core. With RegardsK

Join in solr to get data from two cores

Dear Team, I have two solr cores. One containing products information and second has customers points. I am looking at solr join to query on first product core boost the results based on customer points in second core. I am not able to frame solr query for this. Moreover, solr is not allowing

Re: Equivalent of SQL JOIN in SOLR across multiple cores

I had gone through link - http://wiki.apache.org/solr/Join and it says there is a Limitation in JOIN, you will be able to get resulting documents containing fields in either of two I have used below query http://localhost:8983/solr/coreTO/select?q={!join from=docId to=id fromIndex=coreFROM}query

Equivalent of SQL JOIN in SOLR across multiple cores

1, Are the cores join-able? 2. Could you give me an example about how to write a multiple core join? 3. Can we do equivalent of JOIN in SOLR across multiple cores Select T1.*,T2.* FROM Table1 T1,Table2 T2 WHERE T1.id = T2.id -- View this message in context: http://lucene

Re: Equivalent of SQL JOIN in SOLR across multiple cores

Hi, There are some join support : 1) Query Time Join (works across cores) https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-JoinQueryParser http://wiki.apache.org/solr/Join 2) Block Joins https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers

Re: Example of join using Solr/Lucene

You can check these links: http://wiki.apache.org/solr/Join http://stackoverflow.com/questions/12665797/is-solr-4-0-capable-of-using-join-for-multiple-core Regards. On Wed, Nov 6, 2013 at 1:00 AM, Tech Id tech.login@gmail.com wrote: Hi Alvaro, Could you please point me to some link

Re: Example of join using Solr/Lucene

can check these links: http://wiki.apache.org/solr/Join http://stackoverflow.com/questions/12665797/is-solr-4-0-capable-of-using-join-for-multiple-core Regards. On Wed, Nov 6, 2013 at 1:00 AM, Tech Id tech.login@gmail.com wrote: Hi Alvaro, Could you please point me to some link

Re: Example of join using Solr/Lucene

, Alvaro Cabrerizo topor...@gmail.comwrote: You can check these links: http://wiki.apache.org/solr/Join http://stackoverflow.com/questions/12665797/is-solr-4-0-capable-of-using-join-for-multiple-core Regards. On Wed, Nov 6, 2013 at 1:00 AM, Tech Id tech.login@gmail.com wrote: Hi Alvaro

Example of join using Solr/Lucene

Hi, I have been searching for an example of joins using solr/lucene. But I have not found anything either on the net or in the src/examples. Can someone please point me to the same? Ideally, I need a join working with Solrj APIs (Please let me know if this group is Lucene-specific). Best

Re: Example of join using Solr/Lucene

I think Solr has the ability to do joins in the latest version as verified on this issue: https://issues.apache.org/jira/browse/SOLR-3076 And some online resources point to this example: http://blog.mikemccandless.com/2012/01/searching-relational-content-with.html However, I am not sure if the

Re: Example of join using Solr/Lucene

In my case, everytime I've used joins, the FROM field was a multivalued string and the TO was an univalued string. Regards. El 05/11/2013 18:37, Tech Id tech.login@gmail.com escribió: I think Solr has the ability to do joins in the latest version as verified on this issue:

Re: Example of join using Solr/Lucene

Hi Alvaro, Could you please point me to some link from where I can see how to index two documents separately (joined by foreign keys). Or if you can oblige by putting down some details here itself. *For example*, say if user has entities like : car {id:5, color:red, year:2004, companyId:23,

Join in Solr 3.6

Hi. I have read there is join functionality in Solr 4 beta. Is there a join in Solr 3.6? Thanks, Peter

Re: Join in Solr 3.6

Hello! If you talk about this: https://issues.apache.org/jira/browse/SOLR-2272 than it is only available since 4.0-alpha. -- Regards, Rafał Kuć Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch - ElasticSearch Hi. I have read there is join functionality in Solr 4 beta

Re: Some sort of join in SOLR?

I would *strongly* encourage you to store them together as one document. There's no real method of doing DB like joins in the underlying Lucene search engine. But that's generic advice. The question I have for you is What's the big deal about coordinating the sources? That is, you have to have

JOIN in Solr (was: convert custom facets to Solr facets...)

On Feb 2, 2007, at 4:46 PM, Ryan McKinley wrote: I would LOVE to see a JOIN in SOLR. I have an index of artists, albums, and songs. The artists have lots of metadata and the songs very little. I'd love to be able to search for songs using the artist metadata. Right now, I have to add all

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

We would never use JOIN. We denormalize for speed. Not a big deal. wunder == Search Guru, Netflix On 2/3/07 11:16 AM, Brian Whitman [EMAIL PROTECTED] wrote: On Feb 2, 2007, at 4:46 PM, Ryan McKinley wrote: I would LOVE to see a JOIN in SOLR. I have an index of artists, albums, and songs

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

On 2/3/07, Walter Underwood [EMAIL PROTECTED] wrote: We would never use JOIN. We denormalize for speed. Not a big deal. I'm looking at an application where speed is not the only concern. If I can remove the need for a 'normalized' and 'denormalized' form it would be a HUGE win. Essentially

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

oops!!! I meant to reply directly to Brian - an old friend of mine from graduate school... next time I'll check the reply-to button more closely.

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

I'm quite open to NOT having a JOIN in Solr if flattening the model still provides the querying capability desired. I've not fully followed the specifics that Yonik has mentioned on this thread, but it certainly is the case that denormalizing/flattening our domain does not exactly lend