RE: How do I use CachedSqlEntityProcessor?

The conversation helps me understand Cached processor a lot. I'm working on DIH cache using MapDB as backed engine instead of default CachedSqlEntityProcessor -- View this message in context: http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4198037.html Sent

RE: How do I use CachedSqlEntityProcessor?

Thank you bbarani. Unfortunately, this does not work. I do not get any exception, and the documents import OK. However there is no Category1, Category2 … etc. when I retrieve the documents. I don’t think I am using the Alpha or Beta of 4.0. I think I downloaded the plain vanilla release version.

RE: How do I use CachedSqlEntityProcessor?

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

RE: How do I use CachedSqlEntityProcessor?

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

Re: How do I use CachedSqlEntityProcessor?

I am curious why I did not get any errors before. Because there was no (syntax) error before - the fact that you didn't include a SKU (but using it as cacheKey) just doesn't match anything .. therefore you got nothing added to your documents. Perhaps we should add an ticket as improvement for

RE: How do I use CachedSqlEntityProcessor?

, May 22, 2013 10:30 AM To: solr-user@lucene.apache.org Subject: Re: How do I use CachedSqlEntityProcessor? I am curious why I did not get any errors before. Because there was no (syntax) error before - the fact that you didn't include a SKU (but using it as cacheKey) just doesn't match anything

RE: How do I use CachedSqlEntityProcessor?

Thank you guys, particularly James, very much. I just imported 200K documents in a little more than 2 mins – which is great for me :-). Thank you Stefan. I did not realize that it was not a syntax error and hence no error. Thank you for clearing that up. O. O. -- View this message in context:

RE: How do I use CachedSqlEntityProcessor?

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

Re: How do I use CachedSqlEntityProcessor?

Try like this... entity x query=select * from x entity y query=select * from y processor=cachedSqlEntityprocessor cachekey=y.id cachevalue=x.id -- View this message in context: http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065030.html Sent from the

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

RE: How do I use CachedSqlEntityProcessor?

Try this.. entity name=quot;Cat1quot; query=quot;SELECT CategoryName,lt;bSKU* from CAT_TABLE WHERE CategoryLevel=1 cacheKey=*Cat1.SKU* cacheLookup=Product.SKU processor=CachedSqlEntityProcessor field column=CategoryName name=Category1 /