it's not a stable version* On Mon, Mar 13, 2017 at 1:34 PM, Pratik Patel <pra...@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 <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 >> > >> > >
