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

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

• Join/Group-by performance
• Optimize coordinator<->worker protocols (https://github.com/prestodb/presto/pull/4941)
• HTTP/2
• Rewrite intra-task exchange & output buffers
  • [DONE] https://github.com/prestodb/presto/pull/4699
  • 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

Other connectors

• [DONE] MongoDB (https://github.com/prestodb/presto/pull/3337)
• [DONE] Persistent history in JMX connector (https://github.com/prestodb/presto/pull/4440)
• Accumulo (https://github.com/prestodb/presto/pull/5030)
• [DONE] Cassandra 3.0 support (https://github.com/prestodb/presto/issues/4364)
• TPC-DS connector (https://github.com/prestodb/presto/issues/5131)
  • As a prerequisite we're going to implement the TPC-DS data generator in Java