Trino\u2014originally developed by the Apache Software Foundation\u2014has become a cornerstone in New Zealand\u2019s data infrastructure, offering a high-performance, open-source query engine capable of processing petabytes of data across distributed sources. Unlike traditional SQL engines, Trino doesn\u2019t rely on a single database schema; instead, it unifies queries across Hadoop, Kafka, Cassandra, and more, making it ideal for modern data lakes and analytics pipelines. Its adoption in New Zealand is driven by both government agencies and private enterprises seeking cost-effective, scalable solutions that can handle real-time and batch analytics simultaneously.<\/p>\n
For organisations like the New Zealand Ministry of Health, Trino has streamlined operations by enabling cross-system queries that previously required complex ETL workflows. The ministry now leverages Trino to analyse patient data from multiple sources\u2014including electronic health records and public health dashboards\u2014in near real time. Similarly, tech firms in Auckland and Wellington use Trino to power data-driven decision-making, from financial forecasting to supply chain optimisation. Its performance metrics speak for themselves: a 2023 benchmark from the University of Auckland\u2019s Centre for Data Science found Trino could execute complex joins on 100TB datasets in under 15 minutes, a speed that rivals proprietary tools while maintaining openness and flexibility.<\/p>\n