Re: question about schemas

2009-12-08 Thread Lance Norskog
I don't know. The common way to do this in Solr is the full denormalization technique, but that blows up in this case. This is not an easy problem space to implement in Solr. Data warehousing & star schema techniques may be more appropriate. On 12/7/09, solr-user wrote: > > > Lance Norskog-2 wrot

Re: question about schemas (and SOLR-1131?)

2009-12-07 Thread solr-user
wojtekpia wrote: > > Could this be solved with a multi-valued custom field type (including a > custom comparator)? The OP's situation deals with multi-valuing products > for each customer. If products contain strictly numeric fields then it > seems like a custom field implementation (or extensio

Re: question about schemas

2009-12-07 Thread solr-user
Lance Norskog-2 wrote: > > You can make a separate facet field which contains a range of "buckets": > 10, 20, 50, or 100 means that the field has a value 0-10, 11-20, 21-50, or > 51-100. You could use a separate filter query with values for these > buckets. Filter queries are very fast in Solr 1

Re: question about schemas (and SOLR-1131?)

2009-12-04 Thread wojtekpia
Could this be solved with a multi-valued custom field type (including a custom comparator)? The OP's situation deals with multi-valuing products for each customer. If products contain strictly numeric fields then it seems like a custom field implementation (or extension of BinaryField?) *should* b

Re: question about schemas

2009-12-04 Thread solr-user
Lance Norskog-2 wrote: > > But, in general, this is a "shopping cart" database and Solr/Lucene may > not be the best fit for this problem. > True, every tool has strengths and weaknesses. Given how powerful Solr appears to be, I would be surprised if I was not able to handle this use case. L

Re: question about schemas

2009-12-03 Thread Lance Norskog
You can make a separate facet field which contains a range of "buckets": 10, 20, 50, or 100 means that the field has a value 0-10, 11-20, 21-50, or 51-100. You could use a separate filter query with values for these buckets. Filter queries are very fast in Solr 1.4 and this would limit your range q

Re: question about schemas (and SOLR-1131?)

2009-12-02 Thread gdeconto
I saw an interesting thread in the solr-dev forum about multiple fields per fieldtype (https://issues.apache.org/jira/browse/SOLR-1131) from the sounds of it, it might be of interest and/or use in these types of problems; for your example, you might be able to define a fieldtype that houses the

RE: question about schemas

2009-12-02 Thread gdeconto
I dont believe there is any way to link values in one multivalue field to values in other multivalue fields. Re "where each doc contains the customer info and info for ALL products that the customer might have (likely done via dynamicfields)": one thing you might want to consider is that this s

RE: question about schemas

2009-12-02 Thread solr-user
cbennett wrote: > > Solr supports multi value fields so you could store one document per > customer and have multi value fields for the product information. > > Colin. Quoted from: http://old.nabble.com/question-about-schemas-tp26600956p26608618.html Thanks Colin. From the online docs, there

RE: question about schemas

2009-12-02 Thread cbennett
Solr supports multi value fields so you could store one document per customer and have multi value fields for the product information. Colin. > -Original Message- > From: solr-user [mailto:solr-u...@hotmail.com] > Sent: Tuesday, December 01, 2009 6:27 PM > To: solr-user@lucene.apache.org