Trino (formerly PrestoSQL) is a distributed SQL query engine that allows running long-running ETL and batch queries on Amazon EMR Spot Instances with resilience against interruptions by retrying failed tasks on remaining workers, enabling cost savings while maintaining query performance.

<div>
<p>This article discusses how to use Trino, an open-source SQL query engine, in Amazon EMR to run resilient and cost-effective big data queries using Amazon EC2 Spot Instances.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Overview of Trino architecture and its parallel execution model</li>
<li>Benefits of using EC2 Spot Instances for cost savings and faster query performance with Trino</li>
<li>Fault-tolerant configuration of Trino in Amazon EMR to mitigate task failures due to Spot interruptions</li>
<li>Step-by-step guide to create an EMR cluster with Trino, configure fault tolerance, and simulate Spot interruptions using AWS Fault Injection Simulator</li>
<li>Demonstration of Trino's resilience against Spot interruptions and faster query performance by adding more Spot workers</li>
<li>Conclusion highlighting the benefits of running resilient and cost-effective big data queries on Trino with Spot Instances</li>
</ul>
</div>


Query big data with resilience using Trino in Amazon EMR with Amazon EC2 Spot Instances for less cost

Related articles