Have you looked at using groups? http://wiki.apache.org/solr/FieldCollapsing
In that design, your records will actually be 'availability' with UPC,
merchantid, locationid (just one) and then you group on UPC?
Did you see Guilt's presentation on something similar?
http://www.slideshare.net/trenama
Bumping this one, with an update:
After thinking about this, I think getting rid of lat/lon will simplify
things a bit, the new query pattern:
Input: keyword=ipod, merchantId=922,locationId=81,82
Output: List of UPCs for ipod which exist inside stores 81 and 82 which
should be owned by 922
Also,
Hi guys,
I have to load extra meta data to an existing collection.
This is what I am looking for:
For a UPC: Store availability by merchantId per location (which has lat/lon)
My query pattern will be: Given a keyword, find all available products for
a merchantId around the given lat/lon.
Exampl
