Re: DataImportHanlder - Multiple entities will step into each other

2011-01-06 Thread Matti Oinas
;> 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

Re: DataImportHanlder - Multiple entities will step into each other

2011-01-06 Thread 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 > > >   >     > ... >   >     > ... >

RE: DataImportHanlder - Multiple entities will step into each other

2011-01-05 Thread Ephraim Ofir
: DataImportHanlder - Multiple entities will step into each other I managed to do that by using TemplateTransformer ... ... 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&#

Re: DataImportHanlder - Multiple entities will step into each other

2011-01-04 Thread yu shen
Very detailed explanation, will look into it. Thanks. 2011/1/5 Erick Erickson > No, this is all #explicitly# defined in schema.xml. Solr has no required > fields. > If you're using the default schema.xml, the problem is that that file > defines > the id field with 'required="true"' option set, s

Re: DataImportHanlder - Multiple entities will step into each other

2011-01-04 Thread Erick Erickson
No, this is all #explicitly# defined in schema.xml. Solr has no required fields. If you're using the default schema.xml, the problem is that that file defines the id field with 'required="true"' option set, so any doc that does not have an id field is rejected. Id is used in the default schema in

Re: DataImportHanlder - Multiple entities will step into each other

2011-01-04 Thread yu shen
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

Re: DataImportHanlder - Multiple entities will step into each other

2011-01-04 Thread Lance Norskog
This SQL syntax should do it: "select id, field as table_id, field". On Tue, Jan 4, 2011 at 5:59 AM, yu shen wrote: > Thanks for the prompt reply. Let me try. Delete is not a big deal for the > moment. > > 2011/1/4 Matti Oinas > >> I managed to do that by using TemplateTransformer >> >> >>   >>

Re: DataImportHanlder - Multiple entities will step into each other

2011-01-04 Thread yu shen
Thanks for the prompt reply. Let me try. Delete is not a big deal for the moment. 2011/1/4 Matti Oinas > I managed to do that by using TemplateTransformer > > > > > ... > > > ... > > > Only problem is that delta import fails to perform delete to the > index. It seems that Templat

Re: DataImportHanlder - Multiple entities will step into each other

2011-01-04 Thread Matti Oinas
I managed to do that by using TemplateTransformer ... ... 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 : > Hi All, > > I have a dat

DataImportHanlder - Multiple entities will step into each other

2011-01-04 Thread yu shen
Hi All, I have a dataimporthandler config file as below. It contains multiple entities: 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.