I tried the sql way, and not work as expected.
According to my experiments, id is an implicit required field of solr. If I
change id to table_id, and add field definition in schema.xml, while data
importing, there will be an error reported.
Please correct me if I am wrong.
2011/1/5 Lance Norskog <goks...@gmail.com>
> This SQL syntax should do it: "select id, field as table_id, field".
>
> On Tue, Jan 4, 2011 at 5:59 AM, yu shen <shenyu...@gmail.com> wrote:
> > Thanks for the prompt reply. Let me try. Delete is not a big deal for the
> > moment.
> >
> > 2011/1/4 Matti Oinas <matti.oi...@gmail.com>
> >
> >> 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?
> >> >
> >>
> >
>
>
>
> --
> Lance Norskog
> goks...@gmail.com
>
