Re: Joins with SolrCloud
Hi Yonik, Thanks for the reply. It was very helpful. This may be a newb question but will this work on a individual rows of a query or do all the queries' results need to be on the same shard. ex. if the main query would return - user15 (shard 1) - user16 (shard 2) - user17 (shard 3) is it acceptable to have doc1 (shard 1) whatever (shard 2) yeah (shard 3) for a join of - user15, doc1 - user16, whatever - user17, yeah or do all the results of the main query need to reside on the same shard as all the results of join. Hopefully that's an understandable question. Thanks, slevytam -- View this message in context: http://lucene.472066.n3.nabble.com/Joins-with-SolrCloud-tp4073199p4075408.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Joins with SolrCloud
Hi Yonik, Can you offer any insight as to how one might ensure that documents reside on the same shard as the document you'd like them to join. For example: I'd like to do a simple join of user actions to a specific document. So, i would query for a list of documents and have the user actions on that document be attached for the current user. ie. liked etc Because I haven't figured out a reasonable way to accomplish this in Solr, I've been looking elsewhere. ie parent/child in elasticsearch. However, I have no problem forcing the appropriate useractions document to the same shard as the parent document, if I knew how. Thanks, slevytam -- View this message in context: http://lucene.472066.n3.nabble.com/Joins-with-SolrCloud-tp4073199p4075310.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Field Query After Collapse.Field?
Unfortunately not. That would require an object for every single entry for every single user. Generating millions of basically empty objects just for this query is likely impossible. :( -- View this message in context: http://lucene.472066.n3.nabble.com/Field-Query-After-Collapse-Field-tp4073691p4073976.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Field Query After Collapse.Field?
Hi Erick, I have no idea how I managed to get that working. I was messing around a lot. I may have added org.apache.solr.handler.component.CollapseComponent to an older version :- Unfortunately, I've formatted the server since to try some other options. I did find the official wiki page for the collapse.field feature. http://wiki.apache.org/solr/FieldCollapsingUncommitted I guess it was marked as duplicate for the 3.3 release; however, I cannot find anyway to collapse fields with the current options. (http://wiki.apache.org/solr/FieldCollapsing) Can you see anyway of doing this? Thanks, slevytam -- View this message in context: http://lucene.472066.n3.nabble.com/Field-Query-After-Collapse-Field-tp4073691p4073972.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Field Query After Collapse.Field?
Hi Erick, I actually did mean collapse.field, as per: http://blog.trifork.com/2009/10/20/result-grouping-field-collapsing-with-solr/ On high level I am trying to avoid the use of a join between a list of entries and a list of actions that users have performed on a entry (since it's not supported by distributed search). So I have a list of entries ie. entry_id, entry_content, etc And a list of actions users have performed on the entry ie. entry_id, entry_read, entry_starred I'm trying to combine these for pagination purposes. By doing a search for entry_id across the two cores (indexes) and then doing a collapse.field, I am able to get this nice list of results. However, I cannot figure out a way to then filter that list since q and fq happen before the collapse. Thanks, Shalom -- View this message in context: http://lucene.472066.n3.nabble.com/Field-Query-After-Collapse-Field-tp4073691p4073928.html Sent from the Solr - User mailing list archive at Nabble.com.
Field Query After Collapse.Field?
Hello, I've struggling to find a way to query after collapse.field is performed and I'm hoping someone can help. I'm doing a multiple core(index) search which generates results that can have varying fields. ex. entry_id, entry_starred entry_id, entry_read I perform a collapse.field on entry_id which yields: ex. entry_id, entry_starred, entry_read But if I try to do a fq on one of the fields ex. fq=!entry_read:1 The fq is performed before the collapse leading to incorrect results. Is there anyway to perform the field query after the results are collapsed? Thanks, slevytam -- View this message in context: http://lucene.472066.n3.nabble.com/Field-Query-After-Collapse-Field-tp4073691.html Sent from the Solr - User mailing list archive at Nabble.com.
