SHOW STATSsupport for arbitrary queries.
ORDER BY ... LIMITqueries on sorted data.
More info at https://trino.io/docs/current/release/release-358.html.
Here are Cory’s slides that you can use to follow along while listening to the podcast.
The PR of the week, is a simple but always useful PR done by maintainer Yuya Ebihara. This fixes issue 1878 that makes a nice format for very large numbers that get returned from the query to be truncated with a value suffix like (B - billion, M - million, K - thousand, etc…). Rather than reuse the CLI’s FormatUtils class, which missed various cases, he created his own implementation that solves for those issues. Thanks Yuya!
Here are the examples we ran in the show.
SELECT format_number(DOUBLE '1234.5'); SELECT format_number(DOUBLE '-9223372036854775808'); SELECT format_number(DOUBLE '9223372036854775807'); SELECT format_number(REAL '-999'); SELECT format_number(REAL '999'); SELECT format_number(DECIMAL '-1000'); SELECT format_number(DECIMAL '1000'); SELECT format_number(999999999); SELECT format_number(1000000000);
A question posted to StackOverflow asked how to search nested objects using the Elasticsearch connector.
Trino maps a
object type to a
the same way that it maps a standard
type during a read. The nested designation itself serves no purpose to Trino
since it only determines how the object is stored in Elasticsearch.
Check out Brian’s full answer to this question.
Trino Meetup groups
Latest training from David, Dain, and Martin(Now with timestamps!):
If you want to learn more about Trino, check out the definitive guide from OReilly. You can download the free PDF or buy the book online.
Music for the show is from the Megaman 6 Game Play album by Krzysztof Słowikowski.