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 heaven <ah...@gmail.com> on 2014/07/29 18:12:56 UTC
Search results inconsistency when using joins
I was thinking these 2 queries should yield same results:
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_ngram
sites_words_ngram rss_categories_texts twitter_topics_text' mm='1'}+diabetes
+insulin +glucose"
OR
_query_:"{!join from=profile_ids_im to=id_i v=$qTweet98850340
fq=$fqTweet98850340}"
)
)
qTweet98850340: "_query_:"{!edismax qf='keywords_text' mm='1'}+diabetes
+insulin +glucose""
fqTweet98850340: "type:Tweet"
=> 619 matches
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_ngram
sites_words_ngram rss_categories_texts twitter_topics_text'
mm='1'}+diabetes"
OR
_query_:"{!join from=profile_ids_im to=id_i v=$qTweet106902440
fq=$fqTweet106902440}"
) AND (
_query_:"{!edismax qf='name_small_ngram emails_words_ngram
sites_words_ngram rss_categories_texts twitter_topics_text' mm='1'}+insulin"
OR
_query_:"{!join from=profile_ids_im to=id_i v=$qTweet106961560
fq=$fqTweet106961560}"
) AND (
_query_:"{!edismax qf='name_small_ngram emails_words_ngram
sites_words_ngram rss_categories_texts twitter_topics_text' mm='1'}+glucose"
OR
_query_:"{!join from=profile_ids_im to=id_i v=$qTweet107001860
fq=$fqTweet107001860}"
)
)
qTweet106902440: "_query_:"{!edismax qf='keywords_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: Search results inconsistency when using joins
Posted by heaven <ah...@gmail.com>.
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_ngram
sites_words_ngram rss_categories_texts twitter_topics_text' mm='1'}+diabetes
+insulin +glucose"
)
)
=> 143 matches
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_ngram
sites_words_ngram rss_categories_texts twitter_topics_text'
mm='1'}+diabetes"
) AND (
_query_:"{!edismax qf='name_small_ngram emails_words_ngram
sites_words_ngram rss_categories_texts twitter_topics_text' mm='1'}+insulin"
) AND (
_query_:"{!edismax qf='name_small_ngram emails_words_ngram
sites_words_ngram rss_categories_texts twitter_topics_text' mm='1'}+glucose"
)
)
=> 143 matches
--
View this message in context: http://lucene.472066.n3.nabble.com/Search-results-inconsistency-when-using-joins-tp4149810p4149814.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Search results inconsistency when using joins
Posted by heaven <ah...@gmail.com>.
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 - User mailing list archive at Nabble.com.
Re: Search results inconsistency when using joins
Posted by Yonik Seeley <yo...@heliosearch.com>.
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 <ah...@gmail.com> wrote:
> _query_:"{!join from=profile_ids_im to=id_i v=$qTweet107001860
> fq=$fqTweet107001860}"