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

Trino blog

News from the community of users and contributors

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.

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

Improved Hive Bucketing

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

Optimizing the Casts Away

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

Presto Summit 2019 @TwitterSF

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

Release 311

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

Presto Community Meeting 2019-05-08

08 May 2019 |

Agenda Existing function support Function namespaces Connector-resolved functions SQL-defined functions Remote functions Polymorphic table functions

Faster S3 Reads

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.

Release 310

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

Page 12 of 14

Want more? Visit the archives or subscribe via RSS.