Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of prabin.meitei@gmail.com
 designates 209.85.198.224 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=QGfjMNQ8i0ePQknqodFJ/RCP581HKKQV4pp+SfSEXGceWA8pDSmOJWaqFDpXb7vgNL
         xUaa428dj1JzZcv+12fmxPN8ZJZYEvQ27NUzMWcnQWC/E6kurJaONMBdQMxwtJ4oi6rr
         79z2LlUfsqudCIsuuAC2/S9s+Dy+dscXrKa7A=
Message-ID: <295da8fe0810161144p35b17d16k5ed411a5a945fa71@mail.gmail.com>
Date: Fri, 17 Oct 2008 00:14:53 +0530
From: "prabin meitei" <prabin.meitei@gmail.com>
To: java-user@lucene.apache.org
Subject: using list of items to be excluded while querying
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_20519_18943210.1224182693631"

------=_Part_20519_18943210.1224182693631
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,     I have a large index of documents of fields "id" "name" and few
other.
while querying i do want to exclude a list of ids i passed in.

for this what i use is
Query query = new BooleanQuery();

 for (int i=0; i<list.size(); i++){

                term = new Term("id", list.get(i).toString());

                termQuery = new TermQuery(term);

                query.add(termQuery, Occur.MUST_NOT);

            }


the problem with this is that when my list size grows larger (more than
1024) it gives tooManyBooleanCauses exception.


i tried by changing the query to

query.add(new QueryParser("id", new StandardAnalyzer()).parse(list.toString()),
Occur.MUST_NOT);


this also gives the same problem when list size is big.


I do not want to increase the max clause limit ('coz of performance issues)


Is there any simple solution to such problem?


Any suggestion will be greatly appreciated.


Prabin

------=_Part_20519_18943210.1224182693631--