Try this.. <entity name="Cat1" query="SELECT CategoryName,<b>SKU* from CAT_TABLE WHERE CategoryLevel=1" cacheKey=*"Cat1.SKU"* cacheLookup="Product.SKU" processor="CachedSqlEntityProcessor"> <field column="CategoryName" name="Category1" /> </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-tp4064919p4065116.html Sent from the Solr - User mailing list archive at Nabble.com.