Roadmap

Language features

• Complete VARCHAR(x) support (https://github.com/prestodb/presto/issues/4813)
  • Hive connector: https://github.com/prestodb/presto/pull/4781
  • TPCH connector: https://github.com/prestodb/presto/pull/5012
  • Redis and Kafka connectors: https://github.com/prestodb/presto/pull/5105
  • JDBC connectors: https://github.com/prestodb/presto/pull/5119
  • 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:
    • https://github.com/prestodb/presto/pull/5089
  • ORC predicate pushdown: https://github.com/prestodb/presto/pull/5001
  • TPCH connector: https://github.com/prestodb/presto/pull/4969
  • Coercions
    • https://github.com/prestodb/presto/pull/5240
    • https://github.com/prestodb/presto/pull/5241
  • Functions: https://github.com/prestodb/presto/pull/5378
• TINYINT/SMALLINT (https://github.com/prestodb/presto/pull/4910)
• INTEGER (https://github.com/prestodb/presto/pull/4711)
• FLOAT (https://github.com/prestodb/presto/issues/4942)
  • First part: https://github.com/prestodb/presto/pull/5388
  • Coercions: https://github.com/prestodb/presto/pull/5492
• CHAR https://github.com/prestodb/presto/pull/5799
• Correlated subqueries (https://github.com/prestodb/presto/issues/4017)
• EXISTS (https://github.com/prestodb/presto/pull/5369)
• Non-equality OUTER joins (https://github.com/prestodb/presto/pull/5088)
• Prepared statements (https://github.com/prestodb/presto/issues/4338)
  • PREPARE syntax (https://github.com/prestodb/presto/pull/4412)
• Complete GRANT/REVOKE
• SHOW CREATE TABLE (https://github.com/prestodb/presto/issues/4616)
• SHOW CREATE VIEW (https://github.com/prestodb/presto/pull/3140)
• INTERSECT (https://github.com/prestodb/presto/issues/4918)
• EXCEPT (https://github.com/prestodb/presto/issues/4908)
• Lambda expressions (https://github.com/prestodb/presto/pull/6198)
• Complete ROW type support
  • ROW literals (https://github.com/prestodb/presto/pull/5044)
  • ROW cast (https://github.com/prestodb/presto/pull/5043)
  • ROW types in IN expressions (https://github.com/prestodb/presto/pull/5323)
• 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)
• Schema creation, deletion, rename (https://github.com/prestodb/presto/issues/5817)

Planner/optimizer

• Optimizer v2 (https://github.com/prestodb/presto/wiki/New-Optimizer)
• Intra-node parallelism (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
• https://github.com/prestodb/presto/pull/4699
• https://github.com/prestodb/presto/pull/5002
• Structured types performance

Instrumentation

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

Hive connector

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

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

• MongoDB (https://github.com/prestodb/presto/pull/3337)
• Persistent history in JMX connector (https://github.com/prestodb/presto/pull/4440)
• Accumulo (https://github.com/prestodb/presto/pull/5030)
• Cassandra 3.0 support (https://github.com/prestodb/presto/issues/4364)
• TPC-DS connector issue; pending PR
  • As a prerequisite we're going to implement the TPC-DS data generator in Java. DONE -> Teradata/tpcds
• HBase 1.x support (https://github.com/prestodb/presto/issues/6010)