Trino is a massively parallel processing query engine that provides a quick and easy way to access datasets from a variety of sources using industry standard ANSI SQL.
Trino is best-known for handling ad-hoc data analytics workloads, and it shines when reading and federating data in a data warehouse or data lake. It also has a mode for fault tolerance which trades off some speed for reliability, making it effective at handling batch ETL/ELT workloads and insertions.
It is important to stress that though Trino understands SQL, it does not provide the features of a standard database. Trino is not a general-purpose relational database and does not store data, and you will need to use Trino’s connectors to query your database, data warehouse, or data lakehouse.
Trino website: https://trino.io/
Learn more about Trino: https://www.starburst.io/learn/trino/
Learn SQL with Trino: https://www.starburst.io/info/trino-training-series/
Check out Starburst Galaxy: https://www.starburst.io/platform/starburst-galaxy/start/?utm_medium=trino&utm_source=website&utm_campaign=Global-FY22-Q4-DM-Trial-Galaxy2-0&utm_content=YT-what-is-trino
Timestamps:
-
0:00 Intro
-
0:30 SQL query engine
-
1:29 Federated queries
-
2:25 Querying data lakes
-
2:56 Open source
-
3:24 Starburst Galaxy
#trino #apachetrino #starburst #sql #sqldatabasemanagement #datalake #datalakehouse #icehouse #dataicehouse #apacheiceberg #datafederation #starburstgalaxy #opensource