lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matti Oinas <matti.oi...@gmail.com>
Subject Re: DataImportHanlder - Multiple entities will step into each other
Date Fri, 07 Jan 2011 06:35:59 GMT
Concat doesn't work as expected.

Doing SELECT concat('blog-',id) as uuid.... instead of template
transformer the uuid in the index would be something like

<str name="uuid">[B@d760bb</str>

instead of

<str name="uuid">blog-1</str>

I haven't tested if DIH can perform delete when using concat but at
least you can not delete by uuid from anywhere else when using concat.

2011/1/5 Ephraim Ofir <EphraimO@icq.com>:
> You could get around that by doing the concatenation at the SQL level, that way deletes
would work as well.
>
> Ephraim Ofir
>
> -----Original Message-----
> From: Matti Oinas [mailto:matti.oinas@gmail.com]
> Sent: Tuesday, January 04, 2011 3:57 PM
> To: solr-user@lucene.apache.org
> Subject: Re: DataImportHanlder - Multiple entities will step into each other
>
> I managed to do that by using TemplateTransformer
>
> <document>
>  <entity name="company"..... transformer="TemplateTransformer">
>     <field column="id" name="id" template="company-${company.id}" />
> ...
>  <entity name="item"..... transformer="TemplateTransformer">
>     <field column="id" name="id" template="item-${item.id}" />
> ...
> </document>
>
> Only problem is that delta import fails to perform delete to the
> index. It seems that TemplateTransformer is not used when performing
> delete so delete by id doesn't work.
>
>
>
> 2011/1/4 yu shen <shenyu.sh@gmail.com>:
>> Hi All,
>>
>> I have a dataimporthandler config file as below. It contains multiple
>> entities:
>> <dataConfig>
>>        <dataSource name="jdbc" driver="com.mysql.jdbc.Driver"
>>
>> url="jdbc:mysql://localhost:1521/changan?useUnicode=true&amp;characterEncoding=utf8&amp;autoReconnect=true"...
>> />
>>        <document>
>>                <entity name="item" dataSource="jdbc" pk="id" query="...">
>>                <entity name="company" dataSource="jdbc" pk="id" query="">
>>                ....
>>        </document>
>> </dataConfig>
>>
>> All data are from a database. Problem is item/company and other entity all
>> have the field 'id', with value start from 1 to n. In this case,
>> item/company etc. will step into each other.
>> Is there a way to prevent is from happening. Such as designate different
>> entity to different partition.
>>
>> One way I can think of is to seperate different entity to different
>> instance, which is not ideal solution IMO.
>>
>> Would some one point me to a reference? And also give some instructions?
>>
>

Mime
View raw message