[
https://issues.apache.org/jira/browse/SOLR-8593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17433208#comment-17433208
]
David Smiley commented on SOLR-8593:
------------------------------------
Thanks Julian. I tried removing both and tests don't pass; both lead to –
ClassNotFoundException. I won't pursue this further. I'm most surprised by
the ESRI dependency because ST_Distance would take some integration with Solr
for it (I think) and none has been done. I'll share a snippet of the
ClassNotFoundException stack trace:
{noformat}
> at
org.apache.calcite.linq4j.tree.Types.lookupMethod(Types.java:309)
> at
org.apache.calcite.util.BuiltInMethod.<init>(BuiltInMethod.java:666)
> at
org.apache.calcite.util.BuiltInMethod.<clinit>(BuiltInMethod.java:390)
> at
org.apache.calcite.rel.metadata.RelMdPercentageOriginalRows.<clinit>(RelMdPercentageOriginalRows.java:44)
> at
org.apache.calcite.rel.metadata.DefaultRelMetadataProvider.<init>(DefaultRelMetadataProvider.java:42)
> at
org.apache.calcite.rel.metadata.DefaultRelMetadataProvider.<clinit>(DefaultRelMetadataProvider.java:28)
> at
org.apache.calcite.plan.RelOptCluster.<init>(RelOptCluster.java:97)
> at
org.apache.calcite.plan.RelOptCluster.create(RelOptCluster.java:106)
> at
org.apache.calcite.prepare.CalcitePrepareImpl.createCluster(CalcitePrepareImpl.java:406)
> at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:602)
> at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:513)
> at
org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:483)
> at
org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:249)
> at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:623)
> at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:675)
> at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
> at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227)
{noformat}
> Integrate Apache Calcite into the SQLHandler
> --------------------------------------------
>
> Key: SOLR-8593
> URL: https://issues.apache.org/jira/browse/SOLR-8593
> Project: Solr
> Issue Type: Improvement
> Components: Parallel SQL
> Reporter: Joel Bernstein
> Assignee: Joel Bernstein
> Priority: Major
> Fix For: 6.5, 7.0
>
> Attachments: SOLR-8593.patch, SOLR-8593.patch, SOLR-8593.patch
>
>
> The Presto SQL Parser was perfect for phase one of the SQLHandler. It was
> nicely split off from the larger Presto project and it did everything that
> was needed for the initial implementation.
> Phase two of the SQL work though will require an optimizer. Here is where
> Apache Calcite comes into play. It has a battle tested cost based optimizer
> and has been integrated into Apache Drill and Hive.
> This work can begin in trunk following the 6.0 release. The final query plans
> will continue to be translated to Streaming API objects (TupleStreams), so
> continued work on the JDBC driver should plug in nicely with the Calcite work.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
