Thank you very much James. Your suggestion worked exactly! I am curious why I did not get any errors before. For others, the following worked for me:
<entity name="Cat1" query="SELECT CategoryName, SKU from CAT_TABLE WHERE CategoryLevel=1" cacheKey="SKU" cacheLookup="Product.SKU" processor="CachedSqlEntityProcessor"> <field column="CategoryName" name="Category1" /> </entity> Similarly for other Categories i.e. Category2, Category3, etc. I am now going to try this for a larger dataset. I hope this works. O.O. Dyer, James-2 wrote > 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 -- View this message in context: http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065342.html Sent from the Solr - User mailing list archive at Nabble.com.