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 <joels...@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 <pra...@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 > > >
