Do you ❤️ Trino? Give us a 🌟 on GitHub

Trino blog

News from the community of users and contributors

Presto Experiment with Graviton Processor

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

First Presto Summit in India, Bangalore, September 2019

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

Unnest Operator Performance Enhancement with Dictionary Blocks

23 Aug 2019 | Pratham Desai, LinkedIn

Queries with CROSS JOIN UNNEST clause are expected to have a significant performance improvement starting version 316.

A Report of First Ever Presto Conference Tokyo

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

Introduction to Trino Cost-Based Optimizer

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)!...

Dynamic filtering for highly-selective join optimization

30 Jun 2019 | Roman Zeyde

By using dynamic filtering via run-time predicate pushdown, we can significantly optimize highly-selective inner-joins.

Release 315

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

Release 314

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

Apache Phoenix Connector

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

Removing redundant ORDER BY

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,...

Release 313

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

Using Precomputed Hash in SemiJoin Operations

30 May 2019 | Shubham Tagra, Qubole

Queries involving IN and NOT IN over a subquery are much faster in Presto 312.

Page 12 of 14



Want more? Visit the archives or subscribe via RSS.