News from the community of users and contributors
23 Dec 2019 | Kai Sasaki, Arm Treasure Data
This December, AWS announced new instance types powered by Arm-based AWS Graviton2 Processor. M6g, C6g, and R6g are designed to deliver up to 40% improved price/performance compared with the current...
05 Sep 2019 | Vijay Mann, Director of Engineering, Qubole
Qubole organized the first ever Presto Summit in India on September 05, 2019. Bangalore, as the technology and startup hub of India was the perfect venue for India’s first Presto...
23 Aug 2019 | Pratham Desai, LinkedIn
Queries with CROSS JOIN UNNEST clause are expected to have a significant performance improvement starting version 316.
11 Jul 2019 | Kai Sasaki, Arm Treasure Data
Nowadays, Presto is getting much attraction from the various kind of companies all around the world. Japan is not an exception. Many companies are using Presto as their primary data...
04 Jul 2019 | Piotr Findeisen, Starburst Data
Last edited 15 June 2022: Update to use the Trino project name. The Cost-Based Optimizer (CBO) in Trino achieves stunning results in industry standard benchmarks (and not only in benchmarks)!...
30 Jun 2019 | Roman Zeyde
By using dynamic filtering via run-time predicate pushdown, we can significantly optimize highly-selective inner-joins.
15 Jun 2019 |
This version adds support for FETCH FIRST ... WITH TIES syntax, locality-awareness to default scheduler for better workload balancing, the new format() function, and improved support for ORC bloom filters....
08 Jun 2019 |
This version adds support for reading ZSTD and LZ4-compressed Parquet data and writing ZSTD-compressed ORC data, improves compatibility with the Hive 2.3+ metastore, supports mixed-case field names in Elasticsearch, adds...
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.