Joins and text fields projection

2019-10-20 Thread Ahmed Adel
Hi, Is there a way to select text fields in a query with a join clause in Streaming Expressions or Parallel SQL? The following query: SELECT field_s, field_t FROM t1 INNER JOIN t2 ON t1.a = t2.a LIMIT 10 requires that field_t, which is of type text, have docValues enabled, which is not supported

Re: Understanding SOLR Joins

2018-05-31 Thread Mikhail Khludnev
On Tue, May 29, 2018 at 10:50 AM, Nancy Goyal <87.na...@gmail.com> wrote: > Hi, > > > I have implemented basic SOLR Joins between two collections. Currently in > my project implementation, we are getting data from multiple tables and > storing as single document in view an

Understanding SOLR Joins

2018-05-29 Thread Nancy Goyal
Hi, I have implemented basic SOLR Joins between two collections. Currently in my project implementation, we are getting data from multiple tables and storing as single document in view and indexing that view. We got a suggestion to implement the same with Joins but not sure if the same

Re: Combining complex joins with other criteria

2017-11-23 Thread Mikhail Khludnev
This is my pet peeve in Solr. When q={!join ..}all tokens goes into join qp but even if we put space in front of curly brace q= {!join ..}1st_only_token_goes_to_join_qp I remember there were some discussion in comments, but I believe it is not raised ever raised as a defect. We have some json query

Re: Combining complex joins with other criteria

2017-11-23 Thread David Frese
Am 23.11.17 um 20:13 schrieb Mikhail Khludnev: Hello, David. It should be like q=name:"Mike" AND {!join from=pid to=id v=$qq}&qq=city:"London" AND id:"a1" Thanks a lot! But this looks like working around a bug, given that >> {!join from=pid to=id}(city:"London" AND id:"a1") works fine. Is t

Re: Combining complex joins with other criteria

2017-11-23 Thread Mikhail Khludnev
Hello, David. It should be like q=name:"Mike" AND {!join from=pid to=id v=$qq}&qq=city:"London" AND id:"a1" On Thu, Nov 23, 2017 at 10:06 PM, David Frese wrote: > Hi there everbody, > > I want to combine joins with multiple criteria and other criteri

Combining complex joins with other criteria

2017-11-23 Thread David Frese
Hi there everbody, I want to combine joins with multiple criteria and other criteria, with variying boolean operators, but I keep getting "org.apache.solr.search.SyntaxError: Cannot parse" errors. I tried with an installation of version 6.3, and also with the embedded server in v

Re: Two joins from different cores with OR

2017-09-15 Thread Erick Erickson
e down why you are getting the results you are. Best, Erick On Fri, Sep 15, 2017 at 2:02 AM, Сергей Твердохлеб wrote: > Hi all, > > I have two joins and I need to link them using OR statement. > > The first one is > >> fq={!join fromIndex=master_Category_flip

Two joins from different cores with OR

2017-09-15 Thread Сергей Твердохлеб
Hi all, I have two joins and I need to link them using OR statement. The first one is > fq={!join fromIndex=master_Category_flip from=manufactureName_string > to=nameString_string}visibility_string_mv:"Test_B2BUnit" AND > itemtype_string:"Model" which returns resu

Re: Joins in Parallel SQL?

2017-07-18 Thread Erick Erickson
apability? What part of > developer documentation would be suitable for this? > > Regards, > Imran > > Sent from Mail for Windows 10 > > From: Joel Bernstein > Sent: Thursday, July 6, 2017 7:40 AM > To: solr-user@lucene.apache.org > Subject: Re: Joins in Parallel SQ

RE: Joins in Parallel SQL?

2017-07-17 Thread imran
Is it possible to contribute towards building this capability? What part of developer documentation would be suitable for this? Regards, Imran Sent from Mail for Windows 10 From: Joel Bernstein Sent: Thursday, July 6, 2017 7:40 AM To: solr-user@lucene.apache.org Subject: Re: Joins in Parallel

Re: Joins in Parallel SQL?

2017-07-06 Thread Joel Bernstein
Joins and OFFSET are not currently supported with Parallel SQL. The docs for parallel SQL cover all the supported features. Any syntax not covered in the docs is likely not supported. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Jul 6, 2017 at 2:40 PM, wrote: > > Is it possi

Joins in Parallel SQL?

2017-07-05 Thread imran
Is it possible to join documents from different collections through Parallel SQL? In addition to the LIMIT feature on Parallel SQL, can we do use OFFSET to implement paging? Thanks, Imran Sent from Mail for Windows 10

Re: Joins using graph queries - solr 6.0

2017-05-22 Thread mganeshs
. So just curious whether graph works for you and can you share me your sample data and query you use to traverse the graph? Thanks, -- View this message in context: http://lucene.472066.n3.nabble.com/Joins-using-graph-queries-solr-6-0-tp4336214p4336455.html Sent from the Solr - User mailing list

Joins using graph queries - solr 6.0

2017-05-21 Thread thiaga rajan
Hi - We are having a tree based structure in solr and we are using solr graph queries to perform some search in our usecases. Example - {! graph from=xx to=yy} we got a new requirement like we need to search last level nodes based on some parents in the tree and those last level nodes needs to b

Is it possible to make multiple joins on Solr?

2016-11-08 Thread Lucas Cotta
I was able to implement one join (https://wiki.apache.org/solr/Join) in my query but I couldn't find the correct syntax to use multiple joins... is that possible? Could someone please give me some example? Thanks!

Re: OR two joins

2016-10-21 Thread Mathias
roject_uuid to=id v=$q1} OR {!join > from=project_uuid to=id v=$q2} > &q1=type:EM_PM_Timerecord AND > created:[2015-01-01T01:00:00Z TO 2016-01-01T01:00:00Z] > &q2=type:EM_CM_Request_Member AND > created:[2015-01-01T01:00:00Z TO 2016-01-01T01:00:00Z] > > -Yonik Thank you, this works great. Mathias -- View this message in context: http://lucene.472066.n3.nabble.com/OR-two-joins-tp4302415p4302455.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: OR two joins

2016-10-21 Thread Yonik Seeley
On Fri, Oct 21, 2016 at 7:07 AM, Mathias wrote: > With the first version I get the fallowing error: > > "org.apache.solr.search.SyntaxError: Cannot parse '(type:EM_PM_Timerecord': > Encountered \"\" at line 1, column 22.\nWas expecting one of:\n > ...\n ...\n ...\n\"+\" ...\n\"-\"

Re: OR two joins

2016-10-21 Thread Mathias
...\n ...\n\"(\" ...\n\")\" ...\n\"*\" ...\n\"^\" ...\n ...\n ...\n ...\n ...\n ...\n ...\n\"[\" ...\n\"{\" ...\n ...\n\"filter(\" ...\n ...\n" With the second version

Re: OR two joins

2016-10-21 Thread Mikhail Khludnev
7;t return any documents, but if I use only one of the joins e.g.: > > {!join from=project_uuid to=id}type:EM_PM_Timerecord AND > created:[2015-01-01T01:00:00Z TO 2016-01-01T01:00:00Z] > > It returns some documents. > > If I remove the date ranges it works as well: > > ({

Re: OR two joins

2016-10-21 Thread Mathias
I tested it with solr version 6.1.0 and 6.2.1. Thanks, Mathias -- View this message in context: http://lucene.472066.n3.nabble.com/OR-two-joins-tp4302415p4302416.html Sent from the Solr - User mailing list archive at Nabble.com.

OR two joins

2016-10-21 Thread Mathias
n any documents, but if I use only one of the joins e.g.: {!join from=project_uuid to=id}type:EM_PM_Timerecord AND created:[2015-01-01T01:00:00Z TO 2016-01-01T01:00:00Z] It returns some documents. If I remove the date ranges it works as well: ({!join from=project_uuid to=id}type:EM_PM_Timerecor

Re: Solr 6.2 Distributed joins

2016-10-05 Thread Joel Bernstein
hashJoins and mergeJoins in streaming expressions. If it doesn't say hash in the function name than it's a merge join. The merge joins require the underlying streams be sorted by the join keys. The hashJoins do not require specific sorts. This is an important distinction if you need to gro

Solr 6.2 Distributed joins

2016-10-05 Thread Gurdeep Singh
Hello all, I am exploring one of Solr 6.2 new feature (stream decorators) for one of my application and the "leftOuterJoin" is working as expected. (joining two streams and getting the data from both the collections) I need to know if group query works with these distributed joins or

Re: SQL Joins in Parallel SQL Interface

2016-09-14 Thread Joel Bernstein
Hi, Parallel SQL does not yet support joins but Streaming Expressions does. There are 4 types of aggregations in Streaming Expression currently. The functions are: facet: group by aggregations pushed down to the JSON facet API. Will not work with joins. https://cwiki.apache.org/confluence

SQL Joins in Parallel SQL Interface

2016-09-14 Thread Aswath Srinivasan (TMS)
Hello, I'm exploring the Parallel SQL. I don't see any SQL JOIN features available in the parallel SQL interface, in the documentation. Is it even possible to do SQL JOIN in the parallel SQL interface? Was looking at streaming expression but looks like facets are not possible with it. Not even

Re: Solr 4.10 Joins: Slow performance with millions of documents

2016-08-15 Thread Mikhail Khludnev
e state I'm looking for. With all other filters applied, > the total result set is around 5000 documents. The query takes around 10 > seconds. > > After reading up on how Joins are essentially just subqueries, I understand > why my original approach would be slow. However,

Solr 4.10 Joins: Slow performance with millions of documents

2016-08-14 Thread Tim Frey
Interviews in the state I'm looking for. With all other filters applied, the total result set is around 5000 documents. The query takes around 10 seconds. After reading up on how Joins are essentially just subqueries, I understand why my original approach would be slow. However, whe

Re: Streaming Expression joins not returning all results

2016-05-16 Thread Ryan Cutter
t java.io.OutputStream.write(OutputStream.java:116) > > > >>> > > > >>> at sun.nio.cs.StreamEncoder.writeBytes(StreamEncoder.java:221) > > > >>> > > > >>> at sun.nio.cs.StreamEncoder.implWrite(StreamEncoder.java:282) > > > >

Re: Streaming Expression joins not returning all results

2016-05-16 Thread Joel Bernstein
amWriter.write(OutputStreamWriter.java:207) > > >>> > > >>> at org.apache.solr.util.FastWriter.flush(FastWriter.java:140) > > >>> > > >>> at org.apache.solr.util.FastWriter.write(FastWriter.java:54) > > >>> > > &

Re: Streaming Expression joins not returning all results

2016-05-16 Thread Ryan Cutter
.java:420) > >>> > >>> at > >>> > >>> > org.apache.solr.response.JSONWriter.writeSolrDocument(JSONResponseWriter.java:364) > >>> > >>> at > >>> > >>> > org.apache

Re: Streaming Expression joins not returning all results

2016-05-15 Thread Joel Bernstein
.writeVal(TextResponseWriter.java:150) >>> >>> at >>> >>> org.apache.solr.response.JSONWriter.writeNamedListAsMapWithDups(JSONResponseWriter.java:183) >>> >>> On Fri, May 13, 2016 at 5:50 PM, Joel Bernstein >>> wrote: >>&

Re: Streaming Expression joins not returning all results

2016-05-15 Thread Joel Bernstein
ues for the fields for sorting and >> > exporting. >> > >> > Breaking down the query into it's parts will show where the issue is. >> Also >> > adding more heap might give you enough memory. >> > >> > In my testing the max docs

Re: Streaming Expression joins not returning all results

2016-05-15 Thread Joel Bernstein
> > > > In my testing the max docs per second I've seen the /export handler push > > from a single node is 650,000. In order to get 650,000 docs per second on > > one node you have to partition the stream with workers. In my testing it > > took 8 workers hitting one node to

Re: Streaming Expression joins not returning all results

2016-05-14 Thread Ryan Cutter
ers, you could export 52,000,000 docs per-second. With 40 > shards, 5 replicas and 40 workers you could export 130,000,000 docs per > second. > > So with large clusters you could do very large distributed joins with > sub-second performance. > > > > > Joel Bernstein >

Re: Streaming Expression joins not returning all results

2016-05-13 Thread Joel Bernstein
ou could export 130,000,000 docs per second. So with large clusters you could do very large distributed joins with sub-second performance. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, May 13, 2016 at 8:11 PM, Ryan Cutter wrote: > Thanks very much for the advice. Yes, I'm

Re: Streaming Expression joins not returning all results

2016-05-13 Thread Ryan Cutter
) Then try the full thing. > > If you're running a large join like this all on one host then you might not > have enough memory for the docValues and the two joins. In general > streaming is designed to scale by adding servers. It scales 3 ways: > > 1) Adding shards, splits

Re: Streaming Expression joins not returning all results

2016-05-13 Thread Joel Bernstein
running a large join like this all on one host then you might not have enough memory for the docValues and the two joins. In general streaming is designed to scale by adding servers. It scales 3 ways: 1) Adding shards, splits up the index for more pushing power. 2) Adding workers, partitions the str

Re: Streaming Expression joins not returning all results

2016-05-13 Thread Ryan Cutter
erJoin can parallelized across workers to improve performance. > Take a look at the docs on the parallel function for the details. > > 2) It looks like you might be doing graph operations with joins. You might > to take a look at the gatherNodes function coming in 6.1: > > ht

Re: Streaming Expression joins not returning all results

2016-05-13 Thread Joel Bernstein
A couple of other things: 1) Your innerJoin can parallelized across workers to improve performance. Take a look at the docs on the parallel function for the details. 2) It looks like you might be doing graph operations with joins. You might to take a look at the gatherNodes function coming in

Re: Streaming Expression joins not returning all results

2016-05-13 Thread Joel Bernstein
When doing things that require all the results (like joins) you need to specify the /export handler in the search function. qt="/export" The search function defaults to the /select handler which is designed to return the top N results. The /export handler always returns all results

Streaming Expression joins not returning all results

2016-05-13 Thread Ryan Cutter
Question #1: triple_type collection has a few hundred docs and triple has 25M docs. When I search for a particular subject_id in triple which I know has 14 results and do not pass in 'rows' params, it returns 0 results: innerJoin( search(triple, q=subject_id:1656521, fl="triple_id,subject_id

Re: Joins with SolrCloud

2015-12-11 Thread Joel Bernstein
s been added to searches so that results with the same userId are shuffled to the same worker node. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Dec 11, 2015 at 11:00 AM, Dennis Gove wrote: > Mugeesh, > > You can use Streaming Aggregation to provide various types of > cross-c

Re: Joins with SolrCloud

2015-12-11 Thread Dennis Gove
but that is not a requirement. On Fri, Dec 11, 2015 at 11:00 AM, Dennis Gove wrote: > Mugeesh, > > You can use Streaming Aggregation to provide various types of > cross-collection joins. This is currently available in trunk and will be a > part of Solr 6. > > To follow wit

Re: Joins with SolrCloud

2015-12-11 Thread Dennis Gove
Mugeesh, You can use Streaming Aggregation to provide various types of cross-collection joins. This is currently available in trunk and will be a part of Solr 6. To follow with your example, let's assume the following setup: Restaurants: avail on machine1:8983 with 3 shards, zk at zk1:2345

Joins with SolrCloud

2015-12-07 Thread Mugeesh Husain
. Client: is not interested to de-normalized data. Give some suggestion how to solved that problem. Thanks Mugeesh -- View this message in context: http://lucene.472066.n3.nabble.com/Joins-with-SolrCloud-tp4243957.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Block Joins

2015-12-02 Thread Mikhail Khludnev
exed. > > What do I want to achieve? The Block Joins we have been discussing were > giving me scores of 0.0, and I would like to get something a wee bit better > than that (not looking for accuracy yet). > > In the query below, I got some scores by putting {!score in the paren

Re: Block Joins

2015-12-02 Thread Rick Leir
Hi Mikhail Sorry, I should have noted "that" is a word in the OCR text that I have indexed. What do I want to achieve? The Block Joins we have been discussing were giving me scores of 0.0, and I would like to get something a wee bit better than that (not looking for accuracy yet). In

Re: Block Joins

2015-12-01 Thread Mikhail Khludnev
Rick, fl=score,[child parentFilter=type_s:book childFilter=*{!score=avg}*that], This childFilter value doesn't make sense. What do yo want to achieve? On Tue, Dec 1, 2015 at 7:28 PM, Rick Leir wrote: > Hi all, > Scoring is confusing me. Is the following correct? > > $ curl http://localhost:898

Re: Block Joins

2015-12-01 Thread Rick Leir
Hi all, Scoring is confusing me. Is the following correct? $ curl http://localhost:8983/solr/dorsetdata/query -d ' q={!parent which="content_type:parentDocument" *score=max*} type_s:page AND that& wt=json&indent=true& fl=score,[child parentFilter=type_s:book childFilter=*{!score=avg}*that ],canoni

Re: Block Joins

2015-12-01 Thread Rick Leir
On Mon, Nov 30, 2015 at 11:47 PM, wrote: > > I'd happy that it helps. You need to thank Varun who made [child]. There is > no performance impact for sure, it's a compromise or either nobody > considered it as an issue. You can raise a new JIRA and describe how it > should work in general and make

Re: Block Joins

2015-11-30 Thread Mikhail Khludnev
ND charlie& > wt=json&indent=true& > fl=score,[child parentFilter=type_s:book childFilter="charlie" > ],canonicalMaster,title,publisher,[docid]' > > Cheers -- Rick > > Re: Block Joins > > 118348 by: Rick Leir > > 118349 by:

Re: Block Joins

2015-11-30 Thread Rick Leir
nt"} type_s:page AND charlie& wt=json&indent=true& fl=score,[child parentFilter=type_s:book childFilter="charlie" ],canonicalMaster,title,publisher,[docid]' Cheers -- Rick Re: Block Joins > 118348 by: Rick Leir > 118349 by: Mikhail Khludnev &g

Re: Block Joins

2015-11-29 Thread Mikhail Khludnev
Hello Rick, If I got you right, it's worth to have a look at [child] https://cwiki.apache.org/confluence/display/solr/Transforming+Result+Documents Let me know if it works. On Sun, Nov 29, 2015 at 5:47 PM, Rick Leir wrote: > Hi all, > I am new to Block Joins, and am trying to follo

Fwd: Block Joins

2015-11-29 Thread Rick Leir
Hi all, I am new to Block Joins, and am trying to follow https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-BlockJoinQueryParsers This page shows two forms of block join syntax for this parser q={!child of=}. example queryq={!child of

Re: joins

2015-08-17 Thread Upayavira
The question as I read it was composite documents, not cross-collection joins. If the joined core is small enough to be replicated across all replicas of your main collection, then cross-core joining works well, as it is all within one instance. As to composite documents, I have sometimes

Re: joins

2015-08-17 Thread Erick Erickson
True, I haven't looked at it closely. Not sure where it is in the priority list though. However, I would recommend you _really_ look at _why_ you think you need cross-collection joins. Likely they will be expensive, and whether they're performant in your situation will be a question.

Re: joins

2015-08-16 Thread naga sharathrayapati
https://issues.apache.org/jira/browse/SOLR-7090 I see this jira open in support of joins which might solve the problem. On Sun, Aug 16, 2015 at 2:51 PM, Erick Erickson wrote: > bq: Is there any chance of this feature(merge the results to create a > composite > document) coming out in

Re: joins

2015-08-16 Thread Erick Erickson
e: > >> You can do what are called "pseudo joins", which are eqivalent to a >> nested query in SQL. You get back data from one core, based upon >> criteria in the other. You cannot (yet) merge the results to create a >> composite document. >> >> Upayavi

Re: joins

2015-08-16 Thread naga sharathrayapati
Is there any chance of this feature(merge the results to create a composite document) coming out in the next release 5.3 ? On Sun, Aug 16, 2015 at 2:08 PM, Upayavira wrote: > You can do what are called "pseudo joins", which are eqivalent to a > nested query in SQL. You get ba

Re: joins

2015-08-16 Thread Upayavira
You can do what are called "pseudo joins", which are eqivalent to a nested query in SQL. You get back data from one core, based upon criteria in the other. You cannot (yet) merge the results to create a composite document. Upayavira On Sun, Aug 16, 2015, at 06:02 PM, Nagasharath

Re: joins

2015-08-16 Thread Nagasharath
I exactly have the same requirement > On 13-Aug-2015, at 2:12 pm, Kiran Sai Veerubhotla wrote: > > does solr support joins? > > we have a use case where two collections have to be joined and the join has > to be on the faceted results of the two collections. is this possible?

joins

2015-08-13 Thread Kiran Sai Veerubhotla
does solr support joins? we have a use case where two collections have to be joined and the join has to be on the faceted results of the two collections. is this possible?

Re: Joins with comma separated values

2015-06-16 Thread Upayavira
You can potentially just use a text_general field, in which case your comma separated words will be effectively a multi-valued field. I believe that will work. As to how you want to use joins, that isn't possible. They are pseudo joins, not full joins. They will not be able to include data

Joins with comma separated values

2015-06-16 Thread Advait Suhas Pandit
Hi, We have some master data and some content data. Master data would be things like userid, name, email id etc. Our content data for example is a blog. The blog has certain fields which are comma separated ids that point to the master data. E.g. UserIDs of people who have commented on a particu

Joins with comma separated values

2015-06-15 Thread Advait Suhas Pandit
Hi, We have some master data and some content data. Master data would be things like userid, name, email id etc. Our content data for example is a blog. The blog has certain fields which are comma separated ids that point to the master data. E.g. UserIDs of people who have commented on a particu

Re: Slow cross-core joins

2015-03-03 Thread Mikhail Khludnev
Excuse me for hijacking: I raised https://issues.apache.org/jira/browse/LUCENE-6332. Please vote if you need. On Mon, Mar 2, 2015 at 11:04 PM, Matt B wrote: > I've recently inherited a Solr instance that is required to perform > numerous joins between two cores, usually as fil

Re: Slow cross-core joins

2015-03-03 Thread Matt B
a try for this join contrib patch > > > > https://issues.apache.org/jira/browse/SOLR-4787 > > > > > > > > On Mon, Mar 2, 2015 at 12:04 PM, Matt B wrote: > > > > > I've recently inherited a Solr instance that is required to perform > > &g

Re: Slow cross-core joins

2015-03-03 Thread Mikhail Khludnev
On Mon, Mar 2, 2015 at 11:04 PM, Matt B wrote: > There may be anywhere from one to one million documents in the lists core > matching any particular list_id. Matt, What about reverse cardinality of this relation? ie for particular listValue term, how many list_ids are associated? it's can be f

Re: Slow cross-core joins

2015-03-02 Thread William Bell
> > > On Mon, Mar 2, 2015 at 12:04 PM, Matt B wrote: > > > I've recently inherited a Solr instance that is required to perform > > numerous joins between two cores, usually as filter queries, similar to > the > > one below: > > > > q=firstName=Matt&a

Re: Slow cross-core joins

2015-03-02 Thread Gopal Patwa
You could give a try for this join contrib patch https://issues.apache.org/jira/browse/SOLR-4787 On Mon, Mar 2, 2015 at 12:04 PM, Matt B wrote: > I've recently inherited a Solr instance that is required to perform > numerous joins between two cores, usually as filter queries, sim

Slow cross-core joins

2015-03-02 Thread Matt B
I've recently inherited a Solr instance that is required to perform numerous joins between two cores, usually as filter queries, similar to the one below: q=firstName=Matt&fq=-({!to=emailAddress toIndex=accounts type=join fromIndex=lists from=listValue}list_id:38f2-351b-

Re: Solr Cloud Cross-Core Joins

2014-11-05 Thread Walter Underwood
I am curious why you are trying to do this with Solr. This is straightforward with other systems. I would use HBase for this. This could be really hard with Solr. wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ On Nov 5, 2014, at 5:08 PM, Steve Davids wrote: > I

Solr Cloud Cross-Core Joins

2014-11-05 Thread Steve Davids
I have a use-case where I would like to capture click events for individual users so I can answer questions like show me everything with x text and that I have clicked before + the inverse of show me everything with x text that I have *not* clicked. I am currently doing this by sticking the event i

Re: Sorting & Joins

2014-10-02 Thread Mikhail Khludnev
Hello, Did you look into https://issues.apache.org/jira/browse/SOLR-6234 ? On Fri, Oct 3, 2014 at 9:30 AM, Eric Katherman wrote: > Is it possible to join documents and use a field from the "from" documents > to sort the results? For example, I need to search "employees" and sort on > differe

Sorting & Joins

2014-10-02 Thread Eric Katherman
Is it possible to join documents and use a field from the "from" documents to sort the results? For example, I need to search "employees" and sort on different fields of the "company" each employee is joined to. What would that query look like? We've looked at various resources but haven't f

Highlighting Block Joins

2014-08-15 Thread StrW_dev
e:parent}q ) So is it possible to return the snippets based on the query in the parent? Do I need to tweak the code for this? Or is there an open isssue and thus work in progress? -- View this message in context: http://lucene.472066.n3.nabble.com/Highlighting-Block-Joins-tp4153165.html Sent fro

Re: Search results inconsistency when using joins

2014-07-29 Thread heaven
Yup, that's known, added it for future Solr releases. But seems this couldn't be a reason for such results discrepancy. -- View this message in context: http://lucene.472066.n3.nabble.com/Search-results-inconsistency-when-using-joins-tp4149810p4149925.html Sent from the Solr - Us

Re: Search results inconsistency when using joins

2014-07-29 Thread Yonik Seeley
The join qparser has no "fq" parameter, so that is ignored. -Yonik http://heliosearch.org - native code faceting, facet functions, sub-facets, off-heap data On Tue, Jul 29, 2014 at 12:12 PM, heaven wrote: > _query_:"{!join from=profile_ids_im to=id_i v=$qTweet107001860 > fq=$fqTweet107001860

Re: Search results inconsistency when using joins

2014-07-29 Thread heaven
Just tried to remove joins and it worked as expected: q: ( _query_:"{!edismax qf='name_small_ngram' mm='1'}-foundation -association -organization -hospital -charity -news -info" AND ( _query_:"{!edismax qf='name_small_ngram emails_words_ngra

Search results inconsistency when using joins

2014-07-29 Thread heaven
ords_text' mm='1'}+diabetes"" fqTweet106902440: "type:Tweet" qTweet106961560: "_query_:"{!edismax qf='keywords_text' mm='1'}+insulin"" fqTweet106961560: "type:Tweet" qTweet107001860: "_query_:"{!edismax qf='keywords_text' mm='1'}+glucose"" fqTweet107001860: "type:Tweet" => 1,036 matches But the last one gives almost 2 times more. Any suggestions are welcome. Thank you, Alexander -- View this message in context: http://lucene.472066.n3.nabble.com/Search-results-inconsistency-when-using-joins-tp4149810.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: How do I get faceting to work with Solr JOINs

2014-07-23 Thread Vinay B,
Thank You, Umesh ! That's a neat approach. Reading through your post, we decided to tweak our indexing strategy a bit, basically an inversion. We moved all our facetable (and frequently updated) fields to the main doc and the text and other static content fields to the sub doc (co-related via a pa

Re: How do I get faceting to work with Solr JOINs

2014-07-17 Thread Umesh Prasad
Hi Vinay, You can customize the FacetsComponent. Basically FacetComponent uses SimpleFacets to compute the facet count. It passes matched docset present in responsebuilder to SimpleFacets's constructor. 1. Build a mapping between parent space and auxiliary document space in (say an int array) a

How do I get faceting to work with Solr JOINs

2014-07-17 Thread Vinay B,
Some Background info : In our application, we have a requirement to update large number of records often. I investigated solr child documents but it requires updating both the child and the parent document . Therefore, I'm investigating adding frequently updated information in an "auxillary docume

Re: SOLR JOINS not working and not returning any data for simple query

2014-03-10 Thread Erick Erickson
omotive-Service-Solutions) wrote: > >> Hi All, >> >> I am facing a strange behavior with the Solr Server. All my joins are not >> working suddenly after a restart. Individual collections are returning the >> response but when I join the collection , I am getting zero do

Re: SOLR JOINS not working and not returning any data for simple query

2014-03-10 Thread William Bell
Send the queries. On Fri, Mar 7, 2014 at 2:32 PM, EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions) wrote: > Hi All, > > I am facing a strange behavior with the Solr Server. All my joins are not > working suddenly after a restart. Individual collections are returning th

SOLR JOINS not working and not returning any data for simple query

2014-03-07 Thread EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions)
Hi All, I am facing a strange behavior with the Solr Server. All my joins are not working suddenly after a restart. Individual collections are returning the response but when I join the collection , I am getting zero documents. Let me know if anyone have same type of issues.

Re: Min Number Should Match (mm) and joins

2014-03-06 Thread mm
Any suggestions? Zitat von m...@preselect-media.com: Hello, I'm using eDisMax to do scoring for my search results. I have a nested structure of documents. The main (parent) document with meta data and the child documents with fulltext content. So I have to join them. My qf looks like th

Min Number Should Match (mm) and joins

2014-03-04 Thread mm
Hello, I'm using eDisMax to do scoring for my search results. I have a nested structure of documents. The main (parent) document with meta data and the child documents with fulltext content. So I have to join them. My qf looks like this "title^40.0 subtitle^40.0 original_title^10.0 keywor

Re: solr joins

2014-02-07 Thread Mikhail Khludnev
> Also, if you can please elaborate on the segmented vs toplevel > http://vimeo.com/44113003 "Is Your Index Reader Really Atomic or Maybe Slow?" by Uwe Schindler > Thanks, > > Anand > > > > On 2/7/2014 4:53 PM, Mikhail Khludnev wrote: > >> Basicall

Re: solr joins

2014-02-07 Thread anand chandak
Thanks Mikhail, curious why was scoring left out of solr ? And if there's any plan to port it ? Also, if you can please elaborate on the segmented vs toplevel Thanks, Anand On 2/7/2014 4:53 PM, Mikhail Khludnev wrote: Basically, i am trying to understand where and how solr joins d

Re: solr joins

2014-02-07 Thread Mikhail Khludnev
>> Basically, i am trying to understand where and how solr joins differ from >> lucene joins. Any pointers, much appreciated ? >> >> Hello Anand, I'm keen for index-time joins (aka block joins), thus I've never looked into query-time ones. I even didn't

Re: solr joins

2014-02-02 Thread anand chandak
e limitation of solr join,does it means that unlike the traditional RDMS joins that can have columns from both the TO and FROM field, solr joins will only have fields from the TO documents ? Is my understanding correct ? Also, there's some difference with respect to scoring and towards that t

Re: solr joins

2014-02-01 Thread Ahmet Arslan
uments (ie: you can not return fields in the "from" documents as if they were a multivalued field on the "to" documents)". I am finding it hard to understand the above limitation of solr join,does it means that unlike the traditional RDMS joins that can have columns fr

solr joins

2014-01-31 Thread anand chandak
ou can not return fields in the "from" documents as if they were a multivalued field on the "to" documents)". I am finding it hard to understand the above limitation of solr join,does it means that unlike the traditional RDMS joins that can have columns from both the TO an

Re: Complication - can block joins help?

2014-01-28 Thread Mikhail Khludnev
On Mon, Jan 27, 2014 at 9:30 AM, William Bell wrote: > OK, > > In order to do boosting, we often will create a dynamic field in SOLR. For > example: > > A Professional hire out for work, I want to boost those who do > "woodworking". > > George Smith - builds chairs, and builds desks. He builds th

Re: Complication - can block joins help?

2014-01-27 Thread Alexandre Rafalovitch
Have you seen this one: http://hnagtech.wordpress.com/2013/04/19/using-payloads-with-solr-4-x/ ? Also, I can't tell where the "woodworking" as a term actually comes from. Maybe a bit more domain description would help. Regards, Alex. Personal website: http://www.outerthoughts.com/ LinkedIn: h

Re: Complication - can block joins help?

2014-01-27 Thread William Bell
Ideas? On Mon, Jan 27, 2014 at 12:10 AM, William Bell wrote: > Is there an example for using payloads for 4.6? > > Without any custom code for this? > > > On Sun, Jan 26, 2014 at 10:30 PM, William Bell wrote: > >> OK, >> >> In order to do boosting, we often will create a dynamic field in SOLR.

Re: Complication - can block joins help?

2014-01-26 Thread William Bell
Is there an example for using payloads for 4.6? Without any custom code for this? On Sun, Jan 26, 2014 at 10:30 PM, William Bell wrote: > OK, > > In order to do boosting, we often will create a dynamic field in SOLR. For > example: > > A Professional hire out for work, I want to boost those wh

Complication - can block joins help?

2014-01-26 Thread William Bell
OK, In order to do boosting, we often will create a dynamic field in SOLR. For example: A Professional hire out for work, I want to boost those who do "woodworking". George Smith - builds chairs, and builds desks. He builds the most desks in the country (350 a year). And his closest competitor d

  1   2   >