[IGNITE-8284] Performance SQL with distinct in subquery

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4
• Component/s: sql
• Assignee: Unassigned
• Reporter: Pavel Vinokurov
• Created: 16/Apr/18 16:37
• Updated: 01/Nov/18 10:56

Description

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.

Issue Links

• is related to: IGNITE-10110 SQL query with DISTINCT and JOIN in suquery produces "Column not found"