Introducing G2.ai, the future of software buying.Try now
Compare Amazon Athena and ClickHouse 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
CockroachDB
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
ER/Studio
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
RaimaDB
Visit Website
At a Glance
Market Segments
Enterprise (51.0% of reviews)
Small-Business (47.4% of reviews)
Entry-Level Pricing
No pricing available
Starting at $1.00 Per Month
Amazon Athena
Star Rating
(165)4.4 out of 5
Market Segments
Enterprise (51.0% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Amazon AthenaClickHouse
Star Rating
(20)4.4 out of 5
Market Segments
Small-Business (47.4% of reviews)
Pros & Cons
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHouseSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Amazon Athena excels in ease of setup with a score of 9.1, making it a preferred choice for teams looking to quickly implement a solution. In contrast, ClickHouse, while still user-friendly, has a slightly lower score of 8.9, which some users feel could be improved for faster onboarding.
- Reviewers mention that ClickHouse shines in performance analysis, achieving a perfect score of 10.0. Users appreciate its ability to handle complex queries efficiently, while Amazon Athena, with a score of 8.5, is noted for its solid performance but may not match the speed of ClickHouse in high-demand scenarios.
- G2 users highlight that Amazon Athena offers a more robust data replication feature with a score of 8.7, which is crucial for maintaining data integrity across multiple sources. ClickHouse, with a score of 7.9, is seen as having room for improvement in this area, particularly for users managing large datasets.
- Users on G2 report that ClickHouse's query language is highly praised, scoring 9.3, which allows for advanced data modeling and analytics. In comparison, Amazon Athena's query language score of 8.6 indicates it is effective but may not provide the same level of flexibility and power as ClickHouse.
- Reviewers mention that Amazon Athena's data security features, particularly in data encryption and user access control, score highly at 9.0 and 9.1 respectively. ClickHouse, while also secure, has slightly lower scores in these areas, which some users feel could be a concern for sensitive data handling.
- Users say that both products are scalable, but ClickHouse stands out with a perfect score of 9.0 in scalability, making it ideal for businesses expecting rapid growth. Amazon Athena also scores well in this area, but users note that ClickHouse's architecture is particularly designed for handling large volumes of data seamlessly.
Pricing
Entry-Level Pricing
Amazon Athena
No pricing availableClickHouse
ClickHouse Pricing
Starting at $1.00
Per Month
Options for every user, organization, and use case.
- Up to 1 TB storage
- 16 GiB total memory
- Burstable CPU
Free Trial
Amazon Athena
No trial information availableClickHouse
No trial information availableRatings
Meets Requirements
8.4
121
8.9
11
Ease of Use
8.8
121
8.6
11
Ease of Setup
9.1
56
9.0
7
Ease of Admin
8.5
55
7.0
5
Quality of Support
8.5
103
8.7
9
Has the product been a good partner in doing business?
8.7
55
Not enough data
Product Direction (% positive)
9.1
96
10.0
10
Features by Category
Management
8.0
27
9.4
6
8.7
25
7.9
7
8.6
31
9.3
7
8.5
29
9.4
6
8.5
29
10.0
5
Maintenance
8.0
28
8.8
7
8.3
27
7.8
6
8.1
27
Not enough data
Security
9.0
29
Not enough data
9.1
31
Not enough data
Management
Not enough data
Not enough data
Not enough data
9.3
5
Not enough data
Feature Not Available
Not enough data
Not enough data
Support
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Security
Not enough data
Feature Not Available
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Performance
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database Features
Not enough data
9.0
5
Not enough data
9.3
5
Not enough data
9.0
5
Not enough data
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.7
5
Storage
Not enough data
9.2
6
Not enough data
9.0
7
Availability
Not enough data
Feature Not Available
Not enough data
7.8
6
Not enough data
8.3
6
Performance
Not enough data
8.1
6
Security
Not enough data
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.3
5
Support
Not enough data
Not enough data
Not enough data
Not enough data
Query latency
Not enough data
Not enough data
Not enough data
Not enough data
Data latency
Not enough data
Not enough data
Not enough data
Not enough data
Connectors
Not enough data
Not enough data
Not enough data
Not enough data
Scale
Not enough data
Not enough data
Not enough data
Not enough data
Architecture
Not enough data
Not enough data
Not enough data
Not enough data
Configuration
8.8
42
Not enough data
8.5
38
Not enough data
8.8
39
Not enough data
8.3
36
Not enough data
9.0
37
Not enough data
Database Administration
8.9
36
Not enough data
9.0
38
Not enough data
8.9
39
Not enough data
Availability
9.0
41
Not enough data
8.9
38
Not enough data
8.7
38
Not enough data
8.7
38
Not enough data
Security
8.8
36
Not enough data
9.2
36
Not enough data
9.0
34
Not enough data
Data Management
9.1
36
Not enough data
9.1
42
Not enough data
Categories
Categories
Shared Categories
Amazon Athena and ClickHouse are categorized as Database Management Systems (DBMS)
Unique Categories
Amazon Athena is categorized as Database as a Service (DBaaS)
ClickHouse is categorized as Real-time Analytic Database, Relational Databases, and Columnar Databases
Reviews
Reviewers' Company Size
Amazon Athena
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
ClickHouse
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
14.2%
Computer Software
12.3%
Financial Services
8.4%
Retail
4.5%
Pharmaceuticals
4.5%
Other
56.1%
Information Technology and Services
31.6%
Computer Software
21.1%
Wholesale
5.3%
Telecommunications
5.3%
Marketing and Advertising
5.3%
Other
31.6%
Discussions
Is AWS Athena free?
1 Comment
JI
NoRead more
How do I use AWS Athena?
1 Comment
BV
AWS Management Console
Command Line Interface (CLI)
JDBC/ODBC Drivers
WS Serverless Application RepositoryRead more
Amazon Athena has no more discussions with answers
ClickHouse has no discussions with answers
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
