Re: Item Facet

2009-08-09 Thread Avlesh Singh
This is how it goes: 1. You create a dynamic field in the schema called "product_*". This means that while indexing, you can create fields starting with "product_" dynamically for a document. 2. If a document, doc1, is dealing with prod1 and prod2, you create fields called product_p

Re: Item Facet

2009-08-07 Thread David Lojudice Sobrinho
The behavior i'm expecting is something similar to a GROUP BY in a relational database. SELECT product_name, model, min(price), max(price), count(*) FROM t GROUP BY product_name, model The current schema: product_name (type: text) model (type: text) price (type: sfloat) On Fri, Aug 7, 2009 at

Re: Item Facet

2009-08-07 Thread Yao Ge
Are your product_name* fields numeric fields (integer or float)? Dals wrote: > > Hi... > > Is there any way to group values like shopping.yahoo.com or > shopper.cnet.com do? > > For instance, I have documents like: > > doc1 - product_name1 - value1 > doc2 - product_name1 - value2 > doc3 - p

Re: Item Facet

2009-08-07 Thread David Lojudice Sobrinho
Thanks Avlesh. But I didn't get it. How a dynamic field would aggregate values in query time? On Thu, Aug 6, 2009 at 11:14 PM, Avlesh Singh wrote: > Dynamic fields might be an answer. If you had a field called "product_*" and > these were populated with the corresponding values during indexing th

Re: Item Facet

2009-08-06 Thread Avlesh Singh
Dynamic fields might be an answer. If you had a field called "product_*" and these were populated with the corresponding values during indexing then faceting on these fields will give you the desired behavior. The only catch here is that the product names have to be known upfront. A wildcard suppo

Re: Item Facet

2009-08-06 Thread David Lojudice Sobrinho
I can't reindex because the aggregated/grouped result should change as the query changes... in other words, the result must by dynamic We've been thinking about a new handler for it something like: /select?q=laptop&rows=0&itemfacet=on&itemfacet.field=product_name,min(price),max(price) Does i

RE: Item Facet

2009-08-06 Thread Ge, Yao (Y.)
If you can reindex, simply rebuild the index with fields replaced by combining existing fields. -Yao -Original Message- From: David Lojudice Sobrinho [mailto:dalss...@gmail.com] Sent: Thursday, August 06, 2009 4:17 PM To: solr-user@lucene.apache.org Subject: Item Facet Hi... Is there