Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Date: Mon, 2 Aug 2010 14:59:05 -0700 (PDT)
From: Chris Hostetter <hossman_lucene@fucit.org>
To: solr-user@lucene.apache.org
Subject: Re: Implementing lookups while importing data
In-Reply-To: <20100729152139.321c4575@ibis>
Message-ID: <alpine.DEB.1.10.1008021456480.1697@radix.cryptio.net>
References: <20100729152139.321c4575@ibis>
User-Agent: Alpine 1.10 (DEB 962 2008-03-14)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


: We have a database that has numeric values for some columns, which
: correspond to text values in drop-downs on a website. We need to
: index both the numeric and text equivalents into Solr, and can do
: that via a lookup on a different table from the one holding the
: main data. We are currently doing this via a JOIN on the numeric
: field, between the main data table and the lookup table, but this
: dramatically slows down indexing.
: 
: We could try using the CachedSqlEntity processor, but there are
: some issues in doing that, as the data import handler is quite
: complicated.

wha you are describing is pretty much the exact use case of the 
CachedSqlEntity (as i understand it) so perhaps you should elaborate on 
what issues you had.

showing your DIH config is the best way ot get assistance.


-Hoss