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
-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-tp4064919p4065309.html
Sent from the Solr - User mailing
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
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
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
(http://Nabble.com).
, 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
:
http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065392.html
Sent from the Solr - User mailing list archive at Nabble.com.
, where I do not.
I went back and re-verified this result.
Thank you all for your help.
O. O.
--
View this message in context:
http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919.html
Sent from the Solr - User mailing list archive at Nabble.com.
Subject: How do I use CachedSqlEntityProcessor?
I am using the DataImportHandler to Query a SQL Server and populate Solr with
data that has hierarchical relationships.
The following is an outline of my table structure:
PROD_TABLE
- SKU (Primary Key)
- Title (varchar)
- Descr (varchar
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 3rd configuration option.
James Dyer
Ingram Content Group
(615) 213-4311
--
View this message in context:
http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065091.html
Sent from the Solr - User mailing list archive at Nabble.com.
.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065116.html
Sent from the Solr - User mailing list archive at Nabble.com.
12 matches
Mail list logo