[
https://issues.apache.org/jira/browse/IGNITE-8284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Vinokurov updated IGNITE-8284:
------------------------------------
Affects Version/s: 2.4
> Performance SQL with distinct in subquery
> -----------------------------------------
>
> Key: IGNITE-8284
> URL: https://issues.apache.org/jira/browse/IGNITE-8284
> Project: Ignite
> Issue Type: New Feature
> Components: sql
> Affects Versions: 2.4
> Reporter: Pavel Vinokurov
> Priority: Major
>
> A query with distinct in subquery executes much slower in non-local mode than
> local mode.
> For example we have "person table" with 200000 rows.
> The following query executes at 5ms in local mode, and at 75ms at non local
> mode.
> select * from
> (select distinct p.id from "Person".Person p left join "Company".Company c on
> p.companyId=c.id
> where p.name='John' or c.name='Company2') p
> join "Department".Department d on d.id=p.id
> The peproducer project is attached.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
