The issue of import data from database using Solr DIH

[Kevin Xiang]

Hi all,
I am a new to solr,I am importing data from database using DIH(solr
1.4).One document is made up of two entity,Every entity is a table in
database.
For example:
Table1:have 3 fields;
Table2:have 4 fields;
If it is Ok,it will be 7 fields.
But it is only 4 fields,it seem that solr don't merge the fields and
table2 over write table1.
The key is OS06Y.
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>
Has anyone come across this issue?
Any suggestions on how to fix this issue is much appreciated. 
Thanks.