See: http://wiki.apache.org/solr/SchemaXml
By adding ' "multiValued="true" ' to the field, you can add
the same field multiple times in a doc, something like
<add>
<doc>
<field name="mv">value1</field>
<field name="mv">value2</field>
</doc>
</add>
But there's no real ability in Solr to store "sub documents",
so you'd have to get creative in how you encoded the discounts...
But I suspect a better approach would be to store each discount as
a separate document. If you're in the trunk version, you could then
group results by, say, ISBN and get responses grouped together...
Best
Erick
On Sat, Jun 4, 2011 at 1:42 AM, Judioo <cont...@judioo.com> wrote:
> Hi,
> Discounts can change daily. Also there can be a lot of them (over time and
> in a given time period ).
>
> Could you give an example of what you mean buy multi-valuing the field.
>
> Thanks
>
> On 3 June 2011 14:29, Erick Erickson <erickerick...@gmail.com> wrote:
>
>> How often are the discounts changed? Because you can simply
>> re-index the book information with a multiValued "discounts" field
>> and get something similar to your example (&wt=json)....
>>
>>
>> Best
>> Erick
>>
>> On Fri, Jun 3, 2011 at 8:38 AM, Judioo <cont...@judioo.com> wrote:
>> > What is the "best practice" method to index the following in Solr:
>> >
>> > I'm attempting to use solr for a book store site.
>> >
>> > Each book will have a price but on occasions this will be discounted. The
>> > discounted price exists for a defined time period but there may be many
>> > discount periods. Each discount will have a brief synopsis, start and end
>> > time.
>> >
>> > A subset of the desired output would be as follows:
>> >
>> > .......
>> > "response":{"numFound":1,"start":0,"docs":[
>> > {
>> > "name":"The Book",
>> > "price":"$9.99",
>> > "discounts":[
>> > {
>> > "price":"$3.00",
>> > "synopsis":"thanksgiving special",
>> > "starts":"11-24-2011",
>> > "ends":"11-25-2011",
>> > },
>> > {
>> > "price":"$4.00",
>> > "synopsis":"Canadian thanksgiving special",
>> > "starts":"10-10-2011",
>> > "ends":"10-11-2011",
>> > },
>> > ]
>> > },
>> > .........
>> >
>> > A requirement is to be able to search for just discounted publications. I
>> > think I could use date faceting for this ( return publications that are
>> > within a discount window ). When a discount search is performed no
>> > publications that are not currently discounted will be returned.
>> >
>> > My question are:
>> >
>> > - Does solr support this type of sub documents
>> >
>> > In the above example the discounts are the sub documents. I know solr is
>> not
>> > a relational DB but I would like to store and index the above
>> representation
>> > in a single document if possible.
>> >
>> > - what is the best method to approach the above
>> >
>> > I can see in many examples the authors tend to denormalize to solve
>> similar
>> > problems. This suggest that for each discount I am required to duplicate
>> the
>> > book data or form a document
>> > association<http://stackoverflow.com/questions/2689399/solr-associations
>> >.
>> > Which method would you advise?
>> >
>> > It would be nice if solr could return a response structured as above.
>> >
>> > Much Thanks
>> >
>>
>
