On Mon, Nov 30, 2009 at 8:17 AM, Gupta, Saurabh <saurabh.gu...@citi.com>wrote:
> Hi, > > I am using Solr to index two database tables with a very simple > relationship. > > Table 1: PRODUCT has ID as PK > Table 2: VERSION has ID as PK and PRODUCT_ID as PK > > There is a 1:m relationship between PRODUCT AND VERSION. > > When I run full-import, for some reason only 1 row in VERSION table is > indexed per PRODUCT row. I am attaching the data-config here. > > A Solr document is flat - it does not have any nested rows. Your productVersion* fields must be multi-valued otherwise the last row from product_version table will overwrite the previous rows. -- Regards, Shalin Shekhar Mangar.