What users are saying about
3 Ratings
Top Rated
56 Ratings
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101
Top Rated
56 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101

Add comparison

Likelihood to Recommend

Apache Drill

if you're doing joins from hBASE, hdfs, cassandra and redis, then this works.Using it as a be all end all does not suit it. This is not your straight forward magic software that works for all scenarios. One needs to determine the use case to see if Apache Drill fits the needs. 3/4 of the time, usually it does.
Anson Abraham profile photo

Redis

Redis is extremely well suited for storing key-value kind of data. Flat and static values are around which they are built. There is no headache of indexing, or maintaining formats like other databases have.I can also vouch for Redis's pub/sub notification. You can basically set expiration or event hooks around your keys, and Redis will trigger a notification for those events.But Redis is ill-suited for treating it as a proper database. For instance, this is not a replacement for elasticsearch or mongo.To assess if you need Redis, in my opinion, just think if you need to query values. If yes, don't use redis. If you are only concerned with key operations, then go with Redis.
Rahul Chaudhary profile photo

Feature Rating Comparison

NoSQL Databases

Apache Drill
Redis
8.2
Performance
Apache Drill
Redis
8.8
Availability
Apache Drill
Redis
8.8
Concurrency
Apache Drill
Redis
8.5
Security
Apache Drill
Redis
6.4
Scalability
Apache Drill
Redis
9.2
Data model flexibility
Apache Drill
Redis
7.7
Deployment model flexibility
Apache Drill
Redis
8.1

Pros

  • queries multiple data sources with ease.
  • supports sql, so non technical users who know sql, can run query sets
  • 3rd party tools, like tableau, zoom data and looker were able to connect with no issues
Anson Abraham profile photo
  • Caching - that's what it's built to do, and it does it well.
  • Performance - pretty much everything happens in memory, so it's blazing fast.
  • Atomic operations - when you need a distributed counter, Redis is a great option for avoiding race conditions across services/servers.
  • Blocking calls - polling for changes kinda stinks, and Redis gives you the option to perform blocking calls that immediately return when data is ready.
No photo available

Cons

  • deployment. Not as easy
  • configuration isn't as straight forward, especially with the documentation
  • Garbage collection could be improved upon
Anson Abraham profile photo
  • Complex querying - Redis is not a relational database, and should not be used as one.
  • Clustering - this is always a complicated topic, but it could be made more simple.
No photo available

Likelihood to Renew

Apache Drill7.0
Based on 1 answer
if Presto comes up with more support (ie hbase, s3), then its strongly possible that we'll move from apache drill to prestoDB. However, Apache drill needs more configuration ease, especially when it comes to garbage collection tuning. If apache drill could support also sparkSQL and Flume, then it does change drill into being something more valuable than prestoDB
Anson Abraham profile photo
Redis9.2
Based on 10 answers
If it's open source, then Redis. Though now RethinkDB and Riak are going full on opensource. and being supported by community. So might give those a re-try as well.
Anson Abraham profile photo

Usability

No score
No answers yet
No answers on this topic
Redis9.0
Based on 1 answer
Redis has been around for very long and it is good at what it does. It proved to be very valuable in my use case for interfacing between two applications with very little code as it has drivers for almost every language out there and the community support is really good.
No photo available

Alternatives Considered

compared to presto, has more support than prestodb.Impala has limitations to what drill can supportapache phoenix only supports for hbase. no support for cassandra. Apache drill was chosen, because of the multiple data stores that it supports htat the other 3 do not support. Presto does not support hbase as of yet. Impala does not support query to cassandra
Anson Abraham profile photo
Memcached is a much more simple caching layer than Redis. Some features that make Redis come out above memcached include:
  • Data structures. Redis offers plenty of useful data structures (lists, hashmaps, sets, etc) where memcached is basically just strings.
  • Data persistence. Redis can flush data to disk to be restored if/when the redis service is restarted. Memcached loses everything each time you restart it.
  • Pubsub. Redis allows you to subscribe to certain topics/channels and publish messages to those topics/channels for consumption in several places. No such feature with memcached.
  • Object size. Redis allows you to store much larger values than memcached.
  • Clustering. Redis allows you to setup a cluster for replication/redundancy. No such capability built into memcached.
No photo available

Return on Investment

  • Configuration has taken some serious time out.
  • Garbage collection tuning. is a constant hassle. time and effort applied to it, vs dedicating resources elsewhere.
  • w/ sql support, reduces the need of devs to generate the resultset for analysts, when they can run queries themselves (if they know sql).
Anson Abraham profile photo
  • Redis is free, so the ROI is pretty incredible.
  • Setting up redis is as simple as installing a package, launching a service, then configuring your application to talk to it. Very low overhead that way, and very quick and easy to get up and running.
No photo available

Pricing Details

Apache Drill

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Apache Drill More Information

Redis

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Redis More Information