[IGNITE-21579] Sql. Investigate performance bottlenecks in sql engine

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Done
• Component/s: sql
• Labels: ignite-3
• Assignee: Konstantin Orlov
• Reporter: Konstantin Orlov
• Created: 21/Feb/24 09:58
• Updated: 19/Mar/24 12:45
• Resolved: 19/Mar/24 12:45

Description

Currently, queries from the TPC H set are barely within one second on a 3-node cluster with scaleFactor=0.01 (and q2 even hangs).

Let's investigate bottlenecks in sql engine and file corresponding ticked to address these bottlenecks.

For this iteration, let's formulate Definition of Done as "all queries make it within one second on dataset with scaleFactor =0.1"

Issue Links

• is blocked by: IGNITE-21331 Sql. TPC-H q2 query hangs with sc=0.01
• is blocked by: IGNITE-21668 Sql. Deadlock in sorted exchange
• is blocked by: IGNITE-21722 Sql. NPE in correlated nested loop join
• is related to: IGNITE-21580 Sql. Unable to optimise query using only two phase aggregates
• is related to: IGNITE-16493 Calcite engine. Decorrelation after subquery rewrite
• is related to: IGNITE-21809 Sql. Improve intra-query parallelism
• is related to: IGNITE-21720 Sql. Implement hash join
• is related to: IGNITE-21721 Sql. Adjust cost estimation for index scan