Hello, I am new to Solr and I running some tests with our data in Solr. We are using version 3.6 and the data is imported form a DB2 database using Solr's DIH. We have defined a single entity in the db-data-config.xml, which is an equivalent of the following query: <entity name="connections" query=" SELECT C.NAME, F.CITY FROM NAME_CONNECTIONS AS C JOIN NAME_DETAILS AS F ON C.DETAILS_NAME = F.NAME" > </entity>
This might lead to some names appearing multiple times in the result set. This is OK. For the unique ID in the schema, we are using a solr.UUIDField: <fieldType name="uuid" class="solr.UUIDField" indexed="true" /> <field name="id" type="uuid" indexed="true" stored="true" default="NEW"/ All the searchable fields are declared as indexed and stored. I am aware of the fact that this is a very crude configuration, but for the tests that I am running it is fine. The problem that I have is the different result counts that I receive when I do equivalent queries for searching and faceting. For example, running the following query http://localhost:8983/solr/db/select?indent=on&version=2.2&q=CITY:MILTON&fq=&start=0&rows=100&fl=*&wt=&explainOther=&hl.fl=&group=true&group.field=NAME&group.ngroups=true&group.truncate=true yields <int name="ngroups">134</int> as a result, which is exactly what we expect. On the other hand, running http://localhost:8983/solr/db/select?indent=on&version=2.2&q=*&fq=&start=0&rows=10&fl=*&wt=&explainOther=&hl.fl=&group=true&group.field=NAME&group.truncate=true&facet=true&facet.field=CITY&group.ngroups=true yields <lst name="facet_counts"> <lst name="facet_queries"/> <lst name="facet_fields"> <lst name="CITY"> <int name="MILTON">103</int> I would expect to have the same number (134) in this facet result as well. Could you please let me know why these two results are different? Thank you, Tudor -- View this message in context: http://lucene.472066.n3.nabble.com/Query-results-vs-facets-results-tp3994988.html Sent from the Solr - User mailing list archive at Nabble.com.