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">[...@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 <ephra...@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.oi...@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...@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&characterEncoding=utf8&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?
>>
>
