Re: join query limitations

2020-09-14 Thread matthew sporleder
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

2020-09-14 Thread Erick Erickson
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

2020-09-14 Thread matthew sporleder
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

2020-09-14 Thread Erick Erickson
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

Re: JOIN query

2020-01-08 Thread Mikhail Khludnev
Hi, Paresh. I'm afraid the only way is to join them back in post processing https://lucene.apache.org/solr/guide/6_6/transforming-result-documents.html#TransformingResultDocuments-_subquery_ Although, I'm not sure it will ever work with particular collections. On Wed, Jan 8, 2020 at 3:42 PM Pares

Re: join the Solr mailing

2019-05-19 Thread Erick Erickson
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 cowork

RE: join query and new searcher on joined collection

2019-01-15 Thread Vadim Ivanov
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

2019-01-15 Thread Mikhail Khludnev
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 following join

RE: join query and new searcher on joined collection

2019-01-15 Thread Vadim Ivanov
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 score=none from=id fromI

Re: join query and new searcher on joined collection

2019-01-15 Thread Mikhail Khludnev
collection1 has no idea about new searcher in collection2. On Tue, Jan 15, 2019 at 1:18 PM Vadim Ivanov < vadim.iva...@spb.ntk-intourist.ru> wrote: > Sory, I've sent unfinished message > So, query on collection1 > q=*:*{!join score=none from=id fromIndex=collection2 to=field1}*:* > > The question

RE: join query and new searcher on joined collection

2019-01-15 Thread Vadim Ivanov
Sory, I've sent unfinished message So, query on collection1 q=*:*{!join score=none from=id fromIndex=collection2 to=field1}*:* The question is what happened with autowarming and new searchers on collection1 when new searcher starts on collection2? IMHO when request with join comes it's impossible

Re: Join across shards?

2018-10-24 Thread e_briere
Thanks to you both. Did not take the time to look into yet. I will. Eric. Sent from my Samsung Galaxy smartphone. Original message From: Erick Erickson Date: 2018-10-24 00:57 (GMT-05:00) To: solr-user Subject: Re: Join across shards? In addition to Vadim's comment,

Re: Join across shards?

2018-10-23 Thread Erick Erickson
In addition to Vadim's comment, Solr Streaming _can_ work across shards and even across collections. Depending on your use-case this may work for you. Best, Erick On Tue, Oct 23, 2018 at 6:41 AM Vadim Ivanov wrote: > > Hi, > You CAN join across collections with runtime "join". > The only limitati

RE: Join across shards?

2018-10-23 Thread Vadim Ivanov
Hi, You CAN join across collections with runtime "join". The only limitation is that FROM collection should not be sharded and joined data should reside on one node. Solr cannot join across nodes (distributed search is not supported). Though using streaming expressions it's possible to do various

Re: join

2018-10-15 Thread Zheng Lin Edwin Yeo
Please send email to solr-user-subscr...@lucene.apache.org to subscribe to the mailing list. Regards, Edwin On Tue, 16 Oct 2018 at 11:59, Karthik Gullapalli wrote: > Please add me to the mailing list >

RE: join query in same collection

2018-09-14 Thread Vadim Ivanov
Hi, AFAIK Solr can join only local indexes. No matter whether you join the same collection or two different ones. So, in your case shard1 will be joined to shard1 and shard2 to shard2. Unfortunately it's hard to say from your data which document resides in which shard, but you can test using &

Re: [EXTERNAL] - Re: join works with a core, doesn't work with a collection

2018-08-31 Thread Jan Høydahl
t: Thursday, August 30, 2018 12:25 PM > To: solr-user@lucene.apache.org > Subject: RE: [EXTERNAL] - Re: join works with a core, doesn't work with a > collection > > Gosh, really? This is not mentioned anywhere in the documentation that I can > find. There are node to HW consid

RE: [EXTERNAL] - Re: join works with a core, doesn't work with a collection

2018-08-30 Thread Steve Pruitt
PM To: solr-user@lucene.apache.org Subject: RE: [EXTERNAL] - Re: join works with a core, doesn't work with a collection Gosh, really? This is not mentioned anywhere in the documentation that I can find. There are node to HW considerations if you are joining across different Collections. But

RE: [EXTERNAL] - Re: join works with a core, doesn't work with a collection

2018-08-30 Thread Steve Pruitt
30, 2018 12:11 PM To: solr-user@lucene.apache.org Subject: Re: [EXTERNAL] - Re: join works with a core, doesn't work with a collection On 8/30/2018 9:49 AM, Steve Pruitt wrote: > If you mean another running Solr server running, then no. I mean multiple Solr processes. The cloud example

Re: [EXTERNAL] - Re: join works with a core, doesn't work with a collection

2018-08-30 Thread Shawn Heisey
On 8/30/2018 9:49 AM, Steve Pruitt wrote: If you mean another running Solr server running, then no. I mean multiple Solr processes. The cloud example (started with bin/solr -e cloud) starts two Solr instances if you give it the defaults.  They are both running on the same machine, but if par

RE: [EXTERNAL] - Re: join works with a core, doesn't work with a collection

2018-08-30 Thread Steve Pruitt
If you mean another running Solr server running, then no. -Original Message- From: Shawn Heisey Sent: Thursday, August 30, 2018 11:31 AM To: solr-user@lucene.apache.org Subject: Re: [EXTERNAL] - Re: join works with a core, doesn't work with a collection On 8/30/2018 9:17 AM,

Re: [EXTERNAL] - Re: join works with a core, doesn't work with a collection

2018-08-30 Thread Shawn Heisey
On 8/30/2018 9:17 AM, Steve Pruitt wrote: Single server. Localhost. I am using the simple setup and took all the defaults. Is there more than one Solr instance on that server? SolrCloud considers multiple instances to be completely separate, even if they're actually on the same hardware.

RE: [EXTERNAL] - Re: join works with a core, doesn't work with a collection

2018-08-30 Thread Steve Pruitt
Single server. Localhost. I am using the simple setup and took all the defaults. -Original Message- From: Shawn Heisey Sent: Thursday, August 30, 2018 11:14 AM To: solr-user@lucene.apache.org Subject: [EXTERNAL] - Re: join works with a core, doesn't work with a collection On

Re: join works with a core, doesn't work with a collection

2018-08-30 Thread Shawn Heisey
On 8/30/2018 9:00 AM, Steve Pruitt wrote: Is there something different I need to do for a query with a join for a Collection? Singular Collection, not across Collections. Initially, I used a Core for simple development. One of my queries uses a join. It works fine. I know very little abou

Re: Join - Multiple filters

2018-01-02 Thread Shawn Heisey
On 1/2/2018 1:27 PM, Mathieu Larose wrote: > The following query returns p1 (which is expected): > > q={!join fromIndex=child from=p_id_s to=id}y_s:y1 AND z_s:z1 > > > The following query returns nothing (which is not expected): > > q=({!join fromIndex=child from=p_id_s to=id}y_s:y1 AND z_s:z1) I

Re: Join not working in Solr 6.5

2017-05-22 Thread mganeshs
Thanks for bringing up performance perspective. Is there any bench mark on join performance when number of shards is more than 10 where documents are indexed based on router.field. Are you suggesting instead of router.field go for streaming expressions or use join with router.field and then go for

Re: Join not working in Solr 6.5

2017-05-22 Thread Erick Erickson
this will likely be "interesting" from a performance perspective. You might try Streaming, especially StreamingExpressions and ParallelSQL depending on what you need this for. Best, Erick On Mon, May 22, 2017 at 12:05 AM, Damien Kamerman wrote: > I use a router.field so docs that I join from/to

Re: Join not working in Solr 6.5

2017-05-22 Thread Damien Kamerman
I use a router.field so docs that I join from/to are always in the same shard. See https://cwiki.apache.org/confluence/display/solr/Shards+and+Indexing+Data+in+SolrCloud#ShardsandIndexingDatainSolrCloud-DocumentRouting There is an open ticket SOLR-8297 https://issues.apache.org/jira/browse/SOLR-8

Re: Join not working in Solr 6.5

2017-05-21 Thread mganeshs
Is there any possibility of supporting joins across multiple shards in near future ? How to achieve the join when our data is spread-ed across multiple shards. This is very much mandatory when we need to scale out. Any workarounds if out-of-box possibility is not there ? Thanks, -- View th

Re: Join not working in Solr 6.5

2017-05-21 Thread mganeshs
Perfect ! Sorry I overlooked and missed "=" Thanks, -- View this message in context: http://lucene.472066.n3.nabble.com/Join-not-working-in-Solr-6-5-tp4336247p4336251.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Join not working in Solr 6.5

2017-05-21 Thread Damien Kamerman
Your join should be: {!join from=id to=C_pid_s} On 22 May 2017 at 14:07, mganeshs wrote: > Hi, > > I have following records / documents with Parent entity > > id,type_s,P_hid_s,P_name_s,P_pid_s > 11,PERSON,11,Parent1,11 > > And following records / documents with child en

Re: JOIN query

2017-03-01 Thread Zheng Lin Edwin Yeo
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 cores in so

Re: join and faceting

2016-05-26 Thread Zaccheo Bagnati
Thank you for your answer but I'm not sure I've understood: document.type is not in the same core as annotations, how can I facet on that field? Il giorno gio 26 mag 2016 alle ore 14:06 Upayavira ha scritto: > > > On Thu, 26 May 2016, at 01:02 PM, Zaccheo Bagnati wrote: > > Hi all, > > I have a

Re: join and faceting

2016-05-26 Thread Upayavira
On Thu, 26 May 2016, at 01:02 PM, Zaccheo Bagnati wrote: > Hi all, > I have a SOLR core containing documents: > document (id, type, text) > and a core containing annotations (each document has 0 or more > annotations): > annotation (id, document_id, user, text) > > I can filter annotations on

Re: join and NOT together

2016-02-18 Thread Sergio García Maroto
HI Mikhail. Sorry for all the confusion This is the original query which doesn't work q=PersonName:peter AND {!type=join from=DocPersonID to=PersonID fromIndex=document v='(*:* -DocType:pdf)' } I figure out that negating outside the cross join query makes the trick for me. I take the negation ou

Re: join and NOT together

2016-02-17 Thread Mikhail Khludnev
Sergo, Please provide more debug output, I want to see how query was parsed. On Tue, Feb 16, 2016 at 1:20 PM, Sergio García Maroto wrote: > My debugQuery=true returns related to the NOT: > > 0.06755901 = (MATCH) sum of: 0.06755901 = (MATCH) MatchAllDocsQuery, > product of: 0.06755901 = queryNor

Re: join and NOT together

2016-02-16 Thread marotosg
Actually I was wrong this doesn't work. (-DocType:pdf) -- View this message in context: http://lucene.472066.n3.nabble.com/join-and-NOT-together-tp4257411p4257620.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: join and NOT together

2016-02-16 Thread Sergio García Maroto
My debugQuery=true returns related to the NOT: 0.06755901 = (MATCH) sum of: 0.06755901 = (MATCH) MatchAllDocsQuery, product of: 0.06755901 = queryNorm I tried changing v='(*:* -DocType:pdf)' to v='(-DocType:pdf)' and it worked. Anyone could explain the difference? Thanks Sergo On 15 February

Re: join and NOT together

2016-02-15 Thread Mikhail Khludnev
Hello Sergio, What debougQuery=true output does look like? On Mon, Feb 15, 2016 at 7:10 PM, marotosg wrote: > Hi, > > I am trying to solve an issue when doing a search joining two collections > and negating the cross core query. > > Let's say I have one collection person and another collection

Re: Join with faceting and filtering

2015-10-05 Thread Mikhail Khludnev
Hello Troy, What a challenge!! On Thu, Oct 1, 2015 at 3:42 PM, Troy Edwards wrote: > > 2) It appears that I cannot have fromIndex=Contracts because it is very > large and has to be sharded. Per my understanding SolrCloud join does not > support multiple shards > .. but it doesn't mean it will

Re: Join with faceting and filtering

2015-10-01 Thread Troy Edwards
I had missed a field in ContractItem index (ClientId) *ContractItem* ContractItemId - string ItemId - string ClientId - string ContractCode - string (facet and filter on this) Priority - integer (order by priority descending) Active - boolean (filter on this) 2) It appears that I cannot have fr

Re: Join with faceting and filtering

2015-10-01 Thread Mikhail Khludnev
1. i'd say it's challenge. 2. can't you do the opposite filter active contracts, join them back to items, and facet then? q=(Description:colgate OR Categories:colgate OR Sellers:colgate)&fq={!join from=ItemId to=ItemId fromIndex=Contracts)Active:true&facet.field=SellersString 3. note: there is {!te

Re: Join Parent and Child Documents

2015-08-01 Thread Mikhail Khludnev
On Sat, Aug 1, 2015 at 10:51 AM, Vineeth Dasaraju wrote: > Hi, > > I had indexed a nested json object into solr as a parent document with > child documents. Whenever I query for a term in the child document, I am > returned only the child documents. Is it possible to get the parent > document alo

Re: Join in SOLR

2014-12-31 Thread Jack Krupansky
available 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 Panneers

Re: Join in SOLR

2014-12-30 Thread Shawn Heisey
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, includi

Re: Join in SOLR

2014-12-30 Thread Mikhail Khludnev
Rajesh, it seems you need the trunk to apply patch on. my favorite way to do this is https://github.com/apache/lucene-solr/ Have a good hack! On Wed, Dec 31, 2014 at 10: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,

Re: Join in SOLR

2014-12-30 Thread Rajesh
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 at Nabble.c

Re: Join in SOLR

2014-12-30 Thread Shawn Heisey
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 t

RE: Join in SOLR

2014-12-30 Thread Rajesh
+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]> wrote: > Mikhail, > > How can I get a nightly bui

Re: Join in SOLR

2014-12-30 Thread Mikhail Khludnev
e 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

2014-12-30 Thread Rajesh
ucene] [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]> wrote: > > Yes Mikhail. This is what I want exactly. My sub-entities should be > add

Re: Join in SOLR

2014-12-17 Thread Mikhail Khludnev
ime soon? > Rajesh, it's 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 Pa

Re: Join in SOLR

2014-12-16 Thread Rajesh
Thanks Mikhail. As per what you have mentioned can I get a list of sub entities with this new Zipper join. Because in existing DIH I'm getting a list for individual fields of the sub entities. And also, I've not found DIH 5 jar anywhere. Is it still in development. -- View this message in con

Re: Join in SOLR

2014-12-12 Thread Mikhail Khludnev
On Fri, Dec 12, 2014 at 5:31 PM, Shawn Heisey 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 ... the dataimport han

Re: Join in SOLR

2014-12-12 Thread Shawn Heisey
On 12/12/2014 5:16 AM, Tomoko Uchida wrote: > I cannot find out your table structure and Solr schema, > but if your requirement is too complex to handle by DIH, you could handle > it by rich database functionality. > > I think creating a database view is good choice... > > (Of course, other exper

Re: Join in SOLR

2014-12-12 Thread Tomoko Uchida
I cannot find out your table structure and Solr schema, but if your requirement is too complex to handle by DIH, you could handle it by rich database functionality. I think creating a database view is good choice... (Of course, other experts may have ideas using DIH?) 2014-12-12 20:43 GMT+09:0

Re: Join in SOLR

2014-12-12 Thread Rajesh
Yes. two entities are child for the first one. I've gone through the link. But what I can get out of the configuration given in that link is, I could get an array for all the individual fields defined in the sub-entities. For. e.g if my sub-entity has 3 fields name, id, desc. I'm getting a list for

Re: Join in SOLR

2014-12-12 Thread Tomoko Uchida
Thank you for config information. Three tables have relation (by foreign key) ? You might want to have one nested tag in rather than 3 one in . By using nested tag, you may able to merge tables *before* importing them to Solr. All works done by SQL. You have already seen this wiki? If not, ex

Re: Join in SOLR

2014-12-12 Thread Rajesh
Thanks for your reply Tomoko. My data-config file looks like the below. 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 in context: http://lucene.472066.n3.nabble.com/Join-in-SOLR-

Re: Join in SOLR

2014-12-11 Thread Tomoko Uchida
Hi, I cannot guess what is 'entities' in your context, but do you want some kind of join functionality like RDBs on Solr? Basically, Solr is not "relational". So at first, you should consider denormalize your RDB tables to one table/view (or issue SQL JOIN query in DIH) to import data to Solr. If

Re: join on same field in same core

2014-09-23 Thread Mikhail Khludnev
https://wiki.apache.org/solr/Join did you check it? On Thu, Sep 18, 2014 at 4:52 PM, abhayd wrote: > hi All, > I am solr schema like > > id | task > 1|t1 > 1|t2 > 2|t2 > 2|t3 > > I would like to get all the id's where task t2 & t1 are associated with > same > id. Is there anyway we can do inner

Re: Join and non-Join query give different results

2014-07-19 Thread atawfik
I have figured it out. The reason is simply the type of join in Solr. It is an outer join. Since both filter queries are executed separately, a house that has available documents with discount > 1 or (sd_year:2014 AND sd_month:11) will be returned even though my intention was applying bother cond

Re: Join in solr to get data from two cores

2014-05-16 Thread Erick Erickson
Please read: http://wiki.apache.org/solr/UsingMailingLists and the contained link: http://catb.org/~esr/faqs/smart-questions.html On Tue, May 13, 2014 at 12:03 AM, Kamal Kishore wrote: > NO reply from anybody..seems strange ? > > > On Fri, May 9, 2014 at 9:47 AM, Kamal Kishore > wrote: > >> Any

Re: Join in solr to get data from two cores

2014-05-14 Thread Alvaro Cabrerizo
There are two previous threads in the list that i think can help you, http://mail-archives.apache.org/mod_mbox/lucene-solr-user/201405.mbox/%3c1398929537117-4134045.p...@n3.nabble.com%3E http://mail-archives.apache.org/mod_mbox/lucene-solr-user/201404.mbox/%3c20140403114242.horde.epx2xawezs3mvmt

Re: Join in solr to get data from two cores

2014-05-13 Thread Erick Erickson
You really have to provide more detail here. bq: Moreover, solr is not allowing to get data from both the core. What do you mean? the second core is unavailable? Solr joins do not return data from the "from" table. I really suggest you try denormalizing the data first, don't try to use Solr like

Re: Join in solr to get data from two cores

2014-05-13 Thread Walter Underwood
Probably because we answered a nearly identical request yesterday. It had items in one core and counts in a different. Please read all the responses to this e-mail. http://mail-archives.apache.org/mod_mbox/lucene-solr-user/201405.mbox/browser Specifically, these responses: http://mail-archives

Re: Join in solr to get data from two cores

2014-05-13 Thread Kamal Kishore
Any updates guys ? On Thu, May 8, 2014 at 2:05 PM, Kamal Kishore 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

Re: Join in solr to get data from two cores

2014-05-13 Thread Kamal Kishore
NO reply from anybody..seems strange ? On Fri, May 9, 2014 at 9:47 AM, Kamal Kishore wrote: > Any updates guys ? > > > On Thu, May 8, 2014 at 2:05 PM, Kamal Kishore > wrote: > >> Dear Team, >> >> I have two solr cores. One containing products information and second has >> customers points. I am

Re: Join solr

2014-04-24 Thread hungctk33
Thanks reply ! I use Solr to name products for storing search information, and core categories I use for reference, because it CATEGORY_NAME fields. to use the sort asc | desc. If so, the field CATEGORY_NAME on products later CATEGORY_NAME I edit. with 10 million rows is very dangerous. -

Re: Join solr

2014-04-24 Thread Aman Tandon
First of all here are the something that might help others to understand your problem. - what is your current logic - what you are trying to achieve? - what problem you are facing in achieving the results? - mail's subject I am not familiar that we can do sort by query of the results

Re: Join solr

2014-04-24 Thread hungctk33
Thanks Kranti Parisa ! I have 2 core : products(id, product_name, category_id ); categories(category_id, category_name); query similar SQL: SELECT p.* from Products AS p Inner join Categories AS c ON p.category_id = c.category_id Order by c.category_name asc; Purpose sorting by category_name,

Re: Join solr

2014-04-24 Thread Kranti Parisa
Can you describe what is your business requirement (how'z your data indexed, what is the request and what should be the response). and give us some examples. If you want to sort the results of the first core based on the sorting preference of the second core that you are joining with, that doesn't

Re: Join solr

2014-04-24 Thread hungctk33
Pls! Help me. -- View this message in context: http://lucene.472066.n3.nabble.com/Join-solr-tp4132615p4132830.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Join solr

2014-04-22 Thread hungctk33
http://localhost:8081/solr/products/select?q={!join+from=category_id+to=category_id fromIndex=categories v=$vk}*:*&vk=(sort= category_name+desc) products( id, name, category_id); categories( category_id, category_name) order by desc|asc category_name -- View this message in context: http:/

Re: Join solr

2014-04-22 Thread Alexandre Rafalovitch
Sorry, it is not clear what the issue actually is, what you tried to do to solve it and where specifically you are stuck. Please review http://wiki.apache.org/solr/UsingMailingLists , it will help you to ask a better question and get a better answer. Start from better subject once you reviewed the

Re: Join solr

2014-04-22 Thread hungctk33
Pls, Help me ! -- View this message in context: http://lucene.472066.n3.nabble.com/Join-solr-tp4132615p4132625.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Join solr multi core select field mixed other core

2014-04-22 Thread Alvaro Cabrerizo
Hi, Please, check using ...q={!join+to=cat_id+from=id+fromIndex=category}name:*... Regards. On Tue, Apr 22, 2014 at 3:37 AM, hungctk33 wrote: > Hi . all. I has table > Product (id, name, cat_id) > Category (id, name); > > Select pro.id, pro.name, cat.name from Product as pro inner join Catego

Re: join and filter query with AND

2014-03-24 Thread Kranti Parisa
> embedded nested query parsers . That's a fairly new feature compared > to > > > > non-embedded nested query parsers - maybe Yonik could shed some > light. > > > This > > > > may date from when he made a copy of the Lucene query parser for Solr > &g

Re: join and filter query with AND

2014-03-24 Thread Marcin Rzewucki
is > > > may date from when he made a copy of the Lucene query parser for Solr > and > > > added the parsing of embedded nested query parsers to the grammar. It > > seems > > > like the embedded nested query parser is only being applied to a > single, > > > whit

Re: join and filter query with AND

2014-03-21 Thread Kranti Parisa
grammar. It > seems > > like the embedded nested query parser is only being applied to a single, > > white space-delimited term, and not respecting the fact that the term is > a > > quoted phrase. > > > > -- Jack Krupansky > > > > -Original Message--

Re: join and filter query with AND

2014-03-21 Thread Yonik Seeley
; > -- Jack Krupansky > > -Original Message- From: Marcin Rzewucki > Sent: Thursday, March 20, 2014 5:19 AM > To: solr-user@lucene.apache.org > Subject: Re: join and filter query with AND > > > Nope. There is no line break in the string and it is not feed from

Re: join and filter query with AND

2014-03-21 Thread Jack Krupansky
arcin Rzewucki Sent: Thursday, March 20, 2014 5:19 AM To: solr-user@lucene.apache.org Subject: Re: join and filter query with AND Nope. There is no line break in the string and it is not feed from file. What else could be the reason ? On 19 March 2014 17:57, Erick Erickson wrote: It looks

Re: join and filter query with AND

2014-03-21 Thread Kranti Parisa
You may try this (({!join from=inner_id to=outer_id fromIndex=othercore v=$joinQuery} And pass another parameter joinQuery=(city:"Stara Zagora" AND prod:214) Thanks, Kranti K. Parisa http://www.linkedin.com/in/krantiparisa On Fri, Mar 21, 2014 at 4:47 AM, Marcin Rzewucki wrote: > Hi, > > Eri

Re: join and filter query with AND

2014-03-21 Thread Marcin Rzewucki
Hi, Erick, I do not get your point. What kind of servlet container settings do you mean and why do you think they might be related ? I'm using Jetty and never set any limit for packet size. My query does not work only in case of double quotes and space between words. Why? It works in other cases a

Re: join and filter query with AND

2014-03-20 Thread Erick Erickson
Well, the error message really looks like your input is getting chopped off. It's vaguely possible that you have some super-low limit in your servlet container configuration that is only letting very small packets through. What I'd do is look in the Solr log file to see exactly what is coming thr

Re: join and filter query with AND

2014-03-20 Thread Marcin Rzewucki
Nope. There is no line break in the string and it is not feed from file. What else could be the reason ? On 19 March 2014 17:57, Erick Erickson wrote: > It looks to me like you're feeding this from some > kind of text file and you really _do_ have a > line break after "Stara > > Or have a line

Re: join and filter query with AND

2014-03-19 Thread Erick Erickson
It looks to me like you're feeding this from some kind of text file and you really _do_ have a line break after "Stara Or have a line break in the string you paste into the URL or something similar. Kind of shooting in the dark though. Erick On Wed, Mar 19, 2014 at 8:48 AM, Marcin Rzewucki wro

Re: Join Scoring

2014-02-13 Thread anand chandak
Thanks Mike, that surely helps to clarify the difference. On the related note, if we have provide a scoring support for solr join, instead of using lucene join, what would be best way to do that . There's one suggestion that david gave below :- build a custom QParser and call Lucene's JOIN (J

Re: Join Scoring

2014-02-13 Thread Michael McCandless
I suspect (not certain) one reason for the performance difference with Solr vs Lucene joins is that Solr operates on a top-level reader? This results in fast joins, but it means whenever you open a new reader (NRT reader) there is a high cost to regenerate the top-level data structures. But if th

Re: Join Scoring

2014-02-12 Thread anand chandak
Re-posting... Thanks, Anand On 2/12/2014 10:55 AM, anand chandak wrote: Thanks David, really helpful response. You mentioned that if we have to add scoring support in solr then a possible approach would be to add a custom QueryParser, which might be taking Lucene's JOIN module. I have t

Re: Join Scoring

2014-02-11 Thread anand chandak
Thanks David, really helpful response. You mentioned that if we have to add scoring support in solr then a possible approach would be to add a custom QueryParser, which might be taking Lucene's JOIN module. Curious, if it is possible instead to enhance existing solr's JoinQParserPlugin and

Re: Join Scoring

2014-02-11 Thread David Smiley (@MITRE.org)
Hi Anand. Solr's JOIN query, {!join}, constant-scores. It's simpler and faster and more memory efficient (particularly the worse-case memory use) to implement the JOIN query without scoring, so that's why. Of course, you might want it to score and pay whatever penalty is involved. For that you'

Re: Join Scoring

2014-02-05 Thread anand chandak
Resending, if somebody can please respond. Thanks, Anand On 2/5/2014 6:26 PM, anand chandak wrote: Hi, Having a question on join score, why doesn't the solr join query return the scores. Looking at the code, I see there's JoinScorer defined in the JoinQParserPlugin class ? If its not used

Re: Join Query Behavior

2013-10-25 Thread Andy Pickler
If it helps to clarify any, here's the full query: /select ? q=*:* & fq=type:ProjectGroup & fq={!join from=project_id_i to=project_id_im}user_id_i:65615 -role_id_i:18 type:UserRole We have two Solr servers that were indexed from the same database. One of the servers is running Solr 4.2, while th

Re: join not working with UUIDs

2013-07-10 Thread Marcelo Elias Del Valle
Worked :D Thanks a lot! 2013/7/10 Marcelo Elias Del Valle > root_id is a dynamic field... But should the type of the field change > according to the values? Because using the same configuration but using > "room1" as value, it works. > > Let me compare the configurations: > >

Re: join not working with UUIDs

2013-07-10 Thread Marcelo Elias Del Valle
root_id is a dynamic field... But should the type of the field change according to the values? Because using the same configuration but using "room1" as value, it works. Let me compare the configurations: Indeed, one is text_general and the other is string... I will try to create a fixed fiel

Re: join not working with UUIDs

2013-07-10 Thread Erick Erickson
What kind of field is root_id? If it's tokenized or not the same type as id, that could account for it. Best Erick On Tue, Jul 9, 2013 at 7:34 PM, Marcelo Elias Del Valle wrote: > Hello, > > I am trying to create a POC to test query joins. However, I was > surprised when I saw my test worked

Re: join not working with UUIDs

2013-07-09 Thread Jack Krupansky
Oops... I misread and confused your "q" and "fq" params. -- Jack Krupansky -Original Message- From: Jack Krupansky Sent: Tuesday, July 09, 2013 7:47 PM To: solr-user@lucene.apache.org Subject: Re: join not working with UUIDs Your join is requesting to use the &q

Re: join not working with UUIDs

2013-07-09 Thread Jack Krupansky
Your join is requesting to use the "join_id" field ("from") of documents matching the query of "cor_parede:branca", but the join_id field of that document is empty. Maybe you intended to search in the other direction, like "acessorio1:Teclado". -- Jack Krupansky -Original Message-

Re: Join across cores on same shard.

2013-02-02 Thread Yonik Seeley
On Sat, Feb 2, 2013 at 5:49 AM, Marcin Rzewucki wrote: > I meant I get fields from parent core only. Is it possible to get fields > from both cores using join query? Not yet. Joins are currently only for filtering. -Yonik http://lucidworks.com

  1   2   >