On Tue, Jan 10, 2012 at 4:44 AM, geeky2 <gee...@hotmail.com> wrote:
[...]
> i have a database with approximately 7Million rows that i am bringing in to
> solr.
>
> for a very small sub-set of these 7Million rows (about 130 rows), i need to
> substitute an old part number for a new part number. i know ahead of time
> all 130 part numbers that need to be substituted and their new values.
>
> example:
>
> old part# new part#
> M123b C987
[...]
* Is it possible to do these replacements in the database, once and for
all?
* Do you want the part numbers to be replaced, or for both to exist? In
the latter case, a user can find the part by searching for either the old
or the new part number, so I believe that this should be the preferred
solution.
- For replacement while indexing, use a transformer. A RegexTransformer,
or ScriptTransformer should do the trick. Please see
http://wiki.apache.org/solr/DataImportHandler#Transformer
- For keeping both values, use synonyms.
Regards,
Gora
