5 advantages of using apache trino as a query engine?

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.

[{"selector":"#anim-ac48b006-2637-465c-8e76-2b949fceebdf [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.514648210040342%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.14,.34,.47,.9)","fill":"forwards"}]

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

[{"selector":"#anim-e8a89b4c-bb41-4439-b201-490bb49139bc [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.514648210040342%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.14,.34,.47,.9)","fill":"forwards"}]

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

[{"selector":"#anim-abdc1f66-84cd-41b1-9b29-705e3cf08ead [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.514648210040342%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.14,.34,.47,.9)","fill":"forwards"}]

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

[{"selector":"#anim-9106d1ed-dbcc-45dc-948e-04fc5adf2c1d [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.514648210040342%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.14,.34,.47,.9)","fill":"forwards"}]

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

[{"selector":"#anim-37348922-5e06-40d1-8f65-5d5d1038eb80 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.514648210040342%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.14,.34,.47,.9)","fill":"forwards"}]

Click to learn more

[{"selector":"#anim-ff19fb80-4c63-40ba-9fed-14740909fe5f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.514648210040342%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.14,.34,.47,.9)","fill":"forwards"}]

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.

Fast

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.

Scalable

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

Multiple connectors

Click to learn more