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

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: Parallel SQL
Labels:
- RobustSQL
- pull-request-available

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.