lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Willie Whitehead <bwilst...@gmail.com>
Subject Distinct values versus schema change?
Date Wed, 25 Aug 2010 17:50:02 GMT
Hi,

I'm having a problem where a Solr query on all items in one category
is returning duplicated items when an item appears in more than one
subcategory. My schema involves a document for each item's subcategory
instance. I know this is not correct.

I'm not sure if I ever tried multiple values on subcategories. (Before
the latest changes to the schema, I was only getting the first
subcategory instance and I had a problem with parentcgyid.) Could you
review the 3 results from 1 item below and advise how I can return
only Distinct values for the itmid field?

I think it's best that I change the schema to support multiple values.
I'm currently already using faceting for the subcategories. Do I have
to use it for this purpose also, or should I move forward to improve
my schema configuration?

<doc>
<str name="cgyid">14440</str>
<str name="itmdsc">Girl Costume</str>
<str name="itmid">GIRLCOSTUME</str>
<str name="itmkey">14440-GIRLCOSTUME</str>
<str name="itmnam">Girl Costume Girl Child</str>
<float name="lstprc">9.99</float>
<str name="parcgyid">1400</str>
<str name="parcgynam">Girls Costumes</str>
<float name="prc">8.99</float>
<str name="seoitm">girl-costume-for-child-GIRLCOSTUME</str>
<str name="seoparcgy">girls+costumes</str>
<str name="seosubcgy">occupational</str>
-
<arr name="size">
<str>L</str>
<str>M</str>
<str>S</str>
</arr>
<str name="stock">In Stock</str>
<str name="subcgynam">Occupational|14440</str>
</doc>
-
<doc>
<str name="cgyid">14150</str>
<str name="itmdsc">Girl Costume</str>
<str name="itmid">GIRLCOSTUME</str>
<str name="itmkey">14150-GIRLCOSTUME</str>
<str name="itmnam">Girl Costume Girl Child</str>
<float name="lstprc">9.99</float>
<str name="parcgyid">1400</str>
<str name="parcgynam">Girls Costumes</str>
<float name="prc">8.99</float>
<str name="seoitm">girl-costume-for-child-GIRLCOSTUME</str>
<str name="seoparcgy">girls+costumes</str>
<str name="seosubcgy">classic</str>
-
<arr name="size">
<str>L</str>
<str>M</str>
<str>S</str>
</arr>
<str name="stock">In Stock</str>
<str name="subcgynam">Classic|14150</str>
</doc>
-
<doc>
<str name="cgyid">14010</str>
<str name="itmdsc">Girl Costume</str>
<str name="itmid">GIRLCOSTUME</str>
<str name="itmkey">14010-GIRLCOSTUME</str>
<str name="itmnam">Girl Costume Girl Child</str>
<float name="lstprc">9.99</float>
<str name="parcgyid">1400</str>
<str name="parcgynam">Girls Costumes</str>
<float name="prc">8.99</float>
<str name="seoitm">girl-costume-for-child-GIRLCOSTUME</str>
<str name="seoparcgy">girls+costumes</str>
<str name="seosubcgy">50s+costumes</str>
-
<arr name="size">
<str>L</str>
<str>M</str>
<str>S</str>
</arr>
<str name="stock">In Stock</str>
<str name="subcgynam">50's Costumes|14010</str>
</doc>


Thanks!

Mime
View raw message