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-t...
Check out Starburst Galaxy: https://www.starburst.io/platform/sta...
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