📊Trino
Also known as PrestoSQL, Trino SQL
A free tool that runs SQL on many data sources at once.
Think of it like
It is like a team of runners who share one big errand. Each fetches a part, and one of them puts it all together.
Example
A firm points Trino at its data lake and its customer list. One query then joins web clicks to customers.
Why it matters
It is one of the most used engines for querying a data lake with SQL. Many hosted services are built on it.
Definition
Example code
bash
trino --server http://localhost:8080 --catalog hive --schema webCommon mistake
Key takeaways
- 1Coordinator and workers. One plans, many do the work.
- 2Connectors. Lakes, databases, streams.
- 3Fork of Presto. By Presto's original creators.