Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-4523

Allow distributed SQL query execution over explicit set of partitions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.8
    • 2.0
    • cache, sql

    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.

      Attachments

        Issue Links

          Is contained by

          Task - A task that needs to be done. IGNITE-4509 SQL: query with condition on affinity columns and without joins and subqueries should go to affinity node only

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-4510 SQL: co-located query may calculate target partition in advance in some cases

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Task - A task that needs to be done. IGNITE-4517 Add ability to execute SQL queries on certain partition(s)

          • Major - Major loss of function.
          • Resolved
          relates to

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-4378 Affinity function should support assigning partition to subset of cluster nodes

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-4875 Allow execution over explicit set of partitions for every non-SQL query type with data integrity guarantees.

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. IGNITE-4517 Add ability to execute SQL queries on certain partition(s)

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #1508

          Web Link GitHub Pull Request #1858

          Activity

            People

              ascherbakov Alexey Scherbakov
              ascherbakov Alexey Scherbakov
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: