Thank you very much Furkan for the detailed explanation. I simply set the processor to SqlEntityProcessor and cacheImpl to SortedMapBackedCache, and it worked for me i.e. from my original post I had/did:
<entity name="Doc" query="SELECT DocID, Title FROM solr.DOCS_TABLE"> <field column="DocID" name="DocID" /> <field column="Title" name="Title" /> <entity name="Cat1" query="SELECT CategoryName, DocID FROM solr.CAT_DOCS_MAP WHERE CategoryLevel=1" cacheKey="DocID" cacheLookup="Doc.DocID" processor="SqlEntityProcessor" cacheImpl="SortedMapBackedCache"> <field column="CategoryName" name="Category1" /> </entity> </entity> Thanks again, O. O. -- View this message in context: http://lucene.472066.n3.nabble.com/Replacing-Deprecated-CachedSqlEntityProcessor-with-SqlEntityProcessor-with-a-cacheImpl-parameter-tp4106018p4106227.html Sent from the Solr - User mailing list archive at Nabble.com.