...
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 |
|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|