lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Fodor (JIRA)" <>
Subject [jira] Commented: (SOLR-2202) Money FieldType
Date Wed, 27 Oct 2010 15:34:20 GMT


Greg Fodor commented on SOLR-2202:

Hey Uwe & Robert, thank you for your feedback. I will look into better integration with
the native Currency classes, that makes a lot of sense. As far as the numerical indexing goes,
I might need some help.

First, I'm guessing the necessary change will be to change the "amount" subfield from a double
to a tdouble field type. (TrieDouble) How exactly does this help with rounding errors? I'm
not that familiar with the Trie types, but it seems that since the values are coerced through
the ValueSource to doubles there is always a risk of rounding error.

Additionally, how does the trie field prevent hitting the field cache? I am implementing a
custom value source, which does the currency conversion by applying it by iterating over the
ValueSource's for the subfields.

Finally, you mention saving the values as "plain numbers in the index" -- I assumed this is
what I was already doing via the construction of the subfields and storing the values in "double"
FieldType'd field "amount". Can you explain what steps I need to take to be sure these values
are being stored as numbers in the index?


> Money FieldType
> ---------------
>                 Key: SOLR-2202
>                 URL:
>             Project: Solr
>          Issue Type: New Feature
>          Components: Schema and Analysis
>    Affects Versions: 1.5
>            Reporter: Greg Fodor
>         Attachments: SOLR-2202-lucene-1.patch, SOLR-2202-solr-1.patch, SOLR-2202-solr-2.patch
> Attached please find patches to add support for monetary values to Solr/Lucene with query-time
currency conversion. The following features are supported:
> - Point queries (ex: "price:4.00USD")
> - Range quries (ex: "price:[$5.00 TO $10.00]")
> - Sorting.
> - Currency parsing by either currency code or symbol.
> - Symmetric & Asymmetric exchange rates. (Asymmetric exchange rates are useful if
there are fees associated with exchanging the currency.)
> At indexing time, money fields can be indexed in a native currency. For example, if a
product on an e-commerce site is listed in Euros, indexing the price field as "10.00EUR" will
index it appropriately. By altering the currency.xml file, the sorting and querying against
Solr can take into account fluctuations in currency exchange rates without having to re-index
the documents.
> The new "money" field type is a polyfield which indexes two fields, one which contains
the amount of the value and another which contains the currency code or symbol. The currency
metadata (names, symbols, codes, and exchange rates) are expected to be in an xml file which
is pointed to by the field type declaration in the schema.xml.
> The current patch is factored such that Money utility functions and configuration metadata
lie in Lucene (see MoneyUtil and CurrencyConfig), while the MoneyType and MoneyValueSource
lie in Solr. This was meant to mirror the work being done on the spacial field types.
> This patch has not yet been deployed to production but will be getting used to power
the international search capabilities of the search engine at Etsy.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message