[ https://issues.apache.org/jira/browse/SOLR-8845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15250130#comment-15250130 ]
Kevin Risden commented on SOLR-8845: ------------------------------------ After SOLR-8809 was committed, the next issue is an error on the server from connecting with Spark. {code} java.lang.ClassCastException: com.facebook.presto.sql.tree.LongLiteral cannot be cast to com.facebook.presto.sql.tree.StringLiteral at org.apache.solr.handler.SQLHandler.getPredicateField(SQLHandler.java:1240) at org.apache.solr.handler.SQLHandler.access$800(SQLHandler.java:79) at org.apache.solr.handler.SQLHandler$ExpressionVisitor.visitComparisonExpression(SQLHandler.java:920) at org.apache.solr.handler.SQLHandler$ExpressionVisitor.visitComparisonExpression(SQLHandler.java:902) at com.facebook.presto.sql.tree.ComparisonExpression.accept(ComparisonExpression.java:77) at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22) at org.apache.solr.handler.SQLHandler$SQLVisitor.visitQuerySpecification(SQLHandler.java:1025) at org.apache.solr.handler.SQLHandler$SQLVisitor.visitQuerySpecification(SQLHandler.java:934) at com.facebook.presto.sql.tree.QuerySpecification.accept(QuerySpecification.java:98) at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22) at org.apache.solr.handler.SQLHandler$SQLVisitor.processRelation(SQLHandler.java:1154) at org.apache.solr.handler.SQLHandler$SQLVisitor.visitQuery(SQLHandler.java:1000) at org.apache.solr.handler.SQLHandler$SQLVisitor.visitQuery(SQLHandler.java:934) at com.facebook.presto.sql.tree.Query.accept(Query.java:80) at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22) at org.apache.solr.handler.SQLHandler$SQLTupleStreamParser.parse(SQLHandler.java:174) at org.apache.solr.handler.SQLHandler.handleRequestBody(SQLHandler.java:129) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:155) at org.apache.solr.core.SolrCore.execute(SolrCore.java:2015) at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:653) at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:461) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:229) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:184) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581) 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:1160) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092) 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:518) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244) 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.produceAndRun(ExecuteProduceConsume.java:246) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.lang.Thread.run(Thread.java:745) {code} > SolrJ JDBC - Ensure that Spark works with SolrJ JDBC > ---------------------------------------------------- > > Key: SOLR-8845 > URL: https://issues.apache.org/jira/browse/SOLR-8845 > Project: Solr > Issue Type: Sub-task > Components: SolrJ > Affects Versions: master > Reporter: Trey Cahill > > Ensure that Spark is able work with SolrJ JDBC. > Currently, in Spark 1.6 there are 2 known issues: > 1. SparkSQL uses a connection.prepareStatement() call, which returns null in > the SolrJ implementation > 2. SparkSQL query's via a "select *" query, which is currently not supported. -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org