Roadmap

Language features

Complete VARCHAR(x) support (https://github.com/prestodb/presto/issues/4813)
- [DONE] ~~Hive connector: https://github.com/prestodb/presto/pull/4781~~
- [DONE] ~~TPCH connector: https://github.com/prestodb/presto/pull/5012~~
- [DONE] ~~Redis and Kafka connectors: https://github.com/prestodb/presto/pull/5105~~
- [DONE] ~~JDBC connectors: https://github.com/prestodb/presto/pull/5119~~
- [DONE] ~~Raptor connector: https://github.com/prestodb/presto/pull/5189~~
- Scalar functions and operators: https://github.com/prestodb/presto/pull/5380
- [DONE] ~~Aggregate functions: https://github.com/prestodb/presto/pull/5381~~
Complete DECIMAL support
- Raptor connector:
  - [DONE] ~~https://github.com/prestodb/presto/pull/5089~~
- [DONE] ~~ORC predicate pushdown: https://github.com/prestodb/presto/pull/5001~~
- TPCH connector: https://github.com/prestodb/presto/pull/4969
- Coercions
  - [DONE] ~~https://github.com/prestodb/presto/pull/5240~~
  - [DONE] ~~https://github.com/prestodb/presto/pull/5241~~
- Functions: https://github.com/prestodb/presto/pull/5378
[DONE] ~~TINYINT/SMALLINT (https://github.com/prestodb/presto/pull/4910)~~
[DONE] ~~INTEGER (https://github.com/prestodb/presto/pull/4711)~~
FLOAT (https://github.com/prestodb/presto/issues/4942)
- [DONE] ~~First part: https://github.com/prestodb/presto/pull/5388~~
- Coercions: https://github.com/prestodb/presto/pull/5492
CHAR https://github.com/prestodb/presto/pull/5358
Correlated subqueries (https://github.com/prestodb/presto/issues/4017)
EXISTS (https://github.com/prestodb/presto/pull/5369)
[DONE] ~~Non-equality OUTER joins (https://github.com/prestodb/presto/pull/5088)~~
Prepared statements (https://github.com/prestodb/presto/issues/4338)
- [DONE] ~~PREPARE syntax (https://github.com/prestodb/presto/pull/4412)~~
[DONE] ~~Complete GRANT/REVOKE~~
[DONE] ~~SHOW CREATE TABLE (https://github.com/prestodb/presto/issues/4616)~~
[DONE] ~~SHOW CREATE VIEW (https://github.com/prestodb/presto/pull/3140)~~
[DONE] ~~INTERSECT (https://github.com/prestodb/presto/issues/4918)~~
EXCEPT (https://github.com/prestodb/presto/issues/4908)
Lambdas
Complete ROW type support
- [DONE] ~~ROW literals (https://github.com/prestodb/presto/pull/5044)~~
- [DONE] ~~ROW cast (https://github.com/prestodb/presto/pull/5043)~~
GROUPING() (https://github.com/prestodb/presto/issues/4805)
- Implementation: https://github.com/prestodb/presto/pull/5465
GeoSpatial functions support (https://github.com/prestodb/presto/pull/5435)

Planner/optimizer

Optimizer v2 (https://github.com/prestodb/presto/wiki/New-Optimizer)
[DONE] ~~Local parallel (https://github.com/prestodb/presto/pull/4699)~~
Materialized query tables (https://github.com/prestodb/presto/pull/5237)

Workload management

Queueing system v2 (https://github.com/prestodb/presto/issues/4742)
Spill to disk (https://github.com/prestodb/presto/issues/5144)

Scalability & Performance

[DONE] ~~Join/Group-by performance~~
[DONE] ~~Optimize coordinator<->worker protocols (https://github.com/prestodb/presto/pull/4941)~~
HTTP/2
[DONE] ~~Rewrite intra-task exchange & output buffers~~
- [DONE] ~~https://github.com/prestodb/presto/pull/4699~~
- [DONE] ~~https://github.com/prestodb/presto/pull/5002~~
Structured types

Instrumentation

Pluggable event listeners (https://github.com/prestodb/presto/issues/5254)

Hive connector

[DONE] ~~Kerberos support (https://github.com/prestodb/presto/pull/4867)~~
Optimized RCFile reader/writer (https://github.com/prestodb/presto/pull/2450)
Optimized ORC writer
Complete optimized Parquet reader
Nested Column Pruning for Parquet reader (https://github.com/prestodb/presto/pull/5547)
Transactional DELETE + INSERT

Jdbc connector

INSERT support (https://github.com/prestodb/presto/pull/4235)

Elasticsearch connector

Elasticsearch connector (https://github.com/elastic/elasticsearch-hadoop/issues/379)
Elasticsearch SQL support
Elasticsearch Join support
Optimized With Apache Calcite
Elasticsearch filer push down