Re: Indexing Multiple Datasources

2012-06-12 Thread Lance Norskog
Are you trying to do a JOIN on these two tables inside the DIH? On Tue, Jun 12, 2012 at 8:35 PM, Gora Mohanty wrote: > On 11 June 2012 21:29, Kay wrote: >> Hello, >> >> We have 2 MS SQL Server Databases which we wanted to index .But most of the >> columns in the Databases have the same names. Fo

Re: Indexing Multiple Datasources

2012-06-12 Thread Gora Mohanty
On 11 June 2012 21:29, Kay wrote: > Hello, > > We have 2 MS SQL Server Databases which we wanted to index .But most of the > columns in the Databases have the same names. For e.g. Both the DB’s have > the columns First name ,Last name ,etc. It is not clear how you want to handle this: Should the

Re: Indexing Multiple Datasources

2012-06-12 Thread Jack Krupansky
mes in the request DIH should run them all (sequentially). -- Jack Krupansky -Original Message- From: Kay Sent: Tuesday, June 12, 2012 2:24 PM To: solr-user@lucene.apache.org Subject: Re: Indexing Multiple Datasources Thanks for the reply jack! We tried giving each data source a nam

Re: Indexing Multiple Datasources

2012-06-12 Thread Kay
Thanks for the reply jack! We tried giving each data source a name (For e.g. ds-1,ds-2 etc) but what it does is when we checked the log it establishes connection with the first data source and indexed while the second DB is getting ignored. Yes! what we wanted to try is in our system we have many

Re: Indexing Multiple Datasources

2012-06-11 Thread Jack Krupansky
You can do it by giving each database data source a "name" attribute, which is what you reference in the dataSource attribute of your entity. See: http://wiki.apache.org/solr/DataImportHandler#multipleds Or, are you in fact trying to join or merge the tables based on first name and last name o