Ok, then it sounds like a different issue. Let's look at the logs following a request and see what the issue is. There will be a log record that shows the query that is sent to Solr by the fetch expression. When we look at that log we'll be able to see what the query is, and if results are returned. It could be a bug in the code or it could be something related to the data that's being fetched.
Joel Bernstein http://joelsolr.blogspot.com/ On Sat, Jul 20, 2019 at 5:21 PM Ahmed Adel <aa.0...@gmail.com> wrote: > To validate this, I indexed the datasets and ran the same query on Solr > 6.5.0 environment (https://archive.apache.org/dist/lucene/solr/6.5.0/) > before cb9f15 commit gets into release but got the same response, no > additional fields, as Solr 8.1.1. I have used the default managed schema > settings in both Solr versions, which I guess means qparser is not used for > /select in this case, is it? > > On Sat, Jul 20, 2019 at 2:02 AM Joel Bernstein <joels...@gmail.com> wrote: > > > I suspect fetch is having problem due to this commit: > > > > > > > https://github.com/apache/lucene-solr/commit/cb9f151db4b5ad5c5f581b6b8cf2e5916ddb0f35#diff-98abfc8855d347035205c6f3afc2cde3 > > > > Later local params were turned off for anything but the lucene qparser. > > Which means this query doesn't work if /select is using edismax etc... > > > > This needs to be fixed. > > Can you check to see if the qparser is for the /select handler on your > > install? > > > > Anyway fetch needs to be reverted back to it's previous implementation > > before the above commit basically broke it. > > > > > > > > > > Joel Bernstein > > http://joelsolr.blogspot.com/ > > > > > > On Fri, Jul 19, 2019 at 2:20 PM Ahmed Adel <aa.0...@gmail.com> wrote: > > > > > Hi - Tried swapping the equality sides but (surprisingly?) got the same > > > exact response. Any additional thoughts are appreciated. > > > > > > Best, > > > A. > > > http://aadel.io > > > > > > On Fri, Jul 19, 2019 at 5:27 PM Joel Bernstein <joels...@gmail.com> > > wrote: > > > > > > > Try: > > > > > > > > fetch(names, > > > > select( > > > > nodes(emails, > > > > walk="john...@apache.org->from", > > > > gather="to"), > > > > node as to_s), > > > > fl="name", > > > > on="to_s=email") > > > > > > > > > > > > According to the docs it looks like you have the fields reversed on > the > > > > fetch. If that doesn't work, I'll investigate further. > > > > > > > > > > > > > > > > > > > > Joel Bernstein > > > > http://joelsolr.blogspot.com/ > > > > > > > > > > > > On Fri, Jul 19, 2019 at 5:51 AM Ahmed Adel <aa.0...@gmail.com> > wrote: > > > > > > > > > Hi Joel, > > > > > > > > > > Thank you for your thoughts. I tried the fetch function, however, > the > > > > > response does not contain "fl" fields of the "fetch" expression. > For > > > the > > > > > above example, the modified query is as follows: > > > > > > > > > > fetch(names, select(nodes(emails, > > > > > walk="john...@apache.org->from", > > > > > gather="to"), node as to_s), fl="name", on="email=to_s") > > > > > > > > > > > > > > > where "names" is a collection that contains two fields representing > > > pairs > > > > > of name and email: ("name", "email") > > > > > > > > > > The response returned is: > > > > > > > > > > { "result-set": { "docs": [ { "to_s": "john...@apache.org" > > > > > }, { "to_s": "johnsm...@apache.org" > > > > > }, > > > > > ... { "EOF": true, "RESPONSE_TIME": 33 } ] } } > > > > > > > > > > The response should have an additional "name" field in each > document > > > > > returned. Any additional thoughts are appreciated. > > > > > > > > > > Best, > > > > > A. > > > > > > > > > > On Thu, Jul 18, 2019 at 6:12 PM Joel Bernstein <joels...@gmail.com > > > > > > wrote: > > > > > > > > > > > Hi Ahmed, > > > > > > > > > > > > Take a look at the fetch > > > > > > > > > > > > > > > > > > > > > > > > > > > https://lucene.apache.org/solr/guide/8_0/stream-decorator-reference.html#fetch > > > > > > > > > > > > It probably makes sense to allow more field to be returned from a > > > nodes > > > > > > expression as well. > > > > > > > > > > > > Joel Bernstein > > > > > > http://joelsolr.blogspot.com/ > > > > > > > > > > > > > > > > > > On Wed, Jul 17, 2019 at 3:12 AM Ahmed Adel <aa.0...@gmail.com> > > > wrote: > > > > > > > > > > > > > Hi, > > > > > > > > > > > > > > Thank you for your reply. Could you give more details on the > > „join“ > > > > > > > operation, such as what the sides of the join and the joining > > > > condition > > > > > > > would be in this case? > > > > > > > > > > > > > > Best regards, > > > > > > > A. > > > > > > > > > > > > > > On Tue, Jul 16, 2019 at 2:02 PM markus kalkbrenner < > > > > > > > markus.kalkbren...@biologis.com> wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > You have to perform a „join“ to get more fields. > > > > > > > > > > > > > > > > > Am 16.07.2019 um 13:52 schrieb Ahmed Adel < > aa.0...@gmail.com > > >: > > > > > > > > > > > > > > > > > > Hi, > > > > > > > > > > > > > > > > > > How can multiple fields be returned in graph traversal > > > streaming > > > > > > > > expression > > > > > > > > > response documents? For example, the following query: > > > > > > > > > > > > > > > > > > nodes(emails, > > > > > > > > > walk="john...@apache.org->from", > > > > > > > > > gather="to") > > > > > > > > > > > > > > > > > > > > > > > > > > > returns these documents in the response: > > > > > > > > > > > > > > > > > > { > > > > > > > > > "result-set": { > > > > > > > > > "docs": [ > > > > > > > > > { > > > > > > > > > "node": "sl...@campbell.com", > > > > > > > > > "collection": "emails", > > > > > > > > > "field": "to", > > > > > > > > > "level": 1 > > > > > > > > > }, > > > > > > > > > { > > > > > > > > > "node": "catherine.per...@enron.com", > > > > > > > > > "collection": "emails", > > > > > > > > > "field": "to", > > > > > > > > > "level": 1 > > > > > > > > > }, > > > > > > > > > { > > > > > > > > > "node": "airam.arte...@enron.com", > > > > > > > > > "collection": "emails", > > > > > > > > > "field": "to", > > > > > > > > > "level": 1 > > > > > > > > > }, > > > > > > > > > { > > > > > > > > > "EOF": true, > > > > > > > > > "RESPONSE_TIME": 44 > > > > > > > > > } > > > > > > > > > ] > > > > > > > > > } > > > > > > > > > } > > > > > > > > > > > > > > > > > > How can the query above be modified to return more document > > > > fields, > > > > > > > > > "subject" for example? > > > > > > > > > > > > > > > > > > Best regards, > > > > > > > > > > > > > > > > > > A. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > Sent from my iPhone > > > > > >
