Presto 0.280 released!

[Rohan Pednekar]

Hey 👋 Presto Community!

Here are the quick highlights of the features.

• • Add function find_first_index() which returns the index of the first element which satisfies the condition.

  • Add range with offset expression support to Window Functions.

  • Add a new runtime metric optimizerTimeNanos to measure the time taken by the optimizers. With this change the time taken by optimizers has been removed from runtime metric logicalPlannerTimeNanos.

  • Add support to report both client-side and server-side latency in presto-cli result summary. The client-side latency is the wall time presto-cli spends for the query to finish, and it no longer includes the time spent by the user paging through results. The server side latency represents the wall time the engine uses to finish executing this query.

  • Add ANSI SQL compliant syntax FETCH FIRST N ROWS ONLY as an alternative way to express LIMIT n. For example select * from table_name FETCH FIRST 3 ROWS ONLY is equivalent to SELECT * FROM table_name LIMIT 3, and will return only 3 rows as a result of the sql query.

Thanks to all Presto Committer and Contributors.

-> Presto 0.280 Release Notes

-> Download

-> Join Monthly Meetup 

Thank you!