Omgili, forum search, forums search, search forums, discussion search,discussions search, search discussions, board search, boards search, search boards
  Advanced Search

comparing index fields within a query

On Mon, 23 Jan 2012 12:33:26 +0200, Jamie <...@stimulussoft.com

Hi Everyone

I have a problem where I need to compare two indexed fields as part of a
query.

For instance: modified_date[1970 to 2012] AND NOT deleted_date
how would one implement this using Lucene?

Bear in mind, I need a dynamic way of accomplishing this comparison.

In my case, it is not possible to store the result of
deleted_date
Thanks

Jamie

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



On Mon, 23 Jan 2012 12:21:12 +0000, Ian Lea <...@gmail.com

I guess you could do it in a custom Collector. They get passed
readers and docids so you could do the lookups and comparison. There
will be performance implications that you may be able to minimise via
FieldCache.

Storing the result in the index sounds much more sensible.

--
Ian.

On Mon, Jan 23, 2012 at 10:33 AM, Jamie <...@stimulussoft.com
---------------------------------------------------------------------
To unsubscribe, e-mail: java...@lucene.apache.org
For additional commands, e-mail: java...@lucene.apache.org

On Mon, 23 Jan 2012 14:31:07 +0200, Jamie <...@stimulussoft.com

Ian

Thanks. I'll have to read up about it. I have a lot of comparisons to
make, so cannot precompute the values.

Don't you think this would be a nice feature for Lucene?

The Lucene query syntax has not changed much over the past few years.
Are there any plans to broaden its capabilities?

Jamie

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

On Tue, 24 Jan 2012 09:22:30 +1100, Trejkaz <...@trypticon.org

On Mon, Jan 23, 2012 at 11:31 PM, Jamie <...@stimulussoft.com
How many is a lot? If it were 100 or so I would still be tempted to do
all 4,950 comparisons and find some sensible way to store them. It
would increase the size of each document a little in the index but
it's not like you need to store the values.

TX

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

On Mon, 23 Jan 2012 14:06:45 +0000, Ian Lea <...@gmail.com

Can't say I've ever missed it, and haven't noticed others asking for
it. You need to remember that lucene is not a database.

Not that I know of, but I wouldn't really know.

--
Ian.

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

Discussion Title: comparing index fields within a query
Title Keywords: comparing  index  fields  within  query