×
×
  »  Platform  »  Compare  »  Starburst vs. Hive & Impala

Upgrade from Hive and Impala for immediate performance gains

Enhanced Trino is the modern engine for your on-premises Hadoop, offering increased concurrency, faster queries, more connectors, and efficient scalability.

Starburst customers report an average 10x increase in performance, 60% reduction in total cost of ownership, and significant reduction in ETL for ad hoc analytics.

Improve performance by 2-20x

Say goodbye to the nosy neighbor problem with an MPP SQL query engine built for faster queries, high concurrency, petabyte scale, and improved query completion.

Reduce TCO by 60-75%

Optimized price-performance to increase speed to insight without demanding vast amounts of compute resources.

Lern more about performance

Reduce ETL for ad hoc analytics

Enhanced access to 40+ data sources to reduce dependency on ETL for ad hoc analytics, data discovery, and experimentation.

Trino was built as the successor to Hive

Trino was built as the new and improved MPP SQL query engine to overcome the limitations of Hive. Enhanced Trino powers Starburst to deliver up to 10x better performance, 10x more connectivity, and lower total cost of ownership. See how Starburst stacks up against Hive and Impala.

Features Hive Impala Starburst
Connectivity HDFS, S3, ADLS HDFS, S3, ADLS HDFS, S3, ADLS,
+ 40 other enterprise sources
— Object Storage
— Operational RDBMS
— Non-Relational DBs
Data Federation
— Streaming sources
Concurrency Low Low High
Enhanced fault tolerant execution
No Dependency on Hadoop
No requirement for YARN
Ranger/Sentry Integration
Latency High Medium Low
Analytic workloads Batch processing Interactive analytics Interactive & Ad-hoc analytics

Optum showcases the power of using Starburst optimize Hadoop

10X faster queries. 30% reduction in infrastructure costs. $8 million in projected savings.

 

 

 

Read case study.

Featured resources for you

Blog Post

Transitioning from Hadoop to modern data lakehouse

With the integration of Starburst, Hadoop’s architecture transforms into a modern, efficient lakehouse model. Starburst introduces Trino as the powerful query engine, replacing Hive and Impala, which significantly enhances query performance and scalability. 

Learn more arrow_right_alt

Free Digital Book

Free O'Reilly Book - Trino: The Definitive Guide

Trino: The Definitive Guide is the first and foremost book about the Trino (formerly known as Presto) distributed query engine.

Download for free arrow_right_alt

Blog Post

Understanding the Starburst and Trino Hive Connector Architecture

In this blog we’re going to dive into arguably the quintessential use case of the Starburst query engine to gain an insight into the answer to this question.

Read now arrow_right_alt

Get in touch

Want to try Starburst? Have questions? We're here to help.

Contact Us

Start Free with
Starburst Galaxy

Up to $500 in usage credits included

  • Query your data lake fast with Starburst's best-in-class MPP SQL query engine
  • Get up and running in less than 5 minutes
  • Easily deploy clusters in AWS, Azure and Google Cloud
For more deployment options:
Download Starburst Enterprise

Please fill in all required fields and ensure you are using a valid email address.

By clicking Create Account, you agree to Starburst Galaxy's terms of service and privacy policy.