Albert Wong
Aug 16, 2023

--

Trino is a federated query engine. Although Trino can connect to 100s of different systems, no matter how optimized your SQL query engine is, most of the performance gains are wiped out by slow reads from the underlying system and by the slowest system that you have in your query set. IMHO, most people who choose Trino have reasons why they have to use it (eg. Cannot upgrade or migrate the data to a faster system or don't want to pay for a single view database). There is movement now to move to an open data lake architecture with Apache Iceberg and Apache Hudi with a query engine like StarRocks to aggregate data from those open table formats.

--

--

Albert Wong
Albert Wong

Written by Albert Wong

#eCommerce #Java #Database #k8s #Automation. Hobbies: #BoardGames #Comics #Skeet #VideoGames #Pinball #Magic #YelpElite #Travel #Candy

No responses yet