Thanks Em. Yes, OS06Y is the uniqueKey. Table1 and Table2 is parallel in my example. In the Url: http://wiki.apache.org/solr/DIHQuickStart#Index_data_from_multiple_table s_into_Solr The tables don't have parallel relations in the above URL example I want to know that can solr implement the case? 1.Get data from database table1; 2.Get data from database table2; 3.merge the fields of table1 and table2;
The configuration of db-data-config.xml is the following: <document name="allperf"> <entity name="PerformanceData1" dataSource="getTrailingTotalReturnForMonthEnd1" query="SELECT Perfo rmanceId,Trailing1MonthReturn,Trailing2MonthReturn,Trailing3MonthReturn, FROM Table1"> <field column="PerformanceId" name="OS06Y" /> <field column="Trailing1MonthReturn" name="PM004" /> <field column="Trailing2MonthReturn" name="PM133" /> <field column="Trailing3MonthReturn" name="PM006" /> </entity> <entity name="PerformanceData2" dataSource="getTrailingTotalReturnForMonthEnd2" query="SELECT Performan ceId,Trailing10YearReturn,Trailing15YearReturn,TrailingYearToDateReturn, SinceInceptionReturn FROM Table2"> <field column="PerformanceId" name="OS06Y" /> <field column="Trailing10YearReturn" name="PM00I" /> <field column="Trailing15YearReturn" name="PM00K" /> <field column="TrailingYearToDateReturn" name="PM00A" /> <field column="SinceInceptionReturn" name="PM00M" /> </entity> </document> Because I don't want to get one id and data from table1 and then get the data by id from table2,it may met performance issue. -----Original Message----- From: Em [mailto:mailformailingli...@yahoo.de] Sent: Thursday, April 21, 2011 4:38 PM To: solr-user@lucene.apache.org Subject: Re: The issue of import data from database using Solr DIH Hi Kevin, I think you made OS06Y the uniqueKey, right? So, in entity 1 you specify values for it, but in entity 2 you do so as well. I am not absolutely sure about this, but: It seems like your two entities create two documents and the second will overwrite the first. Have a look at this page: http://wiki.apache.org/solr/DIHQuickStart#Index_data_from_multiple_table s_into_Solr I think it will help you in rewriting your queries to fit your usecase. Regards, Em -- View this message in context: http://lucene.472066.n3.nabble.com/The-issue-of-import-data-from-databas e-using-Solr-DIH-tp2845318p2846296.html Sent from the Solr - User mailing list archive at Nabble.com.