You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Kojo <rb...@gmail.com> on 2018/01/23 18:44:03 UTC
hashJoin - Multivalued field
I am trying to solve one problem, exactly as the case described here:
http://lucene.472066.n3.nabble.com/Streaming-expression-API-innerJoin-on-multi-valued-field-td4353794.html
I cannot accomplish that on Solr 6.6, my streaming expression returns
nothing:
hashJoin(
search(scholarship, zkHost="localhost:9983", q=*:*, fl="p_number",
sort="p_number asc"),
hashed=cartesianProduct(
search(articles, zkHost="localhost:9983", q=*:*, fq="processes:[1 TO
*]", fl="processes, id", sort="id asc"),
processes,
),
on="p_number=processes"
)
Both fields are of type string.
One strange thing is that if I filter the first query using fq, some
results appear.
hashJoin(
search(scholarship, zkHost="localhost:9983", q=*:*, fl="p_number",
sort="p_number asc", fq= "sch_id:905 OR sch_id:3487"),
hashed=cartesianProduct(
search(articles, zkHost="localhost:9983", q=*:*, fq="processes:[1 TO
*]", fl="processes, id", sort="id asc"),
processes,
),
on="p_number=processes"
)
{
"result-set": {
"docs": [
{
"processes": "00/01011-6",
"p_number": "00/01011-6",
"id": "43256"
},
{
"processes": "97/13133-4",
"p_number": "97/13133-4",
"id": "43256"
},
{
"EOF": true,
"RESPONSE_TIME": 343
}
]
}
}
Can you help me, please?
Re: hashJoin - Multivalued field
Posted by Kojo <rb...@gmail.com>.
I´am sorry, everything is working fine!
2018-01-23 16:44 GMT-02:00 Kojo <rb...@gmail.com>:
> I am trying to solve one problem, exactly as the case described here:
>
> http://lucene.472066.n3.nabble.com/Streaming-expression-API-innerJoin-on-
> multi-valued-field-td4353794.html
>
> I cannot accomplish that on Solr 6.6, my streaming expression returns
> nothing:
>
>
> hashJoin(
> search(scholarship, zkHost="localhost:9983", q=*:*, fl="p_number",
> sort="p_number asc"),
> hashed=cartesianProduct(
> search(articles, zkHost="localhost:9983", q=*:*, fq="processes:[1 TO
> *]", fl="processes, id", sort="id asc"),
> processes,
> ),
> on="p_number=processes"
> )
>
> Both fields are of type string.
>
>
> One strange thing is that if I filter the first query using fq, some
> results appear.
>
> hashJoin(
> search(scholarship, zkHost="localhost:9983", q=*:*, fl="p_number",
> sort="p_number asc", fq= "sch_id:905 OR sch_id:3487"),
> hashed=cartesianProduct(
> search(articles, zkHost="localhost:9983", q=*:*, fq="processes:[1 TO
> *]", fl="processes, id", sort="id asc"),
> processes,
> ),
> on="p_number=processes"
> )
>
>
>
> {
> "result-set": {
> "docs": [
> {
> "processes": "00/01011-6",
> "p_number": "00/01011-6",
> "id": "43256"
> },
> {
> "processes": "97/13133-4",
> "p_number": "97/13133-4",
> "id": "43256"
> },
> {
> "EOF": true,
> "RESPONSE_TIME": 343
> }
> ]
> }
> }
>
>
> Can you help me, please?
>