Is it possible to duplicate its functionality using existing expressions?
In SQL, while grouping you can just say first(column) to get some one-to-many
value if you don't care which one you get. Solr usually only has min,max,avg..
aggregation functions. If it had a "first" function I could just
Yes, the docs mention one-to-one and many-to-one fetches, but one-to-many
is not supported currently. I've never really been happy with fetch. It
really needs to be replaced with a standard nested loop join that handles
all scenarios.
Joel Bernstein
http://joelsolr.blogspot.com/
On Tue, Oct 13,
I think I found the reason right after asking (facepalm), but it took me days
to realize this.
I think fetch performs a naive "in" query, something like:
q="userid:(123123 123123123 12432423321323)&rows={batchSize}"
When userid to document relation is one-to-many, it is possible that above
que
Hi all,
I have a streaming expression looking like:
fetch(
myAlias,
top(
n=3,
various expressions here
sort="count(*) desc"
),
fl="username", on="userid=userid", batchSize=3
)
which fails to fetch username field for the 1st result:
{
"result-set":{
"docs":[{
"