DuckDB
Data Plane · Query & Processing Engines
In-process analytical SQL database, popular for local analytics and embedded workloads.
- Open source
Data Plane · Query & Processing Engines
Distributed engine for large-scale data processing, SQL, streaming and machine learning.
Apache Spark is the general-purpose distributed engine of the data world: one system for data engineering, data science and machine learning, on a single machine or a cluster of thousands of nodes.
The execution model is a driver program coordinating executor processes on workers. Each application gets its own executors, which stay up for the whole application and run tasks in multiple threads, so applications are isolated from one another.
Work is decomposed into jobs, then stages, then tasks, a task being the unit sent to a single executor. Cluster management is pluggable across standalone, Hadoop YARN and Kubernetes.
Adaptive query execution is the feature that quietly changed Spark's reputation for needing hand-tuning. It uses runtime statistics to re-plan queries mid-flight, and has been on by default since 3.2.
Its breadth is the reason it persists. The same engine handles batch and streaming, distributed ANSI SQL, machine learning through MLlib, and a pandas API, in Python, SQL, Scala, Java or R.
Spark Connect is the newer architectural shift: a thin client sends unresolved logical plans over gRPC and gets Arrow-encoded results back, so Spark can be embedded in applications, IDEs and notebooks without shipping a driver.
Be aware of the trade-off there: the RDD API is not supported through Spark Connect, so code reaching below the DataFrame level still needs classic mode.
Scale claims are concrete rather than marketing. The project states many organisations run clusters of thousands of nodes, the largest known being 8,000, and that it works well up to petabytes.
What to watch: GraphX is marked deprecated on the project's own home page, and from 4.0 brokers, Connect and tools require Java 17 while clients and Streams need Java 11.
Versioning is now predictable, with quarterly feature releases from 4.3.0 onward, annual major releases, and the final release of a major line supported as LTS for 18 months.
The same headings are used for every query & processing engines entry, so two tools can be read side by side.
Open sourceFree, Apache 2.0
Spark itself is free under Apache 2.0, with no paid edition and nothing sold by the foundation. Cost comes from the platform you run it on. Databricks, the vendor founded by its creators, prices in Databricks Units billed per second with committed-use discounts, and every major cloud sells a managed Spark of its own. When comparing, note that self-managed Spark trades licence cost for the operational work of cluster sizing, upgrades and tuning, which the managed services exist to absorb.
Spark started at the UC Berkeley AMPLab in 2009, was open-sourced in 2010 and donated to the Apache Software Foundation in 2013, where it is licensed under Apache 2.0 and governed by its project management committee. The project describes itself as developed by hundreds of developers from hundreds of organisations, with over 2,000 contributors, and says 80% of the Fortune 500 use it. The principal commercial vendor is Databricks, founded in 2013 by Spark's creators, and every major cloud packages a managed Spark, but releases are controlled by the foundation rather than by any vendor.
Founded 2013 · Wilmington, Delaware · spark.apache.org
Data Plane · Query & Processing Engines
In-process analytical SQL database, popular for local analytics and embedded workloads.
Data Plane · Query & Processing Engines
Lakehouse compute engine that allocates compute per query rather than by fixed warehouse size, aimed at high-concurrency SQL and AI workloads with no data movement.

Data Plane · Query & Processing Engines
Fast DataFrame library written in Rust, with Python bindings.
Data Plane · Query & Processing Engines
Distributed SQL query engine for querying data where it lives, across many sources.
Drafted with AI assistance and checked against the vendor’s own documentation.