Great article Jordan. It really displays some of the advanced SQL/functions in Trino. One thing I would like to point out is that PrestoSQL has been rebranded to Trino. Would you consider updating the title and article as such? Any PrestoSQL version 300 to 350 are just older versions of Trino with the old branding.

Let me know if you have any other Trino blogs you'd like to write and we can see about cross posting them on the Trino blog. I'm on Trino Slack, as well as, Twitter.

Originally Posted on

TL;DR: The Hive connector is what you use in Presto for reading data from object storage that is organized according to the rules laid out by Hive, without using the Hive runtime code.

One of the most confusing aspects when starting Presto is the Hive connector. Typically, you seek out the use of Presto when you experience an intensely slow query turnaround from your existing Hadoop, Spark, or Hive infrastructure. In fact, the genesis of Presto came about due to these slow Hive query conditions at Facebook back in 2012.

So when you learn that Presto…

This blog was originally posted on my website.
There’s something I have to get off my chest. If you really need to, just read the TLDR and listen to the Justin Bieber parody posted below. If you’re confused by the lingo, the rest of the post will fill in any gaps.

TL;DR: Benchmarketing, the practice of using benchmarks for marketing, is bad. Consumers should run their own benchmarks and ideally open-source them instead of relying on an internal and biased report.

Enjoy the song I wrote about this silly practice.

For the longest time, I have wondered what is…

Brian Olsen

U.S. Marine turned software engineer and developer 🥑 working to foster the open source Trino community.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store