We performed a comparison between Amazon Athena and Solr based on real PeerSpot user reviews.
Find out what your peers are saying about Elastic, Amazon, Microsoft and others in Search as a Service."The solution is very easy to use and integrations are very smooth."
"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."
"Athena has a really good UI and is very compatible with on-prem products."
"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."
"You can perform SQL queries in S3 using Athena."
"​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."
"It has improved our search ranking, relevancy, search performance, and user retention."
"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."
"I would like to use Spark or Python-based queries in Athena."
"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."
"The solution should include a better API for query services."
"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."
"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."
"You have to build out the metadata yourself because of the nature of the cloud."
"The performance for this solution, in terms of queries, could be improved."
"SolrCloud stability, indexing and commit speed, and real-time Indexing need improvement."
"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."
"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."
"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."
Earn 20 points
Amazon Athena is ranked 4th in Search as a Service with 6 reviews while Solr is ranked 8th in Search as a Service. Amazon Athena is rated 7.6, while Solr is rated 7.8. The top reviewer of Amazon Athena writes "A great AWS application that is easy to set up and simple to expand". On the other hand, the top reviewer of Solr writes "Good indexing and decent stability, but requires more documentation". Amazon Athena is most compared with Amazon Elasticsearch Service, Amazon AWS CloudSearch, Azure Search and Elastic Search, whereas Solr is most compared with Amazon AWS CloudSearch, Amazon Kendra, Elastic Search and Azure Search.
See our list of best Search as a Service vendors.
We monitor all Search as a Service reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.