[jira] [Commented] (SOLR-8845) SolrJ JDBC - Ensure that Spark works with SolrJ JDBC

["Kevin Risden (JIRA)" <ji...@apache.org>]

    [ 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-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org