Trino Features

Separation of Storage and Compute

With data volumes and types of data increasing on a daily basis, placing this data on a flexible storage medium such as HDFS or a cloud object storage such as Amazon’s S3, S3-compatible stores (Minio, ceph), and Azure’s Blob Storage provides a company with great flexibility on when and where they consume this data. Architected for separation of storage and compute, Trino can scale up and down based on your analytics demand to access this data.

Interactive Analytics

From the beginning Trino, formerly PrestoSQL, was designed with SQL query performance in mind. It leverages both well-known and novel techniques for distributed query processing. Some include In-memory parallel processing, Pipelined execution across nodes in the cluster, Multithreaded execution model to keep all the CPU cores busy, Efficient flat-memory data structures to minimize Java garbage collection, and Java Byte code generation. This translates to faster insights into your data at a fraction of the cost of other solutions.

>>Cost-based Query Optimization White Paper

Analyze Anything

Allow your business intelligence users and data scientists to use their favorite tools (Tableau, Qlik, Apache Superset) to access and analyze virtually any data source via Trino. Analyze data from HDFS, object stores, RDBMS (SQL Server, Oracle, MySQL, PostgreSQL), Kafka, MongoDB, and many others. Trino’s flexible architecture allows one perform analytics federated across multiple data sources at the same time. Easily combine historical data from HDFS or objects stores with most recent incoming data from Kafka in the same query.

Secure Everything

Have peace of mind that your data is safe and secure. Starburst Enterprise will fully integrate with your Kerberos and LDAP environments. Further control authorized access to pieces of your data by leveraging AWS & Azure Access management, Hive Metastore Authorization, Apache Sentry Integration, and Apache Ranger integration. For complete security, Starburst Enterprise will support data encryption at-rest and in-transit.

>>Starburst Global Security Webcast

Deploy Anywhere

The separation of storage and compute allows Trino flexible deployment options. Deploy on public clouds such as AWS and Azure, private clouds such as OpenStack, on premises on bare metal commodity hardware or in a virtualized environment. ware on premises. Or let us deploy and manage with our fully managed Trino offering.