lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mel Mason <mel.ma...@bodleian.ox.ac.uk>
Subject Re: JSON Facet doesn't allow date range facets
Date Thu, 12 Dec 2019 12:18:42 GMT
I need to store date ranges in the index. While DatePointField can be 
queried using date ranges, the actual value can only be a single date - 
it can't represent a range of dates as far as I know.

On 12/12/2019 12:11, Joel Bernstein wrote:
> So something like this should work:
>
> [2000-05-01T00:00:01Z TO 2019-06-02T00:00:01Z]
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
>
> On Thu, Dec 12, 2019 at 7:08 AM Joel Bernstein <joelsolr@gmail.com> wrote:
>
>> With the DatePointField you can still do the range query, but I believe
>> you'll need to specify the full ISO date string: 2000-05-01T01:01:01Z
>>
>> Joel Bernstein
>> http://joelsolr.blogspot.com/
>>
>>
>> On Thu, Dec 12, 2019 at 6:46 AM Mel Mason <mel.mason@bodleian.ox.ac.uk>
>> wrote:
>>
>>> Unfortunately I need a date range field, e.g [2000-05-01 TO 2019-06-02].
>>> DatePointFields can't represent that as far as I know.
>>>
>>> On 12/12/2019 11:40, Joel Bernstein wrote:
>>>> There is a field type in the schema called pdate:
>>>>
>>>> <fieldType name="pdate" class="solr.DatePointField" docValues="true"/>
>>>>
>>>> This should work for you.
>>>>
>>>> The timeseries Streaming Expression uses the JSON facet API for range
>>>> faceting and works really well.
>>>>
>>>>
>>>>
>>>>
>>>> Joel Bernstein
>>>> http://joelsolr.blogspot.com/
>>>>
>>>>
>>>> On Thu, Dec 12, 2019 at 6:28 AM Mel Mason <mel.mason@bodleian.ox.ac.uk>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I'm trying to have a range facet on a field of type
>>> solr.DateRangeField.
>>>>> As far as I can tell, this isn't possible with JSONFacet, only with the
>>>>> old facet system - a quick google turns up several other people with
>>> the
>>>>> same problem. When using JSONFacet I get problems with this line of
>>>>> code:
>>>>>
>>>>>
>>> https://github.com/apache/lucene-solr/blob/master/solr/core/src/java/org/apache/solr/search/facet/FacetRange.java#L255
>>>>> It looks like during the change to JSONFacet the range facets have been
>>>>> restricted to only allow Trie or PointField fields. Is this likely to
>>> be
>>>>> fixed in future updates, or were there problems with using
>>>>> DateRangeFields? I could use the old parameter facet system, but there
>>>>> are features in JSONFacet I need.
>>>>>
>>>>> For completeness, the error I get:
>>>>>
>>>>> org.apache.solr.common.SolrException: Unable to range facet on
>>>>> field:date_dtr
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetRangeProcessor.getCalcForField(FacetRange.java:238)
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetRangeProcessor.<init>(FacetRange.java:122)
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetRange.createFacetProcessor(FacetRange.java:65)
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetRequest.process(FacetRequest.java:397)
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetProcessor.processSubs(FacetProcessor.java:475)
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetProcessor.fillBucket(FacetProcessor.java:432)
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetQueryProcessor.process(FacetQuery.java:64)
>>>>>           at
>>>>>
>>> org.apache.solr.search.facet.FacetRequest.process(FacetRequest.java:401)
>>>>>           at
>>>>> org.apache.solr.search.facet.FacetModule.process(FacetModule.java:146)
>>>>>           at
>>>>>
>>> org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:298)
>>>>>           at
>>>>>
>>> org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:199)
>>>>>           at org.apache.solr.core.SolrCore.execute(SolrCore.java:2566)
>>>>>           at
>>>>> org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:756)
>>>>>           at
>>> org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:542)
>>>>>           at
>>>>>
>>> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:397)
>>>>>           at
>>>>>
>>> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:343)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1588)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1557)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:335)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
>>>>>           at org.eclipse.jetty.server.Server.handle(Server.java:502)
>>>>>           at
>>>>> org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
>>>>>           at org.eclipse.jetty.io
>>>>> .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
>>>>>           at org.eclipse.jetty.io
>>>>> .FillInterest.fillable(FillInterest.java:103)
>>>>>           at org.eclipse.jetty.io
>>>>> .ChannelEndPoint$2.run(ChannelEndPoint.java:118)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
>>>>>           at
>>>>>
>>> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
>>>>>           at java.lang.Thread.run(Thread.java:748)
>>>>>
>>>>> Thanks,
>>>>>
>>>>> --
>>>>> Mel Mason
>>>>> Software Engineer
>>>>> Bodleian Digital Library Systems and Services
>>>>> Osney One
>>>>> Mon-Thurs
>>>>>
>>>>> 01865 280031
>>>>> mel.mason@bodleian.ox.ac.uk
>>>>>
>>>>>

Mime
View raw message