Apache Druid vs Google BigQuery
Apache Druid
druid.apache.orgGoogle BigQuery
cloud.google.comSide by side
| Figure | Apache Druid | Google BigQuery |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | — |
| API | Yes | — |
| Self-hosted | Yes | — |
| Plans published | 1 | 0 |
| Spec score · Big Data Analytics Software | 9.0 (#2) | 5.4 (#30) |
| Spec score · OLAP Software | 9.0 (#3) | 5.6 (#30) |
| Spec score · Analytics Databases | 9.0 (#3) | 5.6 (#28) |
| Spec score · Analytics Data | 9.0 (#3) | 5.6 (#29) |
| Spec score · OLAP Databases | 9.0 (#3) | 5.5 (#28) |
| Spec score · Analytical Data Store Software | 9.0 (#4) | 5.6 (#25) |
| Spec score · Columnar Databases | 9.0 (#6) | 5.5 (#26) |
Plans
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.
Google BigQuery
Google BigQuery has no write-up on Specifiction yet; its figures are above.