RE: DIH nested entities don't work

rce Systems Ingram Content Group (615) 213-4311 -Original Message- From: mroosendaal [mailto:mroosend...@yahoo.com] Sent: Wednesday, December 05, 2012 8:23 AM To: solr-user@lucene.apache.org Subject: RE: DIH nested entities don't work Hi James, Just to let you know, i've just comp

RE: DIH nested entities don't work

Hi James, Just to let you know, i've just completed the PoC and it worked great! Thanks. What i still find difficult to is how to implement a 'guided' navigation with Solr. That is one of the strenghts of Endeca and with Solr you have to create this yourself. What are your thoughts on that and wh

RE: DIH nested entities don't work

Hi, I got things working for 7 views and it looks good! Next things is getting all the views in the index and getting my schema.xml in order. I'll let you know how it goes! Thanks!!!, Maarten -- View this message in context: http://lucene.472066.n3.nabble.com/DIH-nested-entities-don-t-work-t

RE: DIH nested entities don't work

t; parameter was incorrectly renamed "cachePk". For 4.0.0, this was renamed back to "cacheKey". James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -Original Message- From: mroosendaal [mailto:mroosend...@yahoo.com] Sent: Tuesday, November 27, 2012 3

RE: DIH nested entities don't work

Hi James, I was out for a week hence the late response. I did as you suggested and i can import several views in parallel. However running the data-import which does the join gives the following errors: 27-nov-2012 10:11:24 org.apache.solr.common.SolrException log SEVERE: Exception while processi

RE: DIH nested entities don't work

aconfig-master.xml true true false berkleyInternalShared="true" > -Original Message- From: mroosendaal [mailto:mroosend...@yahoo.com] Sent: Friday, November 16, 2012 8:19 AM To

RE: DIH nested entities don't work

Hi, You are correct about not wanting to index everything every day, however for this PoC i need a 'bootstrap' mechanism which basically does what Endeca does. The 'defaultRowPrefetch' in the solrconfig.xml does not seem to take, i'll have a closer look. With the long time, it appeard that one o

RE: DIH nested entities don't work

an still use bdb-je for caches if it still makes sense depending on how big the deltas are) James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -Original Message- From: mroosendaal [mailto:mroosend...@yahoo.com] Sent: Thursday, November 15, 2012 8:52 AM To: solr-user@lucene.

RE: DIH nested entities don't work

Hi James, Just gave it a go and it worked! That's the good news. The problem now is getting it to work faster. It took over 2 hours just to index 4 views and i need to get information from 26. I tried adding the defaultRowPrefetch="2" as a jdbc parameter but it does not seem to honour that. I

RE: DIH nested entities don't work

Thanks, i'll give that a try tomorrow. Here's the data-config.xml which i will try when i get to work tomorrow: :1521/ENDDEV" user="un" password="pw"/> the view

RE: DIH nested entities don't work

ember 12, 2012 4:58 AM To: solr-user@lucene.apache.org Subject: RE: DIH nested entities don't work Hi, I've created a jar with 5 files: 4 files with DIHCache*.java 1 file named BerkleyBackedCache.java I've changed the data-config based on your input. What i see it doing is that it i

RE: DIH nested entities don't work

Hi, I've created a jar with 5 files: 4 files with DIHCache*.java 1 file named BerkleyBackedCache.java I've changed the data-config based on your input. What i see it doing is that it is building a cache at the given location. However the first testrun took almost *3* hours before i got a message:

RE: DIH nested entities don't work

out of the cache for the child while looping the resultset for the parent. Hopefully this will work better for yu. James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -Original Message- From: mroosendaal [mailto:mroosend...@yahoo.com] Sent: Friday, November 09, 2012 12:39 AM T

RE: DIH nested entities don't work

Additional information: i just finished a test for 10.000 records (the db containts 600K products), it took 25 minutes and all the parents records had the same 'feature'. -- View this message in context: http://lucene.472066.n3.nabble.com/DIH-nested-entities-don-t-work-tp4015514p4019227.html Se

RE: DIH nested entities don't work

Hi James, What i did: * build a jar from the patch * downloaded the BDB library * added them to my classpath * download a nightly 4.1 Sol build * created a db config according to: http://svn.apache.org/repos/asf/lucene/dev/branches/branch_4x/solr/contrib/dataimporthandler/src/test/org/apache/solr/

RE: DIH nested entities don't work

s Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -Original Message- From: mroosendaal [mailto:mroosend...@yahoo.com] Sent: Monday, October 29, 2012 5:06 AM To: solr-user@lucene.apache.org Subject: Re: DIH nested entities don't work Hi, It seems to work without the cache o

Re: DIH nested entities don't work

On 29 October 2012 15:36, mroosendaal wrote: > Hi, > > It seems to work without the cache option, the downside is it will takes > ages for everything to be indexed and my testset is 20 times smaller than > the productset. Someone else will have to respond as to how to use CachedSqlEntity in Solr

Re: DIH nested entities don't work

Hi, It seems to work without the cache option, the downside is it will takes ages for everything to be indexed and my testset is 20 times smaller than the productset. Indexing just the root item takes 3 minutes (>600K) but every subentity takes more time which is obvious but i would've hoped it w

Re: DIH nested entities don't work

Hi, I've tried the subselection query and it works fine. It's weekend now:-) so what i'm going to do is remove the cache option. I'll also try a different jdbc driver and a few jdbc driver options. Thanks, Maarten -- View this message in context: http://lucene.472066.n3.nabble.com/DIH-nested-

Re: DIH nested entities don't work

On 26 October 2012 20:01, mroosendaal wrote: > None taken:-) > > Here's the info [...] The DIH configuration, and schema look fine. I have not used the new caching setup in 4.0 enough to comment on it. > *what i;ve tried* > * importing only the products --> worked > * importing only the songs (a

Re: DIH nested entities don't work

None taken:-) Here's the info OS: Linux Java: 1.6 Oracle driver: ojdbc14.jar *view structure:* END_FRG_PRODUCTS_VW pdt_id pdt_title stock_availability pdt_pce_bolprice gpc_id offer_type search_rank search_title END_FRG_FEAT

Re: DIH nested entities don't work

On 26 October 2012 13:14, mroosendaal wrote: > Hi, > > I tried giving the pdt_id from the subentity a specific value and it worked. > Only now every product has the same value. [...] No offence, but it is difficult to try help you if you provide partial information, and keep trying different thin

Re: DIH nested entities don't work

Hi, I tried giving the pdt_id from the subentity a specific value and it worked. Only now every product has the same value. I tried a different subentity with the construct subentity.pdt_id='${entity.pdt_id}' with the same result as above, all products had a songtitle with the same value. So wh

Re: DIH nested entities don't work

Hi, The views are very specific and every column contains relevant information, thus the '*'. But a strange thing happened, i ran the data-import again and for some reason products had features but still no synonyms. The only thing i changed was to use: processor="SqlEntityProcessor " cacheImpl="

Re: DIH nested entities don't work

On 24 October 2012 13:03, mroosendaal wrote: > Hi, > > Here's the relevant part of my schema: [...] > > pdt_id > ... > > the data is read from into another searchengine fine but i'll try the select > queries individually. The field-definitions need some tweaking. [...] As you are not specificall

Re: DIH nested entities don't work

Hi, Here's the relevant part of my schema: pdt_id ... the data is read from into another searchengine fine but i'll try the select queries individually. The field-definitions need some tweaking. As for the songtitle, this was a typo Cheers, Maarten

Re: DIH nested entities don't work

On 24 October 2012 10:30, mroosendaal wrote: > > Hi, > > We have several oracle views which contain the result of an ETL process. I > want to index information from those views and have the following > data-config.xml > > driver="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@//:1521/