Comprehensive Guide to Distributed SQL Query Engine Trino

This article was originally published on bmf-tech.com.

Comprehensive Guide to Distributed SQL Query Engine Trino was read.

• SQL Query Engine
• Supports ANSI SQL
• Federated Query
  • Reference and use databases and schemas from different systems with the same SQL
• Not a database
• Not designed to handle OLTP
  • Since it's for OLAP, the performance target is likely at the OLAP level
• As a distributed system, it can scale computing resources up and down, similar to New SQL
• Handles data sources differently from traditional big data approaches (which require costly data warehouses with various query languages, tools, operations, and maintenance costs)