Thank you bbarani. Unfortunately, this does not work. I do not get any
exception, and the documents import OK. However there is no Category1,
Category2 … etc. when I retrieve the documents.
I don’t think I am using the Alpha or Beta of 4.0. I think I downloaded the
plain vanilla release version.
O. O.
bbarani wrote
> Try this..
> <entity name="Cat1"
> query="SELECT CategoryName,SKU from CAT_TABLE WHERE
> CategoryLevel=1" cacheKey="Cat1.SKU" cacheLookup="Product.SKU"
> processor="CachedSqlEntityProcessor">
>
> <field column="CategoryName" name="Category1" />
>
>
> </entity>
> sample data import config:
>
>
> <entity name="property" query="select UID,name as name, value as value
> from opTable where type='${dataimporter.request.type}' and indexed='Y' "
> processor="CachedSqlEntityProcessor" cacheKey="UID"
> cacheLookup="object.uid"
> transformer="RegexTransformer,DateFormatTransformer,TemplateTransformer">
>
>
> <field column="value" name="${property.name}"/>
> //dynamic column
>
> </entity>
>
> Also not sure if you are using Alpha / Beta release of SOLR 4.0.
>
> In Solr 3.6, 3.6.1, 4.0-Alpha & 4.0-Beta, the "cacheKey" parameter was
> re-named "cachePk". This is renamed back for 4.0 (& 3.6.2, if released).
> See SOLR-3850
--
View this message in context:
http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065309.html
Sent from the Solr - User mailing list archive at Nabble.com.
