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 aminmc@gmail.com designates
 74.125.82.48 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=references:in-reply-to:mime-version:content-transfer-encoding
         :content-type:message-id:cc:x-mailer:from:subject:date:to;
        b=Ii0t8K5+yq8z1JznhynVt2EOKe/i4ZoYkcDBbXKv8JGeh67ou9ODQ/2AAjGLb3e5vE
         2bHrKK5YwU5dZj5edKu4LYNL3EX/lyCcdyMRM4Gzz6Z/sE3/yXocnRlbCdzQWzZ5gyxe
         vkX2Z0Xnuwt64nXHDIjiG+MGzvbNnNto5PyoQ=
References: <50D99037-BFBE-4470-AD0B-40EF661530D9@gmail.com>
 <AANLkTikYCmnO_S+LOkkKhOfzqpPb3ewJFTEPGT4v3KRq@mail.gmail.com>
 <13D9053A-26BE-468C-A5CC-2327BC333D4B@gmail.com>
 <AANLkTikSVxDNX5vvJU4gzFgKV-Osni6fouLu5GpWeJAF@mail.gmail.com>
In-Reply-To: <AANLkTikSVxDNX5vvJU4gzFgKV-Osni6fouLu5GpWeJAF@mail.gmail.com>
Mime-Version: 1.0 (iPhone Mail 8B117)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii
Message-Id: <53592900-5E33-48E9-A956-F1A74FCF4FBB@gmail.com>
Cc: "java-user@lucene.apache.org" <java-user@lucene.apache.org>
From: Amin Mohammed-Coleman <aminmc@gmail.com>
Subject: Re: TermRangeQuery
Date: Fri, 26 Nov 2010 22:01:57 +0000
To: "java-user@lucene.apache.org" <java-user@lucene.apache.org>

Essentially I'd like to construct a query which is almost like SQL in clause=
.  The lucene document contains the id and a string value. I'd like to get t=
he string value based on the id key.  The ids may range within 1000. Is this=
 possible to do?

Thanks
Amin

Sent from my iPhone

On 26 Nov 2010, at 20:18, Ian Lea <ian.lea@gmail.com> wrote:

> What sort of ranges are you trying to use?  Maybe you could store a
> separate field, just for these queries, with some normalized form of
> the ids, with all numbers padded out to the same length etc.
>=20
> --
> Ian.
>=20
> On Fri, Nov 26, 2010 at 4:34 PM, Amin Mohammed-Coleman <aminmc@gmail.com> w=
rote:
>> Hi
>>=20
>> Unfortunately my range query approach did not work.   It seems to be rela=
ted to the ids themselves.  The list has ids that look this:
>>=20
>>=20
>> ID-NYC-1234
>> ID-LND-1234
>> TX-NYC-1334
>> TX-NYC-BBC-123
>>=20
>> The ids may range from 90 to 1000.  Is there another approach I could tak=
e?  I tried building a string with all the ids and set them against a field f=
or example:
>>=20
>> dataId: ID-NYC-123 dataId: ID-NYC-1234....
>>=20
>> but that's not a great approach I know...
>>=20
>> any help would be appreciated.
>>=20
>> Thanks
>> Amin
>>=20
>>=20
>>=20
>> On 26 Nov 2010, at 14:39, Ian Lea wrote:
>>=20
>>> Absolutely, as long as your ids will sort as you expect.
>>>=20
>>> I'm not clear what you mean by XDF-123 but if you've got
>>>=20
>>> AAA-123
>>> AAA-124
>>> ...
>>> ABC-123
>>> ABC-234
>>> etc.
>>>=20
>>> then you'll be fine.  If they don't sort so neatly you can use the
>>> TermRangeQuery constructor that takes a Collator but note the
>>> performance warning in the javadocs.
>>>=20
>>>=20
>>> --
>>> Ian.
>>>=20
>>>=20
>>> On Fri, Nov 26, 2010 at 2:18 PM, Amin Mohammed-Coleman <aminmc@gmail.com=
> wrote:
>>>> Hi All
>>>>=20
>>>> I was wondering whether I can use TermRangeQuery for my use case.  I ha=
ve a collection of ids (represented as XDF-123) and I would like to do a sea=
rch for all the ids (might be in the range of 10000) and for each matching i=
d I want to get the corresponding data that is stored in the index (for exam=
ple the document contains id and string value).  I am using a custom collect=
or to collect that string value for each match.  Is it ok to use a TermRange=
Query for the ids rather than creating a massive query string?
>>>>=20
>>>>=20
>>>> Thanks
>>>> Amin
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
>>>> For additional commands, e-mail: java-user-help@lucene.apache.org
>>>>=20
>>>>=20
>>>=20
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
>>> For additional commands, e-mail: java-user-help@lucene.apache.org
>>>=20
>>=20
>>=20
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
>> For additional commands, e-mail: java-user-help@lucene.apache.org
>>=20
>>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>=20

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org