[IGNITE-16398] Sort out and merge Calcite tickets to Ignite 3.0 (step 3)

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Evgeny Stanilovsky
• Reporter: Iurii Gerzhedovich
• Created: 26/Jan/22 11:54
• Updated: 15/Feb/22 13:29
• Resolved: 09/Feb/22 08:26

Description

Let's sort out tikets contains by filter.
Tickets that could be simply merged - merge immediately. For hard cases let's create separate tickets with estimation and link them to IGNITE-15658 or links to blocker ticket.

Issue Links

• incorporates: IGNITE-16442 Upgrade to Apache Calcite 1.29.0
• incorporates: IGNITE-16482 Sql. Adopt: Project and filters are not merged into scan node correctly. IgniteProject need to be initialized with single distribution.
• incorporates: IGNITE-16486 Sql. Adopt: Fix traits at the IgniteLimit. NPE on subquery returning multiple results. Correlates passes through table spools.
• incorporates: IGNITE-16547 Sql. Adopt MERGE command.
• is a child of: IGNITE-15658 Merge resolve Calcite tickets to 3.0