I think you need to setup entity hierarchy with product as a top level entity and attribute as another entity under product, otherwise the record #2 and 3 will override the first one.
On Mon, Aug 29, 2011 at 3:52 PM, Aaron Bains <aaronba...@gmail.com> wrote: > Hello, > > I am trying to setup Solr Faceting on products by using the > DataImportHandler to import data from my database. I have setup my > data-config.xml with the proper queries and schema.xml with the fields. > After the import/index is complete I can only search one productid record > in > Solr. For example of the three productid '10100039' records there are I am > only able to search for one of those. Should I somehow disable unique ids? > What is the best way of doing this? > > Below is the schema I am trying to index: > > +-----------+-------------+---------+------------+ > | productid | attributeid | valueid | categoryid | > +-----------+-------------+---------+------------+ > | 10100039 | 331100 | 1580 | 10000 | > | 10100039 | 331694 | 1581 | 10000 | > | 10100039 | 33113319 | 1537370 | 10000 | > | 10100040 | 331100 | 1580 | 10000 | > | 10100040 | 331694 | 1540230 | 10000 | > | 10100040 | 33113319 | 1537370 | 10000 | > +-----------+-------------+---------+------------+ > > Thanks! >