You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@lucene.apache.org by a_bains <aa...@gmail.com> on 2011/08/29 19:41:45 UTC
Solr Facets with non-unique productid
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 there is only one instance of each
productid. If I can resolve this, then it should allow me to do facet
queries. Please help!
Here is a snippet of what 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 |
+-----------+-------------+---------+------------+
--
View this message in context: http://lucene.472066.n3.nabble.com/Solr-Facets-with-non-unique-productid-tp3293274p3293274.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: Solr Facets with non-unique productid
Posted by "Smiley, David W." <ds...@mitre.org>.
Hi. You are using the wrong mailing list. Try solr-user instead.
~ David Smiley
On 8/29/11 1:41 PM, "a_bains" <aa...@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 there is only one instance of each
>productid. If I can resolve this, then it should allow me to do facet
>queries. Please help!
>
>Here is a snippet of what 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 |
>+-----------+-------------+---------+------------+
>
>
>--
>View this message in context:
>http://lucene.472066.n3.nabble.com/Solr-Facets-with-non-unique-productid-t
>p3293274p3293274.html
>Sent from the Lucene - General mailing list archive at Nabble.com.