[IGNITE-6883] Distributed sub-query support

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Component/s: sql
• Assignee: Unassigned
• Reporter: Alin Andrei Corodescu
• Created: 13/Nov/17 10:15
• Updated: 14/Feb/19 08:49
• Resolved: 14/Feb/19 08:49

Description

Include behaviour similar to the distributedJoins flag for inner queries as well (gather data from multiple nodes).
At the moment sub queries are run on remote nodes without being split into map and reduce parts and without taking into account data residing in other nodes (sometimes collocation is not possible).
One use case when results are affected by this behaviour is when the subquery contains a

HAVING

clause, since the conditions can filter out groups for which not all the entries are on the same node.