[IGNITE-17952] Sql. Make SQL distributed again

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: ignite-3
• Assignee: Konstantin Orlov
• Reporter: Konstantin Orlov
• Created: 21/Oct/22 14:06
• Updated: 28/Feb/23 10:58
• Resolved: 28/Feb/23 10:58

Description

As a first step in integrating RW transactions, we were forced to abandon the execution of distributed queries.

After IGNITE-17950 and IGNITE-17951 will be implemented, we need to switch back to a distributed execution. For this let's remove LOCAL_TRAITS_SET, and start to pass proper txId when performing a scan over local partition.

Do not forget:

• Fix all TODO marked IGNITE-17952.
• Fix StopCalciteModuleTest (patch attached).

Issue Links

• blocks: IGNITE-18225 Sql. Pushdown MODIFY to data node
• is blocked by: IGNITE-18632 Barrier for locks after cleanup started
• is blocked by: IGNITE-17950 Sql. Investigate way of reworking query cancellation flow
• is blocked by: IGNITE-17951 Sql. Enlist partitions to rw transaction
• links to: GitHub Pull Request #1700
• links to: PR