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)