[IGNITE-4523] Allow distributed SQL query execution over explicit set of partitions

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8
• Fix Version/s: 2.0
• Component/s: cache, sql
• Labels: important
• Assignee: Alexey Scherbakov
• Reporter: Alexey Scherbakov
• Created: 04/Jan/17 16:27
• Updated: 26/Apr/17 13:26
• Resolved: 25/Apr/17 11:02

Description

3Currently distributed SQL query is executed on all nodes containing primary partitions for a cache, sending map query requests on all nodes in grid.

Sometimes we know in advance which partitions hold a data for query, on example, in case of custom affinity function.

Therefore it's possible to reduce number of nodes receiving map query request by providing explicit set of partitions, which will give significant performance advantage and traffic reduction in case of very large clusters.

Internally we already have such functionality, so the only necessary thing is to provide public API for what.

Issue Links

• Is contained by: IGNITE-4509 SQL: query with condition on affinity columns and without joins and subqueries should go to affinity node only
• Is contained by: IGNITE-4510 SQL: co-located query may calculate target partition in advance in some cases
• is duplicated by: IGNITE-4517 Add ability to execute SQL queries on certain partition(s)
• relates to: IGNITE-4378 Affinity function should support assigning partition to subset of cluster nodes
• relates to: IGNITE-4875 Allow execution over explicit set of partitions for every non-SQL query type with data integrity guarantees.
• relates to: IGNITE-4517 Add ability to execute SQL queries on certain partition(s)
• links to: GitHub Pull Request #1508
• links to: GitHub Pull Request #1858