Apache trino is an open source, distributed query engine which has many advantages few of them are:-

Trino is pretty fast compared to other distributed query engines like hive because of its Cost-Based Optimiser.


Trino supports online analytical processing (OLAP) and is suitable for transactions.

OLAP support

Trino uses ANSI SQL, which helps a developer to get started with trino in a few days.

ANSI SQL support

Trino supports scalability. In trino, a user can scale computing and storage independently.


Trino has multiple connectors , and users can use trino to connect to the hive, RDBMS, JDBC, etc.

Multiple connectors