Ramo -
Are you using all the selected columns from the 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 ...
I see following attributes 'p.id', 'p.category_id' & 'p.pic_thumb' doesn't
have alias defined.
Pointers:
------------
- Select only required field in the sql query
- Ensure sql alias name and attribute name in the schema.xml should match
or
- If you like to do explicit mapping for every column in DIH config as follow
<field column="SQL-COLUMN-NAME-HERE" name="SOLR-SCHEMA-ATTRIBUTE-NAME-HERE" />
Detailed Info refer this: http://wiki.apache.org/solr/DataImportHandler
-Jeevanandam
On Apr 19, 2012, at 9:37 PM, Ramo Karahasan wrote:
> 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
>>
>
>
