Solr: index product and price for sellers and perfoming query and sorting

In my current project,  the modle seller has multiply products with price,  I want to index products and query them then sorting them by price , seller's credit ,the distance between the seller and the user while highlighting the matched products.

 

Due to solr flatten one-to-many relationship, so I should use multiVlaude field to store products and their prices for a seller. 

The schema likes

<field name="id" type="string" indexed="true" stored="true" required="true" multiValued="false" /> 
   <field name="name" type="text_ch" indexed="true" stored="true" />
   <field name="district" type="text_ch" indexed="true" stored="true" />
   <field name="location" type="location_rpt" indexed="true" stored="true" multiValued="true"/>
   <field name="commodities" type="text_ch" indexed="true" stored="true" multiValued="true"/>
   <field name="price" type="long" indexed="true" stored="true" multiValued="true"/>

 

the data indexed likes

<doc>
    <str name="id">1</str>
    <str name="name">宜宾燃面</str>
    <arr name="location">
      <str>39.916927,116.363737</str>
    </arr>
    <int name="credit">90</int>
    <str name="district">北京西城区</str>
    <date name="created_at">2015-06-18T15:34:34Z</date>
    <arr name="commodities">
      <str>炒面</str>
      <str>牛肉面</str>
    </arr>
    <arr name="price">
      <long>23</long>
      <long>18</long>
    </arr>
    <long name="_version_">1510459679273123840</long>
    <str name="data_source">seller</str></doc>
  <doc>

 

The option can't sort product by price.

 

How to do it?

---------------------------------------------------

How about to create two cores to meet  my demands?

sellers likes

<doc>
    <str name="id">1</str>
    <str name="name">宜宾燃面</str>
    <arr name="location">
      <str>39.916927,116.363737</str>
    </arr>
    <int name="credit">90</int>
    <str name="district">北京西城区</str>
    <date name="created_at">2015-06-18T15:34:34Z</date>
    <long name="_version_">1510545445415288832</long>
    <str name="data_source">seller</str></doc>
  <doc>

 

products likes

 <doc>
    <str name="id">1</str>
    <str name="name">炒面</str>
    <str name="seller_id">1</str>
    <long name="price">21</long>
    <long name="_version_">1510545648643997696</long></doc>
  <doc>

 

query likes

 "params": {
      "d": "50",
      "indent": "true",
      "spatial": "true",
      "sfield": "location",
      "hl.simple.pre": "<em>",
      "wt": "json",
      "hl": "true",
      "fl": "*,score,dist:geodist()",
      "q": "*:* AND _val_:\"product(scale(credit,1,10),recip(geodist(),3,1,0.1))\"\n",
      "pt": "30.548526,104.062889",
      "_": "1440573751492",
      "hl.simple.post": "</em>",
      "fq": [
        "{!join fromIndex=products toIndex=sellers from=seller_id to=id} name:我要一份牛肉面",
        "{!geofilt}"
      ]

 

but this option can not sort docs by  product's price and highlighting not work.  Meanwhile the product's fileds will not returned.

 

--------------------------------------

How about using nested document model?

but. I found this

All children of a parent document must be indexed together with the parent document. One cannot update any document (parent or child) individually. The entire block needs to be re-indexed of any changes need to be made.

 

Due to seller  updating his products frequently, this option cann't meet our situation.

 

 

--------------------------------------

 

 

 

 

References

http://stackoverflow.com/questions/7845337/sorting-with-multivalued-field-in-solr

http://yonik.com/solr-nested-objects/