Hey Doron,

It worked!!!! It worked!!!!

Thanks a lot for the help along with some valuable information about the API for creating queries. Will keep this in mind going ahead.

Rakesh Shete

Date: Wed, 19 Dec 2007 08:19:53 +0200
From: [email protected]
To: [email protected]
Subject: Re: Lucene multifield query problem

Hi Rakseh,

It just occurred to me that your code has
String searchCriteria = "Indoor*";

Assuming StandardAnalyzer used at indexing time, all text words were
lowercased. Now, QueryParser by default does not lowercase wildcard
queries. You can however instruct it to do so by calling:

(The only reason the first query returned anything was that MUST part,
which, as already discussed, was also sufficient for qualifying a doc.)

So, you should be able to get the "correct" results with something like
QueryParser qp = new QueryParser("i_title", new StandardAnalyzer());
Query q = qp.parse("+(i_title:Indoor* i_description:Indoor*)
-i_published:false +i_topicsClasses.id:1_1_*_*");

Also, note that the printed query for the 2nd attempt, where you used
is somewhat misleading. You may read that as if the query parser generated a

wildcard query, but actually it is not a wildcard query, just a termQuery,
to find this exact token 'i_title:Indoor*' with the asterisk character in
the index.

My additional recommendations to you are (1) also print the rewrite form of
query (q.rewrite(is.getIndexReader())) - there, for a wildcard query part,
you will see
how it was expanded with the terms that match the wildcard expression. You
will be able to see the lowercasing issue this way, and (2) If this still
work for you, please post here a tiny simple standalone program that creates
an index and searches it and demonstrates the problem.


On Dec 19, 2007 6:43 AM, Rakesh Shete wrote:

Hi Doren, Steve. Your suggestions make sense but dont give me the desired
results. Here is the code how I generate the query:

String searchCriteria = "Indoor*";QueryParser queryparser = new
QueryParser("i_title", new StandardAnalyzer());Query q1 =
queryparser.parse(searchCriteria);queryparser = new
QueryParser("i_description", new
StandardAnalyzer());Query q2 = queryparser.parse(searchCriteria);queryparser
= new QueryParser("i_published", new StandardAnalyzer());Query q3 =
queryparser.parse("false");queryparser = new
QueryParser("i_topicsClasses.id", new
StandardAnalyzer());Query topicQuery = queryparser.parse("1_1_*_*");BooleanQuery
booleanQuery = new BooleanQuery();booleanQuery.add(q1,

This produces the following query: i_title:indoor* i_description:indoor*
-i_published:false +i_topicsClasses.id:1_1_*_*
This gives me extra unwanted results from "+i_topicsClasses.id:1_1_*_*".

I modified the above code in the foll. manner:

Term t = new Term("i_title", searchCriteria);TermQuery termQuery = new
TermQuery(t);Term t1 = new Term("i_description", searchCriteria);TermQuery
termQuery1 = new TermQuery(t1);BooleanQuery booleanQuery1 = new
BooleanQuery();booleanQuery1.add(termQuery, BooleanClause.Occur.SHOULD);booleanQuery1.add(termQuery1,
BooleanClause.Occur.SHOULD);BooleanQuery booleanQuery = new
BooleanQuery();booleanQuery.add(booleanQuery1, BooleanClause.Occur.MUST);booleanQuery.add(q3,

This produces the following query:
+(i_title:Indoor* i_description:Indoor*) -i_published:false
But no results are fetched :(

Any hints if am I doing anything wrong?

Rakesh S

Date: Tue, 18 Dec 2007 23:09:09 +0200
From: [email protected]
To: [email protected]
Subject: Re: Lucene multifield query problem

Hi Rakesh,

Perhaps the confusion comes from the asymmetry
between +X and -X. I.e., for the query:
A B -C +D
one might think that, similar to how -C only disqualifies docs
containing C (but not qualifying docs not containing C), also
+D only disqualifies docs not containing D. But this is
inaccurate, because +D, in addition to disqualifying
docs not containing D, also qualifies docs containing D.

The modified query that Steven suggested:
+(A B) -C +D
removes this asymmetry, because specifying +(A B) means
that D is not anymore sufficient to qualify a doc.

Hope this helps (otherwise let this reply be forever disqualified : - ) )
On Dec 18, 2007 9:28 PM, Steven A Rowe wrote:

Hi Rakesh,

This doesn't look like a user-generated query. Have you considered
building the Query via the API instead of using QueryParser?

With QueryParser, you should get the results you want with syntax
+(i_title:indoor* OR i_description:indoor*) -i_published:false

Have you tried this yet?

On 12/18/2007 at 1:58 PM, Rakesh Shete wrote:

Thanks for the suggestion Steve. My problem is with getting
the correct results. Let me put in words the query :

Fetch all documents such that the search string "indoor*" is
either part of the 'i_title' field or 'i_description' field,
eliminate if not published (-i_published:false) but should
have topic id of the form "1_1_*_*" (i_topicsClasses.id:1_1_*_*)

i_title:indoor* i_description:indoor* -i_published:false
+i_topicsClasses.id:1_1_*_* returns me extra results which
should not be fetched.

-- Regards,
Rakesh Shete
Subject: RE: Lucene multifield query problem
Date: Tue, 18 Dec 2007 13:26:24 -0500
From: [email protected]
To: [email protected]

Hi Rakesh,

Set the default QueryParser operator to AND (default default
:) is OR):
On 12/18/2007 at 1:22 PM, Rakesh Shete wrote:

Hi all,

I am facing problem with the following multifield query:

i_title:indoor* i_description:indoor* -i_published:false

The above query returns me even results which should not be
there. Ideally I would like the query resullts as:

(i_title:indoor* i_description:indoor* -i_published:false)
AND (i_topicsClasses.id:1_1_*_*)

i.e. The intersection of the first part and second part.

But what is happening currently is that I get a union of the
first part and second part, i.e., whatever results are
returned by "i_title:indoor* i_description:indoor*
-i_published:false" are combined (union) with results
returned by "+i_topicsClasses.id:1_1_*_*".

How do I write a query that returns me results which are an
intersection of the above 2 parts?

Rakesh S

ads for free - to sell, rent or even buy.www.yello.in

To unsubscribe, e-mail: [email protected]
additional commands, e-mail: [email protected]
ads for free - to sell, rent or even buy.www.yello.in

To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Post free property ads on Yello Classifieds now! www.yello.in
Post free property ads on Yello Classifieds now! www.yello.in

Search Discussions

Discussion Posts


Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 9 of 9 | next ›
Discussion Overview
groupjava-user @
postedDec 18, '07 at 6:22p
activeDec 19, '07 at 12:34p



site design / logo © 2023 Grokbase