lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Grant Ingersoll <gsing...@apache.org>
Subject Re: facet.pivot for date fields
Date Fri, 17 Dec 2010 13:14:21 GMT
I don't think pivot supports dates at this point.  Would probably be good to open an issue
to note this feature, as I do think it would be good to have.  I would think we could support
all the various facet options during pivots (dates, numbers, queries)

On Dec 16, 2010, at 9:22 PM, Adeel Qureshi wrote:

> i guess one last call for help .. i am assuming for people who wrote or have
> used the pivot faceting .. this should be a yes no question .. are date
> fields supported ?
> 
> On Wed, Dec 15, 2010 at 12:58 PM, Adeel Qureshi <adeelmahmood@gmail.com>wrote:
> 
>> Thanks Pankaj - that was useful to know. I havent used the query stuff
>> before for facets .. so that was good to know .. but the problem is still
>> there because I want the hierarchical counts which is exactly what
>> facet.pivot does ..
>> 
>> so e.g. i want to count for fieldC within fieldB and even fieldB within
>> fieldA .. that kind of stuff .. for string based fields .. facet.pivot does
>> exactly that and does it very well .. but it doesnt seems to work for date
>> ranges .. so in this case I want counts to be broken down by fieldA and
>> fieldB and then fieldB counts for monthly ranges .. I understand that I
>> might be able to use facet.query to construct several queries to get these
>> counts .. e.g. *facet.query=fieldA:someValue AND fieldB:someValue AND
>> fieldC:[NOW-1YEAR TO NOW]* .. but there could be thousand of possible
>> combinations for fieldA and fieldB which will require as many facet.queries
>> which I am assuming is not the way to go ..
>> 
>> it might be confusing what I have explained above so the simple question
>> still is if there is a way to get date range counts included in facet.pivot
>> 
>> Adeel
>> 
>> 
>> 
>> On Tue, Dec 14, 2010 at 10:53 PM, pankaj bhatt <panbhatt@gmail.com> wrote:
>> 
>>> Hi Adeel,
>>>     You can make use of facet.query attribute to make the Faceting work
>>> across a range of dates. Here i am using the duration, just replace the
>>> field with a field date and Range values as the DATE in SOLR Format.
>>> so your query parameter will be like this ( you can pass multiple
>>> parameter
>>> of "facet.query" name)
>>> 
>>> http//blasdsdfsd/q?=asdfasd&facet.query=itemduration:[0 To
>>> 49]&facet.query=itemduration:[50 To 99]&facet.query=itemduration:[100
To
>>> 149]
>>> 
>>> Hope, it helps.
>>> 
>>> / Pankaj Bhatt.
>>> 
>>> On Wed, Dec 15, 2010 at 2:01 AM, Adeel Qureshi <adeelmahmood@gmail.com
>>>> wrote:
>>> 
>>>> It doesnt seems like pivot facetting works on dates .. I was just
>>> curious
>>>> if
>>>> thats how its supposed to be or I am doing something wrong .. if I
>>> include
>>>> a
>>>> datefield in the pivot list .. i simply dont get any facet results back
>>> for
>>>> that datefield
>>>> 
>>>> Thanks
>>>> Adeel
>>>> 
>>> 
>> 
>> 

--------------------------
Grant Ingersoll
http://www.lucidimagination.com/

Search the Lucene ecosystem docs using Solr/Lucene:
http://www.lucidimagination.com/search


Mime
View raw message