You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Kevin Risden (Jira)" <ji...@apache.org> on 2022/06/08 15:06:00 UTC
[jira] [Commented] (SOLR-16243) Compile SQL to a Streaming Expression while visiting the Calcite SQL parse tree
[ https://issues.apache.org/jira/browse/SOLR-16243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551659#comment-17551659 ]
Kevin Risden commented on SOLR-16243:
-------------------------------------
[~jbernste] is this actually the best approach? Is it possible to instead fit this in with Calcite rules? I'd be surprised if we need to go this level to solve this problem?
Shouldn't it be possible to hook this in as a LogicalJoin replacement? Since a join should be possible to alter the relational algebra? https://www.slideshare.net/JordanHalterman/introduction-to-apache-calcite slide 66
> Compile SQL to a Streaming Expression while visiting the Calcite SQL parse tree
> -------------------------------------------------------------------------------
>
> Key: SOLR-16243
> URL: https://issues.apache.org/jira/browse/SOLR-16243
> Project: Solr
> Issue Type: Improvement
> Security Level: Public(Default Security Level. Issues are Public)
> Components: Parallel SQL
> Reporter: Joel Bernstein
> Priority: Major
> Labels: RobustSQL
>
> Currently Solr SQL visits the SQL parse tree and builds up a set of properties that are passed to the SolrTable which creates the Streaming Expression object tree. This technique only works because we're not dealing yet with Joins. It won't be practical to express joins using the current approach. In order to support joins we'll need to build the Streaming Expression as we visit the parse tree and pass the expression directly to the SolrTable.
> This ticket will only implement existing SQL support using the direct compilation approach.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org