tristaZero opened a new issue #8284: URL: https://github.com/apache/shardingsphere/issues/8284
Hi community, As you know, ShardingSphere has made a lot of efforts on SQL parser and provided a great independent SQL parser to help users parse SQL. Based on this substantial work, we plan to do query optimization to optimize the input SQLs from users and produce an optimized SQL query plan to improve query efficiency. Plus, the federated SQL query feature (Like join query from different instances) is another essential highlight for our next release. : ) We will leverage [Apache Calcite](https://calcite.apache.org), an excellent framework to implement two of the features. Currently, three main work focus are presented here. - [ ] The investigation of RBO (Rule-Based Optimization) and CBO (Cost-Based optimization) ,i.e., Hep planner engine and Volcano planner engine. (Mechanism, usage, pros and cons). - [ ] The investigation of Calcite adaptor, especially `TranslatableTable` API. - [ ] How to transform the parsed result of ShardingSphere to the algebra of Calcite - [ ] Call some of the optimization rules to process the relational expression - [ ] Implement Calcite adaptor to join SQLs from different instances - [ ] Combine sharding tables with Calcite adaptors. Actually, there are plenty of works to do on this issue. We are in the investigation phase now and will seek contributors for this issue later. If you are interested in this one, please give it a watch. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
