...
At the moment, it seems that it is advisable to split all the work on the new SQL engine into 3 parts.
Please consider Task not a JIRA task but just a kind of work which could be mapped to many JIRA tickets.
Phase 1: Simple SQL are work
Task | Contributors | Readiness Estimated Time | Current state |
---|
Support of Indexes | |
| |
initial support of DML | |
| |
Expressions interpreter (minimum realization for support aggregate function) | |
| |
Aggregate functions (sum, min, max, avg, ...), enables GROUP BY/DISTINCT commands | |
| |
UNION/UNION ALL/ |
INTERSECT/MINUS commands | |
| |
INTERSECT |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
support of IN/EXEPT |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
MERGE |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
|
|
|
|
Phase 2: Base performance optimization and extend SQL possibilities
Task | Contributors | Readiness Estimated Time | Current state |
---|
Index Nested Loop Join/Hash Join | |
| Status |
---|
subtle | true |
---|
colour | Yellow |
---|
title | IN PROGRESS |
---|
|
|
Schema management | ? |
| Status |
---|
subtle | true |
---|
colour | Yellow |
---|
title | IN PROGRESS |
---|
|
|
support of DDL |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Type system (just review, seems it may be used as is + write many tests) |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Phase 3: Usability and performance
Task | Contributors | Readiness Estimated Time | Current state |
---|
Expressions interpreter extended |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Statistics/cost model (simple statistics) |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Views |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Tracing, statistics, cancellation, views |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Memory managment and offloading |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Expressions interpreter (kind of optimisation, may be omitted at the first step here a type system is used) |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Correlated queries support (may be omitted at the first step) |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Planner hints |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
H2 syntax support |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
VolcanoPlanner overhaul |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Distributed joins/aggregation/subqueries algorithms |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Join/aggregation algorithms |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Partition prunning |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Explain/ExplainAnalyze |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
Query compilation |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
JDBC/ODBC/Thin, other clients (including partition awareness) |
|
| Status |
---|
subtle | true |
---|
title | OPEN TO TAKE |
---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|