lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pratik Patel <pra...@semandex.net>
Subject Re: BooleanEvaluator inside 'having' function of a streaming expression
Date Mon, 13 Mar 2017 17:35:36 GMT
it's not a stable version*

On Mon, Mar 13, 2017 at 1:34 PM, Pratik Patel <pratik@semandex.net> wrote:

> Thanks Joel! This is just a simplified sample query that I created to
> better demonstrate the issue. I am not sure whether I want to upgrade to
> solr 6.5 as only developer version is available yet and it's a stable
> version as far as I know. Thanks for the clarification. I will try to find
> some other logic for my query.
>
> On Mon, Mar 13, 2017 at 1:23 PM, Joel Bernstein <joelsolr@gmail.com>
> wrote:
>
>> If you're using Solr 6.4 then the expression you're running won't work,
>> because on numeric comparisons are supported.
>>
>> Solr 6.5 will have the expanded Evaluator functionality, which has string
>> comparisons.
>>
>> In the expression you're working with it would be much more performant
>> though to filter the query on the storeid.
>>
>> Joel Bernstein
>> http://joelsolr.blogspot.com/
>>
>> On Mon, Mar 13, 2017 at 1:06 PM, Pratik Patel <pratik@semandex.net>
>> wrote:
>>
>> > Hi,
>> >
>> > I am trying to write a streaming expression with 'having' function in
>> it.
>> > Following is my simple query.
>> >
>> >
>> > having(
>> > >    search(collection1,q="*:*",fl="storeid",sort="storeid
>> > > asc",fq=tags:"Company"),
>> > >    eq(storeid,524efcfd505637004b1f6f24)
>> > > )
>> >
>> >
>> > Here, storeid is a field of type "string" in schema. But when I execute
>> > this query in admin UI, I am getting a  NumberFormatException.
>> >
>> > Here is the response in admin UI.
>> >
>> >
>> > { "result-set": { "docs": [ { "EXCEPTION": "For input string:
>> > \"524efcfd505637004b1f6f24\"", "EOF": true } ] } }
>> >
>> > If I change storeid value to 123 in the boolean evaluator then it works
>> > fine. I tried to quote the original value so that we have
>> > eq(storeid,"524efcfd505637004b1f6f24") but still it fails with same
>> > exception.
>> >
>> > Here is the detailed stack trace from log file.
>> >
>> >
>> > ERROR - 2017-03-13 16:56:39.516; [c:collection1 s:shard1 r:core_node1
>> > > x:collection1_shard1_replica1] org.apache.solr.common.SolrException;
>> > > java.io.IOException: Unable to construct instance of
>> > > org.apache.solr.client.solrj.io.stream.HavingStream
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.expr.StreamFactory.
>> > createInstance(StreamFactory.java:358)
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.expr.StreamFactory.
>> > constructStream(StreamFactory.java:222)
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.expr.StreamFactory.
>> > constructStream(StreamFactory.java:215)
>> > > at
>> > > org.apache.solr.handler.StreamHandler.handleRequestBody(
>> > StreamHandler.java:212)
>> > > at
>> > > org.apache.solr.handler.RequestHandlerBase.handleRequest(
>> > RequestHandlerBase.java:166)
>> > > at org.apache.solr.core.SolrCore.execute(SolrCore.java:2306)
>> > > at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.
>> java:658)
>> > > at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:464)
>> > > at
>> > > org.apache.solr.servlet.SolrDispatchFilter.doFilter(
>> > SolrDispatchFilter.java:345)
>> > > at
>> > > org.apache.solr.servlet.SolrDispatchFilter.doFilter(
>> > SolrDispatchFilter.java:296)
>> > > at
>> > > org.eclipse.jetty.servlet.ServletHandler$CachedChain.
>> > doFilter(ServletHandler.java:1691)
>> > > at
>> > > org.eclipse.jetty.servlet.ServletHandler.doHandle(
>> > ServletHandler.java:582)
>> > > at
>> > > org.eclipse.jetty.server.handler.ScopedHandler.handle(
>> > ScopedHandler.java:143)
>> > > at
>> > > org.eclipse.jetty.security.SecurityHandler.handle(
>> > SecurityHandler.java:548)
>> > > at
>> > > org.eclipse.jetty.server.session.SessionHandler.
>> > doHandle(SessionHandler.java:226)
>> > > at
>> > > org.eclipse.jetty.server.handler.ContextHandler.
>> > doHandle(ContextHandler.java:1180)
>> > > at
>> > > org.eclipse.jetty.servlet.ServletHandler.doScope(
>> > ServletHandler.java:512)
>> > > at
>> > > org.eclipse.jetty.server.session.SessionHandler.
>> > doScope(SessionHandler.java:185)
>> > > at
>> > > org.eclipse.jetty.server.handler.ContextHandler.
>> > doScope(ContextHandler.java:1112)
>> > > at
>> > > org.eclipse.jetty.server.handler.ScopedHandler.handle(
>> > ScopedHandler.java:141)
>> > > at
>> > > org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(
>> > ContextHandlerCollection.java:213)
>> > > at
>> > > org.eclipse.jetty.server.handler.HandlerCollection.
>> > handle(HandlerCollection.java:119)
>> > > at
>> > > org.eclipse.jetty.server.handler.HandlerWrapper.handle(
>> > HandlerWrapper.java:134)
>> > > at org.eclipse.jetty.server.Server.handle(Server.java:534)
>> > > at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
>> > > at
>> > > org.eclipse.jetty.server.HttpConnection.onFillable(
>> > HttpConnection.java:251)
>> > > at
>> > > org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(
>> > AbstractConnection.java:273)
>> > > at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
>> > > at
>> > > org.eclipse.jetty.io.SelectChannelEndPoint$2.run(
>> > SelectChannelEndPoint.java:93)
>> > > at
>> > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.
>> > executeProduceConsume(ExecuteProduceConsume.java:303)
>> > > at
>> > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.
>> > produceConsume(ExecuteProduceConsume.java:148)
>> > > at
>> > > org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(
>> > ExecuteProduceConsume.java:136)
>> > > at
>> > > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(
>> > QueuedThreadPool.java:671)
>> > > at
>> > > org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(
>> > QueuedThreadPool.java:589)
>> > > at java.lang.Thread.run(Unknown Source)
>> > > Caused by: java.lang.reflect.InvocationTargetException
>> > > at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown
>> > Source)
>> > > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
>> > > Source)
>> > > at java.lang.reflect.Constructor.newInstance(Unknown Source)
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.expr.StreamFactory.
>> > createInstance(StreamFactory.java:351)
>> > > ... 34 more
>> > > Caused by: java.io.IOException: Unable to construct instance of
>> > > org.apache.solr.client.solrj.io.ops.EqualsOperation
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.expr.StreamFactory.
>> > createInstance(StreamFactory.java:358)
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.expr.StreamFactory.
>> > constructOperation(StreamFactory.java:339)
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.HavingStream.<init>(
>> > HavingStream.java:72)
>> > > ... 38 more
>> > > Caused by: java.lang.reflect.InvocationTargetException
>> > > at sun.reflect.GeneratedConstructorAccessor27.newInstance(Unknown
>> > Source)
>> > > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
>> > > Source)
>> > > at java.lang.reflect.Constructor.newInstance(Unknown Source)
>> > > at
>> > > org.apache.solr.client.solrj.io.stream.expr.StreamFactory.
>> > createInstance(StreamFactory.java:351)
>> > > ... 40 more
>> > > Caused by: java.lang.NumberFormatException: For input string:
>> > > "524efcfd505637004b1f6f24"
>> > > at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
>> > > at sun.misc.FloatingDecimal.parseDouble(Unknown Source)
>> > > at java.lang.Double.parseDouble(Unknown Source)
>> > > at
>> > > org.apache.solr.client.solrj.io.ops.LeafOperation.<init>(
>> > LeafOperation.java:48)
>> > > at
>> > > org.apache.solr.client.solrj.io.ops.EqualsOperation.<init>(
>> > EqualsOperation.java:42)
>> > > ... 44 more
>> >
>> >
>> > I can see that solr is trying to parse storeid as double and hence the
>> > NumberFormatException, even though this field is of type String in
>> schema.
>> > How can I fix this?
>> >
>> >
>> > Thanks,
>> > Pratik
>> >
>>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message