Apache Druid vs Exasol
Apache Druid
druid.apache.org
Exasol
exasol.comSide by side
| Figure | Apache Druid | Exasol |
|---|---|---|
| Price from | Free | $3.30/mo |
| Free plan | Yes | Yes |
| Free trial | — | Yes |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 18 |
| Spec score · Big Data Analytics Software | 9.0 (#2) | 9.0 (#3) |
| Spec score · OLAP Software | 9.0 (#3) | 9.1 (#2) |
| Spec score · Analytics Databases | 9.0 (#3) | 9.2 (#1) |
| Spec score · Analytics Data | 9.0 (#3) | 9.2 (#1) |
| Spec score · OLAP Databases | 9.0 (#3) | 9.1 (#2) |
| Spec score · Analytical Data Store Software | 9.0 (#4) | 9.1 (#3) |
| Spec score · Columnar Databases | 9.0 (#6) | 9.1 (#5) |
| Spec score · Database Software | 8.7 (#18) | 9.0 (#9) |
| Deployment | Druid can run on commodity hardware in *NIX environments and is designed to run in AWS, GCP, Azure, and other cloud environments. | Exasol lists on-premises, hybrid, and fully managed SaaS deployment options; on-premises environments can include air-gapped setups. |
| Integrations | Core extensions support systems and formats including S3, HDFS, Google Cloud Storage, Azure, Kafka, Kinesis, Avro, ORC, Parquet, MySQL, and PostgreSQL. | Official ecosystem documentation lists BI integrations including Power BI, Tableau, Looker, Qlik Sense, SAS, Superset, Yellowfin and Amazon QuickSight. |
| Security | Security features include TLS, authentication, and authorization, but they are disabled by default and the documentation says to configure them for production. | Exasol states that it is ISO/IEC 27001 certified and describes controls including access control and incident response processes. |
| Support | The project directs users to its community network for help using Druid. | Exasol’s support page lists 24/7 incident troubleshooting and monitoring, plus performance analysis, maintenance, and planning assistance. |
| What it does | Apache Druid is a real-time analytics database for sub-second queries on streaming and batch data at scale. | Exasol is an analytics database designed for high-concurrency analytics, data warehousing, AI and machine-learning workloads. |
Plans
Exasol
- XS$3.30 a month
- S$6.60 a month
- M$13.20 a month
- L$26.40 a month
- XL$52.80 a month
- 2XL$105.60 a month
- 3XL$158.40 a month
- Storage$25 a month
- Exasol Community EditionFree
- Exasol PersonalFree
In their own words
Apache Druid
Apache Druid is a free, open-source analytics database for querying streaming and batch data. It is designed to return OLAP queries in milliseconds, including on high-cardinality datasets with billions to trillions of rows. The project describes applications ranging from hundreds to 100,000 queries per second. Native Apache Kafka and Amazon Kinesis integrations support low-latency ingestion and querying as data arrives. Druid organizes ingested data into columnar, time-indexed, encoded and compressed storage. Queries can use Druid SQL or JSON-over-HTTP, and joins are available during ingestion or at query time. Its web console can load data, manage datasources and tasks, show server status and run queries. Extensions connect to storage, databases and formats including S3, HDFS, Azure, PostgreSQL, Avro, ORC and Parquet. Druid can be self-hosted on Linux, macOS and other Unix-like systems; Windows is not supported. The local quickstart needs at least 6 GiB of RAM and Java 17. Production security controls require configuration.
Exasol
Exasol is a database for analytics and high-concurrency AI workloads, available in cloud, on-premises, hybrid, and fully managed SaaS deployments. The company says teams can analyze billions of rows in seconds and that automatic self-indexing helps tune performance. SaaS includes five databases, multi-cluster support, basic UDF support, advanced in-database analytics, and data virtualization. Teams can scale vertically or add clusters with dedicated compute for work such as data ingest or machine learning. The 30-day SaaS trial includes $200 of usage and requires no credit card. Pay-as-you-go compute is billed hourly; XS is $3.30 a month and S is $6.60 a month, while storage is listed separately at $25 a month. Free options include Exasol Personal, licensed for a single user and up to two connected data sources, and Community Edition, limited to 200GB of data. Exasol lists integrations including Airbyte, Alation, Amazon QuickSight, Apache Airflow, and Apache Superset. Its documentation covers multiple authentication methods and TLS encryption for database connections; encryption at rest must be configured on the supplied file systems and devices.