You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Konstantin Orlov (Jira)" <ji...@apache.org> on 2022/11/18 15:37:00 UTC

[jira] [Created] (IGNITE-18202) Pushdown relational operators

Konstantin Orlov created IGNITE-18202:
-----------------------------------------

             Summary: Pushdown relational operators
                 Key: IGNITE-18202
                 URL: https://issues.apache.org/jira/browse/IGNITE-18202
             Project: Ignite
          Issue Type: Epic
          Components: sql
            Reporter: Konstantin Orlov


h3. Rational
In a distributed environment, network latency and network bandwidth are important performance factors. To minimize the influence of the network to a query execution, we could move certain fragments of query processing as close to the data as possible. Such a class of optimization is known as operator's pushdown. Pushdowns can drastically reduce query processing time by filtering data before transferring it over the network, or pre-aggregating it. Besides, this is a natural way to parallelise the query processing.

h3. Operators to pushdown
Below is a list of relational operators that should be pushed down and executed on data nodes. Requirements as well as details on how and when every particular operator should be pushed down will be described later in according tickets attached to this epic.
* Aggregate
* Join
* Limit
* Predicate
* Projection
* Sort
* Except and Intersect
* Modify




--
This message was sent by Atlassian Jira
(v8.20.10#820010)