There was a mistake in my last reply. Your child entities need to SELECT on the join key so DIH has it to do the join. So use "SELECT SKU, CategoryName..."
James Dyer Ingram Content Group (615) 213-4311 -----Original Message----- From: O. Olson [mailto:olson_...@yahoo.it] Sent: Tuesday, May 21, 2013 5:06 PM To: solr-user@lucene.apache.org Subject: RE: How do I use CachedSqlEntityProcessor? Thank you James & bbarani. This worked in the sense that there was no error or exception in the data import. Unfortunately, I do not see any of my Category1, Category2 etc. when I retrieve the documents. If I use the first configuration of the db-data-config.xml posted in my original post, I see these fields in each document. Doing an import with your suggestion of <entity name="Cat1" query="SELECT CategoryName from CAT_TABLE WHERE CategoryLevel=1" cacheKey="SKU" cacheLookup="Product.SKU" processor="CachedSqlEntityProcessor"> <field column="CategoryName" name="Category1" /> </entity> I do not see Category1. I have not changed my schema.xml, so I don’t think this should affect the results. For e.g. Category1 is declared as: <field name="Category1" type="string" indexed="true" stored="true" multiValued="true"/> I am curious to what I am doing wrong. I should mention that I am using Solr 4.0.0. I know a more recent version is out – but I don’t think it should make a difference. Thank you again for your help. O. O. Dyer, James-2 wrote > First remove the "where" condition from the child entities, then use the > "cacheKey" and "cacheLookup" parameters to instruct DIH how to do the > join. > > Example: > <entity > name="Cat1" > cacheKey="SKU" > cacheLookup="Product.SKU" > query="SELECT CategoryName from CAT_TABLE where CategoryLevel=1" > /> > See http://wiki.apache.org/solr/DataImportHandler#CachedSqlEntityProcessor > , particularly the 3rd configuration option. > > James Dyer > Ingram Content Group > (615) 213-4311 -- View this message in context: http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065091.html Sent from the Solr - User mailing list archive at Nabble.com.
