Hi,
I am
looking to replace the Deprecated CachedSqlEntityProcessor with
SqlEntityProcessor
with a cacheImpl parameter but I cannot find documentation.
The Deprecated note at the top of
http://lucene.apache.org/solr/3_6_0/org/apache/solr/handler/dataimport/CachedSqlEntityProcessor.html
says that we need to replace the CachedSqlEntityProcessor with
SqlEntityProcessor with a cacheImpl parameter. The wiki here, does not mention
the cacheImpl parameter, or it's possible values:
https://cwiki.apache.org/confluence/display/solr/Uploading+Structured+Data+Store+Data+with+the+Data+Import+Handler#UploadingStructuredDataStoreDatawiththeDataImportHandler-EntityProcessors
An abbreviated version of my db-data-config.xml looks like:
<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="CachedSqlEntityProcessor">
<field column="CategoryName" name="Category1" />
</entity>
</entity>
I am curious how I would use SqlEntityProcessor and turn on
caching (because I really need it). Or is that even possible? Can I do
something like:
<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=???>
<field column="CategoryName" name="Category1" />
</entity>
</entity>
What do I put in for cacheImpl? What are the possible values
for cacheImpl.
Thank you in advance for your help.
O. O.
