News from the community of users and contributors
04 Jun 2019 | Vincent Poon
Presto 312 introduces a new Apache Phoenix Connector, which allows Presto to query data stored in HBase using Apache Phoenix. This unlocks new capabilities that previously weren’t possible with Phoenix...
03 Jun 2019 | Martin Traverso
Optimizers are all about doing work in the most cost-effective manner and avoiding unnecessary work. Some SQL constructs such as ORDER BY do not affect query results in many situations,...
01 Jun 2019 |
This version fixes incorrect results for queries involving GROUPING SETS and LIMIT, fixes selecting the UUID type from the CLI and JDBC driver, and adds support for compression and encryption...
30 May 2019 | Shubham Tagra, Qubole
Queries involving IN and NOT IN over a subquery are much faster in Presto 312.
29 May 2019 |
This version has many performance improvements (including cast optimization), a new UUID data type and uuid() function, a new Apache Phoenix connector, support for the PostgreSQL TIMESTAMP WITH TIME ZONE...
29 May 2019 | David Phillips
Presto 312 adds support for the more flexible bucketing introduced in recent versions of Hive. Specifically, it allows any number of files per bucket, including zero. This allows inserting data...
21 May 2019 | Martin Traverso
The next release of Presto (version 312) will include a new optimization to remove unnecessary casts which might have been added implicitly by the query planner or explicitly by users...
17 May 2019 | Kamil Bajda-Pawlikowski
Next month will mark the 2nd annual Presto Summit hosted by the Presto Software Foundation, Starburst Data, and Twitter. Last year’s event was a great success (see the Presto Summit...
15 May 2019 |
This version adds standard OFFSET syntax, a new function combinations() for computing k-combinations of array elements, and support for nested collections in Cassandra. Release notes Download
08 May 2019 |
Agenda Existing function support Function namespaces Connector-resolved functions SQL-defined functions Remote functions Polymorphic table functions
06 May 2019 | David Phillips
Presto is known for working well with Amazon S3. We recently made an improvement that greatly reduces network utilization and latency when reading ORC or Parquet data.
03 May 2019 |
This version adds standard FETCH FIRST syntax, support for using an alternate AWS role when accessing S3 or Glue, and improved handling of DECIMAL, DOUBLE, and REAL when Hive table...