[ https://issues.apache.org/jira/browse/SOLR-7721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ramzi Alqrainy updated SOLR-7721: --------------------------------- Description: I have the below schema, and I indexed documents with float fields {code:title=schema.xml|borderStyle=solid} <field name="SKU" type="string" indexed="true" stored="true" multiValued="false"/> <field name="ProductID" type="string" indexed="true" stored="true" multiValued="false"/> <field name="NormalizedAverageReview" type="tfloat" default="0.0" indexed="true" stored="false" multiValued="false"/> {code} Afterwards I add the following documents: {code:xml} <doc> <field name="SKU">P1SKU00</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">0.0</field> </doc> <doc> <field name="SKU">P1SKU05</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">0.5</field> </doc> <doc> <field name="SKU">P1SKU10</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">1.0</field> </doc> <doc> <field name="SKU">P1SKU15</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">1.5</field> </doc> <doc> <field name="SKU">P1SKU20</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">2.0</field> </doc> <doc> <field name="SKU">P1SKU25</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">2.5</field> </doc> <doc> <field name="SKU">P1SKU30</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">3.0</field> </doc> <doc> <field name="SKU">P1SKU35</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">3.5</field> </doc> <doc> <field name="SKU">P2SKU05</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">0.5</field> </doc> <doc> <field name="SKU">P2SKU15</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">1.5</field> </doc> <doc> <field name="SKU">P2SKU25</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">2.5</field> </doc> <doc> <field name="SKU">P2SKU35</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">3.5</field> </doc> <doc> <field name="SKU">P3SKU00</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">0.0</field> </doc> <doc> <field name="SKU">P3SKU10</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">1.0</field> </doc> <doc> <field name="SKU">P3SKU20</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">2.0</field> </doc> <doc> <field name="SKU">P3SKU30</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">3.0</field> </doc> <doc> <field name="SKU">P4SKU45</field> <field name="ProductID">P4</field> <field name="NormalizedAverageReview">4.5</field> </doc> <doc> <field name="SKU">P4SKU50</field> <field name="ProductID">P4</field> <field name="NormalizedAverageReview">5.0</field> </doc> {code} After performing the following query http://localhost:8983/solr/collection1/select?q=ProductID:P1&wt=json&indent=true&facet=true&facet.field=NormalizedAverageReview&indent=true There are duplicate facets returned {code:title=Response|borderStyle=solid} { "responseHeader":{ "status":0, "QTime":2, "params":{ "q":"ProductID:P1", "facet.field":"NormalizedAverageReview", "indent":["true", "true"], "wt":"json", "facet":"true"}}, "response":{"numFound":8,"start":0,"docs":[ { "SKU":"P1SKU00", "ProductID":"P1", "_version_":1504885971465797632, "tx_CategoryEnabled":false}, { "SKU":"P1SKU05", "ProductID":"P1", "_version_":1504885971547586560, "tx_CategoryEnabled":false}, { "SKU":"P1SKU10", "ProductID":"P1", "_version_":1504885971549683712, "tx_CategoryEnabled":false}, { "SKU":"P1SKU15", "ProductID":"P1", "_version_":1504885971551780864, "tx_CategoryEnabled":false}, { "SKU":"P1SKU20", "ProductID":"P1", "_version_":1504885971552829440, "tx_CategoryEnabled":false}, { "SKU":"P1SKU25", "ProductID":"P1", "_version_":1504885971554926592, "tx_CategoryEnabled":false}, { "SKU":"P1SKU30", "ProductID":"P1", "_version_":1504885971555975168, "tx_CategoryEnabled":false}, { "SKU":"P1SKU35", "ProductID":"P1", "_version_":1504885971557023744, "tx_CategoryEnabled":false}] }, "facet_counts":{ "facet_queries":{}, "facet_fields":{ "NormalizedAverageReview":[ "0.0",1, "0.5",1, "1.0",1, "1.5",1, "2.0",1, "2.5",1, "3.0",1, "3.5",1, "4.5",0, "5.0",0]}, "facet_dates":{}, "facet_ranges":{}, "facet_intervals":{}}} {code} If you notice the facet results, there are values repeated in there. For example 4.5 has 2 values (1, 0) as do many of the values. we would expect only 1 entry per value. Seems incorrect that there are duplicates with different values. Please advice. was: I have the below schema, and I indexed documents with float fields {code:title=schema.xml|borderStyle=solid} <field name="SKU" type="string" indexed="true" stored="true" multiValued="false"/> <field name="ProductID" type="string" indexed="true" stored="true" multiValued="false"/> <field name="NormalizedAverageReview" type="tfloat" default="0.0" indexed="true" stored="false" multiValued="false"/> {code} Afterwards I add the following documents: {code:xml} <doc> <field name="SKU">P1SKU00</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">0.0</field> </doc> <doc> <field name="SKU">P1SKU05</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">0.5</field> </doc> <doc> <field name="SKU">P1SKU10</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">1.0</field> </doc> <doc> <field name="SKU">P1SKU15</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">1.5</field> </doc> <doc> <field name="SKU">P1SKU20</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">2.0</field> </doc> <doc> <field name="SKU">P1SKU25</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">2.5</field> </doc> <doc> <field name="SKU">P1SKU30</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">3.0</field> </doc> <doc> <field name="SKU">P1SKU35</field> <field name="ProductID">P1</field> <field name="NormalizedAverageReview">3.5</field> </doc> <doc> <field name="SKU">P2SKU05</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">0.5</field> </doc> <doc> <field name="SKU">P2SKU15</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">1.5</field> </doc> <doc> <field name="SKU">P2SKU25</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">2.5</field> </doc> <doc> <field name="SKU">P2SKU35</field> <field name="ProductID">P2</field> <field name="NormalizedAverageReview">3.5</field> </doc> <doc> <field name="SKU">P3SKU00</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">0.0</field> </doc> <doc> <field name="SKU">P3SKU10</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">1.0</field> </doc> <doc> <field name="SKU">P3SKU20</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">2.0</field> </doc> <doc> <field name="SKU">P3SKU30</field> <field name="ProductID">P3</field> <field name="NormalizedAverageReview">3.0</field> </doc> <doc> <field name="SKU">P4SKU45</field> <field name="ProductID">P4</field> <field name="NormalizedAverageReview">4.5</field> </doc> <doc> <field name="SKU">P4SKU50</field> <field name="ProductID">P4</field> <field name="NormalizedAverageReview">5.0</field> </doc> {code} After performing the following query http://localhost:8983/solr/collection1/select?q=ProductID:P1&wt=json&indent=true&facet=true&facet.field=NormalizedAverageReview&indent=true There are duplicate facets returned {code:title=Response|borderStyle=solid} { "responseHeader":{ "status":0, "QTime":2, "params":{ "q":"ProductID:P1", "facet.field":"NormalizedAverageReview", "indent":["true", "true"], "wt":"json", "facet":"true"}}, "response":{"numFound":8,"start":0,"docs":[ { "SKU":"P1SKU00", "ProductID":"P1", "_version_":1504885971465797632, "tx_CategoryEnabled":false}, { "SKU":"P1SKU05", "ProductID":"P1", "_version_":1504885971547586560, "tx_CategoryEnabled":false}, { "SKU":"P1SKU10", "ProductID":"P1", "_version_":1504885971549683712, "tx_CategoryEnabled":false}, { "SKU":"P1SKU15", "ProductID":"P1", "_version_":1504885971551780864, "tx_CategoryEnabled":false}, { "SKU":"P1SKU20", "ProductID":"P1", "_version_":1504885971552829440, "tx_CategoryEnabled":false}, { "SKU":"P1SKU25", "ProductID":"P1", "_version_":1504885971554926592, "tx_CategoryEnabled":false}, { "SKU":"P1SKU30", "ProductID":"P1", "_version_":1504885971555975168, "tx_CategoryEnabled":false}, { "SKU":"P1SKU35", "ProductID":"P1", "_version_":1504885971557023744, "tx_CategoryEnabled":false}] }, "facet_counts":{ "facet_queries":{}, "facet_fields":{ "NormalizedAverageReview":[ "0.0",1, "0.5",1, "1.0",1, "1.5",1, "2.0",1, "2.5",1, "3.0",1, "3.5",1, "4.5",0, "5.0",0]}, "facet_dates":{}, "facet_ranges":{}, "facet_intervals":{}}} {code} If you notice the facet results, there are values repeated in there. For example 1.5 has 2 values (1, 0) as do many of the values. we would expect only 1 entry per value. Seems incorrect that there are duplicates with different values. Please advice. > When using group.facet=true there are duplicate facets returned > ---------------------------------------------------------------- > > Key: SOLR-7721 > URL: https://issues.apache.org/jira/browse/SOLR-7721 > Project: Solr > Issue Type: Bug > Components: Facet Module, faceting > Affects Versions: 4.10.4 > Environment: JDK 1.8, Linux Ubuntu 14.4 LTS, 16 GB RAM, 2.9 GHZ CPU > Reporter: Ramzi Alqrainy > > I have the below schema, and I indexed documents with float fields > {code:title=schema.xml|borderStyle=solid} > <field name="SKU" type="string" indexed="true" stored="true" > multiValued="false"/> > <field name="ProductID" type="string" indexed="true" stored="true" > multiValued="false"/> > <field name="NormalizedAverageReview" type="tfloat" default="0.0" > indexed="true" stored="false" multiValued="false"/> > {code} > Afterwards I add the following documents: > {code:xml} > <doc> > <field name="SKU">P1SKU00</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">0.0</field> > </doc> > <doc> > <field name="SKU">P1SKU05</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">0.5</field> > </doc> > <doc> > <field name="SKU">P1SKU10</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">1.0</field> > </doc> > <doc> > <field name="SKU">P1SKU15</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">1.5</field> > </doc> > <doc> > <field name="SKU">P1SKU20</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">2.0</field> > </doc> > <doc> > <field name="SKU">P1SKU25</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">2.5</field> > </doc> > <doc> > <field name="SKU">P1SKU30</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">3.0</field> > </doc> > <doc> > <field name="SKU">P1SKU35</field> > <field name="ProductID">P1</field> > <field name="NormalizedAverageReview">3.5</field> > </doc> > <doc> > <field name="SKU">P2SKU05</field> > <field name="ProductID">P2</field> > <field name="NormalizedAverageReview">0.5</field> > </doc> > <doc> > <field name="SKU">P2SKU15</field> > <field name="ProductID">P2</field> > <field name="NormalizedAverageReview">1.5</field> > </doc> > <doc> > <field name="SKU">P2SKU25</field> > <field name="ProductID">P2</field> > <field name="NormalizedAverageReview">2.5</field> > </doc> > <doc> > <field name="SKU">P2SKU35</field> > <field name="ProductID">P2</field> > <field name="NormalizedAverageReview">3.5</field> > </doc> > <doc> > <field name="SKU">P3SKU00</field> > <field name="ProductID">P3</field> > <field name="NormalizedAverageReview">0.0</field> > </doc> > <doc> > <field name="SKU">P3SKU10</field> > <field name="ProductID">P3</field> > <field name="NormalizedAverageReview">1.0</field> > </doc> > <doc> > <field name="SKU">P3SKU20</field> > <field name="ProductID">P3</field> > <field name="NormalizedAverageReview">2.0</field> > </doc> > <doc> > <field name="SKU">P3SKU30</field> > <field name="ProductID">P3</field> > <field name="NormalizedAverageReview">3.0</field> > </doc> > <doc> > <field name="SKU">P4SKU45</field> > <field name="ProductID">P4</field> > <field name="NormalizedAverageReview">4.5</field> > </doc> > <doc> > <field name="SKU">P4SKU50</field> > <field name="ProductID">P4</field> > <field name="NormalizedAverageReview">5.0</field> > </doc> > {code} > After performing the following query > http://localhost:8983/solr/collection1/select?q=ProductID:P1&wt=json&indent=true&facet=true&facet.field=NormalizedAverageReview&indent=true > There are duplicate facets returned > {code:title=Response|borderStyle=solid} > { > "responseHeader":{ > "status":0, > "QTime":2, > "params":{ > "q":"ProductID:P1", > "facet.field":"NormalizedAverageReview", > "indent":["true", > "true"], > "wt":"json", > "facet":"true"}}, > "response":{"numFound":8,"start":0,"docs":[ > { > "SKU":"P1SKU00", > "ProductID":"P1", > "_version_":1504885971465797632, > "tx_CategoryEnabled":false}, > { > "SKU":"P1SKU05", > "ProductID":"P1", > "_version_":1504885971547586560, > "tx_CategoryEnabled":false}, > { > "SKU":"P1SKU10", > "ProductID":"P1", > "_version_":1504885971549683712, > "tx_CategoryEnabled":false}, > { > "SKU":"P1SKU15", > "ProductID":"P1", > "_version_":1504885971551780864, > "tx_CategoryEnabled":false}, > { > "SKU":"P1SKU20", > "ProductID":"P1", > "_version_":1504885971552829440, > "tx_CategoryEnabled":false}, > { > "SKU":"P1SKU25", > "ProductID":"P1", > "_version_":1504885971554926592, > "tx_CategoryEnabled":false}, > { > "SKU":"P1SKU30", > "ProductID":"P1", > "_version_":1504885971555975168, > "tx_CategoryEnabled":false}, > { > "SKU":"P1SKU35", > "ProductID":"P1", > "_version_":1504885971557023744, > "tx_CategoryEnabled":false}] > }, > "facet_counts":{ > "facet_queries":{}, > "facet_fields":{ > "NormalizedAverageReview":[ > "0.0",1, > "0.5",1, > "1.0",1, > "1.5",1, > "2.0",1, > "2.5",1, > "3.0",1, > "3.5",1, > "4.5",0, > "5.0",0]}, > "facet_dates":{}, > "facet_ranges":{}, > "facet_intervals":{}}} > {code} > If you notice the facet results, there are values repeated in there. For > example 4.5 has 2 values (1, 0) as do many of the values. we would expect > only 1 entry per value. Seems incorrect that there are duplicates with > different values. > Please advice. -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org