Impala vs. Presto vs. Apache Spark



Hacker News, Reddit, Stack Overflow Stats

  • -
  • -
  • 1.17K
  • 19
  • 38
  • 146
  • -
  • 571
  • 0

GitHub Stats

Description

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.

What is 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.

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

Pros

Why do developers choose Impala?
Why do you like Impala?

Why do developers choose Presto?
Why do you like Presto?

Why do developers choose Apache Spark?
Why do you like Apache Spark?

Cons

What are the cons of using Impala?
No Cons submitted yet for Impala
Downsides of Impala?

What are the cons of using Presto?
No Cons submitted yet for Presto
Downsides of Presto?

What are the cons of using Apache Spark?
No Cons submitted yet for Apache Spark
Downsides of Apache Spark?

Companies

What companies use Impala?
15 companies on StackShare use Impala
What companies use Presto?
27 companies on StackShare use Presto
What companies use Apache Spark?
304 companies on StackShare use Apache Spark

Integrations

What tools integrate with Impala?
2 tools on StackShare integrate with Impala
What tools integrate with Presto?
16 tools on StackShare integrate with Presto
What tools integrate with Apache Spark?
12 tools on StackShare integrate with Apache Spark

What are some alternatives to Impala, Presto, and Apache Spark?

  • Apache Flink - Fast and reliable large-scale data processing engine
  • Druid - Fast column-oriented distributed data store
  • Amazon Athena - Query S3 Using SQL
  • Pig - Platform for analyzing large data sets

See all alternatives to Impala



Interest Over Time