Apache Pinot vs ClickHouse Cloud
Apache Pinot
pinot.apache.org
ClickHouse Cloud
clickhouse.comSide by side
| Figure | Apache Pinot | ClickHouse Cloud |
|---|---|---|
| Price from | Free | $25.30/mo |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | Yes |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 3 |
| Spec score · Analytical Data Store Software | 8.2 (#9) | 9.1 (#2) |
| Spec score · Analytics Data | 8.2 (#10) | 9.1 (#2) |
| Spec score · OLAP Databases | 8.1 (#10) | 9.0 (#4) |
| Spec score · OLAP Software | 8.2 (#11) | 9.1 (#1) |
| Spec score · Analytics Databases | 8.2 (#11) | 9.1 (#2) |
| Spec score · Columnar Databases | 8.2 (#10) | 9.1 (#4) |
| Spec score · Big Data Analytics Software | 8.1 (#12) | 8.9 (#5) |
| Spec score · Database Software | 7.8 (#56) | 9.0 (#8) |
| Founded | 2013 | 2021 |
| Support | The project provides Slack, mailing lists, GitHub Issues, and community meetups for questions and discussion. | Cloud subscriptions include support services; the support page lists unlimited support cases and 24x7 support for Severity 1 issues for monthly pay-as-you-go or annual customers. |
Plans
ClickHouse Cloud
- Basic$25.30 a month
- Enterprise$25.30 a month
- Scale$25.30 a month
In their own words
Apache Pinot
Apache Pinot is a free, open-source distributed OLAP datastore for real-time analytics and user-facing workloads. It ingests streaming data from Apache Kafka, Apache Pulsar, and AWS Kinesis, plus batch data from Hadoop, Spark, Amazon S3, Azure ADLS, and Google Cloud Storage. Streaming and batch sources can be combined into one queryable table. Pinot provides SQL through a query editor and REST API, with JDBC, Java, Python, and Golang clients for applications. Project materials advertise P90 query latency in the tens of milliseconds on petabyte-scale data and capacity for hundreds of thousands of concurrent queries per second. Logical namespaces provide multitenancy. Security features include HTTP Basic Authentication, ACLs, TLS, mutual TLS, and row-level security filters in version 1.4.0 and later. Superset, Tableau, and Power BI can connect as BI tools. Official installation guidance covers Docker and Kubernetes with Helm. The self-hosted plan is listed at free.
ClickHouse Cloud
ClickHouse Cloud has no write-up on Specifiction yet; its figures are above.