Hi,
my config is just the following:
<dataConfig>
<dataSource type="JdbcDataSource"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://xx/asdx"
user="xxxx"
password="xxxx"/>
<document>
<entity name="id"
query="select p.title as title, p.id, p.category_id,
p.pic_thumb, c.name as category, c.id as category_id from product p,
category c WHERE p.category_id = c.id AND '${dataimporter.request.clean}'
!= 'false' OR updated_at > '${dataimporter.last_index_time}' ">
</entity>
</document>
</dataConfig>
I'm doing it as described on:
http://wiki.apache.org/solr/DataImportHandlerDeltaQueryViaFullImport
Any ideas?
Best regars,
Ramo
-----Ursprüngliche Nachricht-----
Von: Jeevanandam Madanagopal [mailto:je...@myjeeva.com]
Gesendet: Donnerstag, 19. April 2012 17:44
An: solr-user@lucene.apache.org
Betreff: Re: Wrong categorization with DIH
Ramo -
Please share DIH configuration with us.
-Jeevanandam
On Apr 19, 2012, at 7:46 PM, Ramo Karahasan wrote:
> Does anyone has an idea what's going wrong here?
>
> Thanks,
> Ramo
>
> -----Ursprüngliche Nachricht-----
> Von: Gora Mohanty [mailto:g...@mimirtech.com]
> Gesendet: Dienstag, 17. April 2012 11:34
> An: solr-user@lucene.apache.org
> Betreff: Re: Wrong categorization with DIH
>
> On 17 April 2012 14:47, Ramo Karahasan <ramo.karaha...@googlemail.com>
> wrote:
>> Hi,
>>
>>
>>
>> i currently face the followin issue:
>>
>> Testing the following sql statement which is also used in SOLR (DIH)
>> leads to a wrong categorization in solr:
>>
>> select p.title as title, p.id, p.category_id, p.pic_thumb, c.name as
>> category, c.id as category_id from product p, category c WHERE
>> p.category_id = c.id AND p.id = 3091328
>>
>>
>>
>> This returns in my sql client:
>>
>> Apple MacBook Pro MD313D/A 33,8 cm (13,3 Zoll) Notebook (Intel Core
>> i5-2435M, 2,4GHz, 4GB RAM, 500GB HDD, Intel HD 3000, Mac OS),
>> 3091328, 1003, http://m-d.ww.cdn.com/images/I/41teWbp-uAL._SL75_.jpg,
>> Computer,
>> 1003
>>
>>
>>
>> As you see, the categoryid 1003 points to "Computer"
>>
>>
>>
>> Via the solr searchadmin i get the following result when searchgin
>> for
>> id:3091328
>>
>> <str name="category">Sport</str>
>>
>> <int name="category_id">1003</int>
> [...]
>
> Please share with us the rest of the DIH configuration file, i.e., the
> part where these data are saved to the Solr index.
>
> Regards,
> Gora
>
