Hello Igniters, I've prepared the pull request [1] and have plans to merge it to the master branch in about two weeks, if there is no objection.
[1]: https://github.com/apache/ignite/pull/9855 чт, 30 дек. 2021 г. в 13:43, Anton Vinogradov <a...@apache.org>: > > it would be great to release a new SQL engine in 2.13 as an > experimental feature. > ++1 > > On Thu, Dec 30, 2021 at 12:55 PM Alex Plehanov <plehanov.a...@gmail.com> > wrote: > > > Andrey, > > > > > Is this [1] a full scope of the tickets that MUST be resolved before > the > > engine could be merged? > > Yes, we must resolve at least these tickets before merging. If you see > any > > other release blockers fill free to attach them to this ticket. > > > > > I think we have to add instructions to the readme file on how to turn a > > new SQL engine on. > > Sure, I think it should be the part of documentation ticket. > > > > > Also, I don't like the module name "ignite-calcite", because Calcite is > > an independent project. > > Personally, I see no problems here (but it's discussable). We have a lot > of > > modules where the name is an independent project: "ignite-kafka", > > "ignite-spring", "ignite-kubernetes", "ignite-log4j", "ignite-zookeeper", > > etc. > > > > > So, would you mind renaming the module to e.g. "ignite-sql-engine" or > > "ignite-sql"? > > Module "ignite-indexing" also contains SQL engine, so names like > > "ignite-sql-engine" or "ignite-sql" will be ambiguous. > > > > чт, 30 дек. 2021 г. в 13:54, Andrey Mashenkov < > andrey.mashen...@gmail.com > > >: > > > > > Alex, > > > it would be great to release a new SQL engine in 2.13 as an > > > experimental feature. > > > > > > Is this [1] a full scope of the tickets that MUST be resolved before > the > > > engine could be merged? > > > I think we have to add instructions to the readme file on how to turn a > > new > > > SQL engine on. > > > > > > Also, I don't like the module name "ignite-calcite", because Calcite is > > an > > > independent project. > > > and Ignite just uses it. > > > So, would you mind renaming the module to e.g. "ignite-sql-engine" or > > > "ignite-sql"? > > > > > > [1] https://issues.apache.org/jira/browse/IGNITE-15436 > > > > > > On Thu, Dec 30, 2021 at 11:10 AM Zhenya Stanilovsky > > > <arzamas...@mail.ru.invalid> wrote: > > > > > > > > > > > Alex, great ! > > > > If someone wants to touch codebase somehow plz use this branch [1] > > > > Test passed can be found here [2] [3] > > > > > > > > [1] > https://github.com/apache/ignite/tree/sql-calcite/modules/calcite > > > > [2] > > > > > > > > > > https://github.com/apache/ignite/tree/sql-calcite/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite > > > > [3] > > > > > > > > > > https://github.com/apache/ignite/tree/sql-calcite/modules/calcite/src/test/sql > > > > > > > > > > > > > >> > > > > >>>Hello, Igniters! > > > > >>> > > > > >>>As you may already know there is the new Ignite SQL engine based > on > > > > Apache > > > > >>>Calcite currently under development. > > > > >>> > > > > >>>Reasons to move from H2-based engine and motivation for creating > the > > > new > > > > >>>one in details described in IEP-37 [1]. > > > > >>> > > > > >>>You can find all related to the new engine source code changes in > > the > > > > >>>"sql-calcite" branch [2]. > > > > >>> > > > > >>>Calcite-based SQL engine is not production-ready yet and has a lot > > of > > > > known > > > > >>>issues. In the future, the new engine should be fully independent > of > > > > >>>"ignite-indexing" and H2, but now it relies on schema management > and > > > > >>>indexes implemented in the "ignite-indexing" module and can't work > > > > without > > > > >>>the old engine. Despite all of the above mentioned, in the current > > > > state, > > > > >>>it has its own parsing, planning and execution flow and is almost > as > > > > >>>functional as the H2-based SQL engine. > > > > >>> > > > > >>>Some users are already interested in the Calcite-based engine and > > > asking > > > > >>>about the development status and release dates. Calcite-based SQL > > > engine > > > > >>>will be the only SQL engine in Ignite 3.0. Perhaps even in 2.x we > > can > > > > get > > > > >>>rid of the H2-based engine at some time in the future. There is > some > > > > syntax > > > > >>>difference between Calcite and H2 (Calcite is closer to SQL > > standards > > > > than > > > > >>>H2) and a totally new execution flow. After the release of this > > > feature, > > > > >>>users can try their queries and determine if any adaptation for > them > > > is > > > > >>>required. With the new planning and execution flow, perhaps, some > > > > queries > > > > >>>will be executed more effectively, users can redirect such queries > > to > > > > the > > > > >>>new engine. > > > > >>> > > > > >>>I think we can provide an opportunity to users to try the new > engine > > > and > > > > >>>release it as an experimental feature with the next Apache Ignite > > > > version > > > > >>>(2.13). > > > > >>> > > > > >>>What do you think? > > > > >> > > > > >> > > > > >> > > > > >> > > > > > > > > > > > > -- > > > Best regards, > > > Andrey V. Mashenkov > > > > > >