Impala
Impala

55
199
8
Presto
Presto

91
356
40
Add tool

Impala vs Presto: What are the differences?

Impala: Real-time Query for Hadoop. Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time; Presto: Distributed SQL Query Engine for Big Data. Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.

Impala and Presto belong to "Big Data Tools" category of the tech stack.

"Super fast" is the primary reason why developers consider Impala over the competitors, whereas "Works directly on files in s3 (no ETL)" was stated as the key factor in picking Presto.

Impala and Presto are both open source tools. Presto with 9.29K GitHub stars and 3.15K forks on GitHub appears to be more popular than Impala with 2.18K GitHub stars and 824 GitHub forks.

Airbnb, Netflix, and Facebook are some of the popular companies that use Presto, whereas Impala is used by 37 Signals, Stripe, and Expedia.com. Presto has a broader approval, being mentioned in 19 company stacks & 11 developers stacks; compared to Impala, which is listed in 15 company stacks and 5 developer stacks.

What is Impala?

Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.

What is Presto?

Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.

Want advice about which of these to choose?Ask the StackShare community!

Why do developers choose Impala?
Why do developers choose Presto?
What are the cons of using Impala?
What are the cons of using Presto?
    Be the first to leave a con
      Be the first to leave a con
      What companies use Impala?
      What companies use Presto?
      What are some alternatives to Impala and Presto?
      Apache Spark
      Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
      Amazon Athena
      Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.
      Apache Flink
      Apache Flink is an open source system for fast and versatile data analytics in clusters. Flink supports batch and streaming analytics, in one system. Analytical programs can be written in concise and elegant APIs in Java and Scala.
      Druid
      Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
      Apache Hive
      Hive facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage.
      See all alternatives
      What tools integrate with Impala?
      What tools integrate with Presto?
        No integrations found
        Decisions about Impala and Presto
        No stack decisions found
        Interest over time
        Reviews of Impala and Presto
        No reviews found
        How developers use Impala and Presto
        No items found
        How much does Impala cost?
        How much does Presto cost?
        Pricing unavailable
        Pricing unavailable
        News about Impala
        More news
        News about Presto
        More news