Presto
Presto

91
364
40
Apache Spark
Apache Spark

958
0
98
Add tool

Presto vs Apache Spark: What are the differences?

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; Apache Spark: Fast and general engine for large-scale data processing. 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.

Presto and Apache Spark can be primarily classified as "Big Data" tools.

"Works directly on files in s3 (no ETL)" is the top reason why over 9 developers like Presto, while over 45 developers mention "Open-source" as the leading cause for choosing Apache Spark.

Presto and Apache Spark are both open source tools. It seems that Apache Spark with 22.3K GitHub stars and 19.3K forks on GitHub has more adoption than Presto with 9.22K GitHub stars and 3.12K GitHub forks.

Slack, Shopify, and SendGrid are some of the popular companies that use Apache Spark, whereas Presto is used by Repro, Airbnb, and Netflix. Apache Spark has a broader approval, being mentioned in 263 company stacks & 111 developers stacks; compared to Presto, which is listed in 19 company stacks and 11 developer stacks.

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!

Why do developers choose Presto?
Why do developers choose Apache Spark?
What are the cons of using Presto?
What are the cons of using Apache Spark?
    Be the first to leave a con
    What companies use Presto?
    What companies use Apache Spark?
    What are some alternatives to Presto and Apache Spark?
    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.
    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.
    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.
    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.
    See all alternatives
    What tools integrate with Presto?
    What tools integrate with Apache Spark?
      No integrations found
      Decisions about Presto and Apache Spark
      No stack decisions found
      Interest over time
      Reviews of Presto and Apache Spark
      No reviews found
      How developers use Presto and Apache Spark
      Avatar of Wei Chen
      Wei Chen uses Apache SparkApache Spark

      Spark is good at parallel data processing management. We wrote a neat program to handle the TBs data we get everyday.

      Avatar of Ralic Lo
      Ralic Lo uses Apache SparkApache Spark

      Used Spark Dataframe API on Spark-R for big data analysis.

      Avatar of Kalibrr
      Kalibrr uses Apache SparkApache Spark

      We use Apache Spark in computing our recommendations.

      Avatar of BrainFinance
      BrainFinance uses Apache SparkApache Spark

      As a part of big data machine learning stack (SMACK).

      Avatar of Dotmetrics
      Dotmetrics uses Apache SparkApache Spark

      Big data analytics and nightly transformation jobs.

      How much does Presto cost?
      How much does Apache Spark cost?
      Pricing unavailable
      Pricing unavailable
      News about Presto
      More news
      News about Apache Spark
      More news