Trino nation, We want to hear from you! If you have a question or pull request that you would like us to feature on the show please join the Trino slack, and go to the #trino-community-broadcast channel and let us know there. Otherwise, you can message Manfred Moser or Brian Olsen directly. Also, feel free to reach out to us on our Twitter channels Brian @bitsondatadev and Manfred @simpligility.
If you want to show us some 💕, please give us a ⭐ on GitHub.
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.