[SOLR-16243] Compile SQL to a Streaming Expression while visiting the Calcite SQL parse tree

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Parallel SQL
• Labels: RobustSQL
• Assignee: Joel Bernstein
• Reporter: Joel Bernstein
• Created: 08/Jun/22 03:53
• Updated: 20/Feb/24 00:00

Description

We're going to have to up our SQL interpretation game in order to support more complex query plans that include joins.

This ticket adds an approach that translates the Calcite parse tree into a tree of "Implementor" nodes. The Implementor.getPhysicalPlan() method can then be called to traverse the Implementor tree and return a Streaming Expression which is the executable physical plan.

The approach allows for implementor nodes of different types to handle Join logic. An example JoinImplementor is included in the PR which holds a left and right Implementor and returns an InnerJoinStream from the getPhysicalPlan method.

Issue Links

• is required by: SOLR-16239 Add Join query plans to Solr SQL
• links to: GitHub Pull Request #899