Try our new research platform with insights from 80,000+ expert users

Amazon Athena vs Solr comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Amazon Athena
Ranking in Search as a Service
7th
Average Rating
7.8
Reviews Sentiment
7.2
Number of Reviews
9
Ranking in other categories
No ranking in other categories
Solr
Ranking in Search as a Service
9th
Average Rating
7.8
Number of Reviews
4
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2025, in the Search as a Service category, the mindshare of Amazon Athena is 5.5%, down from 14.0% compared to the previous year. The mindshare of Solr is 5.3%, down from 6.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Search as a Service Market Share Distribution
ProductMarket Share (%)
Amazon Athena5.5%
Solr5.3%
Other89.2%
Search as a Service
 

Featured Reviews

Ciro Baldim Guerra - PeerSpot reviewer
Have struggled with exporting complex data and have disabled code suggestions due to inefficiency
I think there is room for improvement in Amazon Athena, and the first thing I will put is the data output. I use Python to query in Amazon Athena, and it's very complex and difficult just to save Amazon Athena results as an Excel file. The only option is copying the data, but sometimes if it exceeds 100 lines, if you copy and paste in Excel, it's very bad. You can't copy above 100 lines. The other option is downloading a CSV file, but the CSV file is not UTF-8 Unicode. Here in Brazil, we speak Portuguese, and there are a lot of special characters in the words and even names, and everything gets garbled when you put it in a CSV. You have to decode, encode, and there are a lot of problems. It could easily save as an Excel file since there are a lot of engines to help with it, so an XLSX file extension could be this way. Another point I would mention is the word completion. When I'm coding and making statements and queries, Amazon Athena tries to help me write the code, and that's very problematic. Sometimes I'm using some tables that I use every day, and Amazon Athena doesn't get the tables I'm using and suggests very improbable data. I have access to more than 30 databases and hundreds of tables. So, I turn it off, I disable the word completion because when I'm coding, the word completion makes the coding slower. It's very difficult, and every time I have to press escape to skip the completion. It's very ineffective, so I disable it because in other applications it functions very well, such as VS Code.
reviewer823641 - PeerSpot reviewer
The Natural Language Search capability is helpful and intuitive for our users
The initial setup is complex because this is a distributed system, and you have to make sure that every individual node is aware of every other node in existence. This search engine has a large capacity, so you need to make sure that there is enough buffer space. We took one month to deploy and perform a fresh setup. Our strategy was to start with a local data center, before venturing into cross data center replicas. A staff size of two to four people is suitable for deploying and maintaining the solution, depending upon the scale. They would set up the solution and put monitoring in place for the indexing jobs, as well as design the schema so that the data can feed well.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"One of the most valuable features is the ability to partition your databases. I also like the federal query functionality, for cases when you have to query outside your S3 storage, or even completely outside of the AWS platform."
"Amazon Athena is very stable. I never had any issues with it. The dashboarding tool is okay."
"It's easy to set up the product."
"The solution is very easy to use and integrations are very smooth."
"Athena has a really good UI and is very compatible with on-prem products."
"​Sharding data, Faceting, Hit Highlighting, parent-child Block Join and Grouping, and multi-mode platform are all valuable features."
"The most valuable feature is the ability to perform a natural language search."
"One of the best aspects of the solution is the indexing. It's already indexed to all the fields in the category. We don't need to spend so much extra effort to do the indexing. It's great."
"It has improved our search ranking, relevancy, search performance, and user retention."
 

Cons

"The solution should include a better API for query services."
"You have to build out the metadata yourself because of the nature of the cloud."
"One improvement I can suggest is that Athena needs to work better with third-parties. For example, the process of querying a Microsoft SQL warehouse could be improved."
"If you compare it with Palantir, if you have some data and you want to quickly have a look at it, then that feature is not available in Amazon Cloud."
"I think it would be better if the product were more mature. It's still a young product compared to Power BI or Qlik. I find that development is a bit difficult, but it might be because I'm used to other tools. The dashboarding capabilities could be better. The reporting and statement generation could be better. I couldn't technically initiate picture-perfect reporting, for example, to send out statements every month for banking customers."
"SolrCloud stability, indexing and commit speed, and real-time Indexing need improvement."
"Encountered issues with both master-slave and SolrCloud. Indexing and serving traffic from same collection has very poor performance. Some components are slow for searching."
"With increased sharding, performance degrades. Merger, when present, is a bottle-neck. Peer-to-peer sync has issues in SolrCloud when index is incrementally updated."
"It does take a little bit of effort to use and understand the solution. It would help us a lot if the solution offered up more documentation or tutorials to help with training or troubleshooting."
"The performance for this solution, in terms of queries, could be improved."
 

Pricing and Cost Advice

"I am happy with what they are charging and how they charge it, especially because they charge you per query, and not per series."
"The solution operates on a serverless model so you only pay for data that you consume."
"It doesn't cost much if you are already part of the AWS ecosystem."
"Athena is very inexpensive for being a cloud tool."
"The only costs in addition to the standard licensing fees are related to the hardware, depending on whether it is cloud-based, or on-premise."
report
Use our free recommendation engine to learn which Search as a Service solutions are best for your needs.
871,408 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
23%
Computer Software Company
14%
Government
11%
Manufacturing Company
10%
Computer Software Company
15%
Retailer
10%
Manufacturing Company
8%
Financial Services Firm
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise3
Large Enterprise2
No data available
 

Questions from the Community

What needs improvement with Amazon Athena?
I don't have any specific answer on how Amazon Athena can be improved. This integration is more on the Glue side rather than on Amazon Athena, I would guess. Nothing comes to my mind here. In terms...
What is your primary use case for Amazon Athena?
The typical use case for Amazon Athena is that we have data in a data lake, and if we need to query the data from the data lake, we use Amazon Athena before it gets to the data warehouse where we w...
What advice do you have for others considering Amazon Athena?
I have experience of integration of Amazon Athena with AWS Glue. I think the pricing of Amazon Athena is quite reasonable as we use it in pay-as-you-go mode. On a scale from one to ten, I rate Amaz...
Ask a question
Earn 20 points
 

Comparisons

 

Overview

 

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
eHarmony, Sears, StubHub, Best Buy, Instagram, Netflix, Disney, AT&T, eBay, AOL, Bloomberg, Comcast, Ticketmaster, Travelocity, MTV Networks
Find out what your peers are saying about Amazon Athena vs. Solr and other solutions. Updated: September 2025.
871,408 professionals have used our research since 2012.