[IGNITE-15436] Calcite engine. Merge Calcite SQL Engine to Ignite 2.x

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.13
• Labels: important ise
• Release Note: Added new experimental, Apache Calcite based SQL engine
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 03/Sep/21 07:05
• Updated: 01/Apr/22 19:02
• Resolved: 24/Mar/22 14:43

Description

When the Calcite-based SQL engine will reach a certain level of maturity to be released we should merge sql-calcite branch to the master branch of the Ignite 2.x repository, to release the Calcite-based SQL engine (in beta status) with the next Apache Ignite release.

Issue Links

• is blocked by: IGNITE-16277 Query failed with assertion
• is blocked by: IGNITE-16077 Calcite engine. Index on DATE/TIME/TIMESTAMP fields cannot be used
• is blocked by: IGNITE-16354 Calcite engine. Memory leak in RelOptCluster during mapping
• is blocked by: IGNITE-16397 Calcite engine. Failed to insert to table with two or more columns in primary keys
• is blocked by: IGNITE-16443 Calcite engine. Incorrect nulls in search row processing by hash/sorted spools
• is blocked by: IGNITE-16693 Calcite engine. Merge join incorrectly works with null values
• is blocked by: IGNITE-16701 Calcite engine. Merge join incorrectly works when there are more then two matched rows on the right side
• is blocked by: IGNITE-12695 Calcite integration. DML support. MERGE support
• is blocked by: IGNITE-16075 Calcite engine. Support UUID data type
• is blocked by: IGNITE-14827 Calcite engine. Support of user defined function
• is blocked by: IGNITE-15128 Calcite: Take own control of SQL functions
• is blocked by: IGNITE-15277 Calcite engine. System views support
• is blocked by: IGNITE-15422 Calcite engine. Add CREATE/ALTER/DROP USER commands support
• is blocked by: IGNITE-15423 Calcite engine. Add KILL ... commands support
• is blocked by: IGNITE-16111 Calcite engine. Fallback to table scan if index is absent on some nodes
• is blocked by: IGNITE-16113 Calcite engine. Support BINARY/VARBINARY data types
• is blocked by: IGNITE-16151 Introduce timeout for calcite planner
• is blocked by: IGNITE-16315 Calcite engine. Query start request contains a lot of data
• is blocked by: IGNITE-16317 Calcite engine. Add KILL QUERY command support
• is blocked by: IGNITE-16460 Calcite. Fix Calcite TC test suite.
• is blocked by: IGNITE-14195 SQL Calcite: ease of use of new Calcite engine
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• is related to: IGNITE-16631 ODBC: Add ability to set default query, calcite or H2, engine on DSN configuration or connection string
• links to: GitHub Pull Request #9855