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

SQL: query with condition on affinity columns and without joins and subqueries should go to affinity node only

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.8
    • 2.1
    • sql

    Description

      Simple SQL queries usually demonstrate negative scalability when more nodes are added.

      Consider the following query:

      SELECT * FROM Person p
WHERE p.id = ?

      If Person.id is affinity field, then query can be replaced with plain IgniteCache.get or some specialized version of GET, which will return only desired fields. This optimization will guarantee smooth scale with any number of nodes.

      Attachments

        Issue Links

          blocks

          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
          breaks

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-5437 SQL: Incorrect partition is derived from query when argument type differs from column type

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-5818 SQL: query with condition on affinity column works incorrect in some cases.

          • Major - Major loss of function.
          • Resolved
          contains

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-4523 Allow distributed SQL query execution over explicit set of partitions

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

          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 #1916

          Web Link review link

          Activity

            People

              skalashnikov Sergey Kalashnikov
              vozerov Vladimir Ozerov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: