Apache Drill vs Mandrill: What are the differences?
Apache Drill: Schema-Free SQL Query Engine for Hadoop and NoSQL. Apache Drill is a distributed MPP query layer that supports SQL and alternative query languages against NoSQL and Hadoop data storage systems. It was inspired in part by Google's Dremel; Mandrill: Send transactional, triggered, and personalized email, then track results. Mandrill is a new way for apps to send transactional email. It runs on the delivery infrastructure that powers MailChimp.
Apache Drill belongs to "Database Tools" category of the tech stack, while Mandrill can be primarily classified under "Transactional Email".
Some of the features offered by Apache Drill are:
- Low-latency SQL queries
- Dynamic queries on self-describing data in files (such as JSON, Parquet, text) and MapR-DB/HBase tables, without requiring metadata definitions in the Hive metastore.
- ANSI SQL
On the other hand, Mandrill provides the following key features:
- Inbound Email- Set up inboxes for Mandrill to control. When they receive email, we’ll make an API call to your app with all the relevant information, so you don’t have to worry about what’s happening behind the scenes.
- Webhooks Support- Create custom event notifications, keep track of new signups and unsubscribes in real-time, get a notice of every spam complaint so you can flag them in your database.
- Rules Engine- Modify the content of email coming through Mandrill without having to involve developers. For example, you could tell Mandrill to take any email coming from firstname.lastname@example.org, give it a new template, and add Google Analytics tracking.
"NoSQL and Hadoop" is the primary reason why developers consider Apache Drill over the competitors, whereas "Simple installation" was stated as the key factor in picking Mandrill.
What is Apache Drill?
What is Mandrill?
Need advice about which tool to choose?Ask the StackShare community!
Sign up to add, upvote and see more prosMake informed product decisions
What are the cons of using Apache Drill?
Sign up to get full access to all the companiesMake informed product decisions
What tools integrate with Apache Drill?
Sign up to get full access to all the tool integrationsMake informed product decisions
We've moved our transactional email away from Mandrill to Mailgun. We had continued using Mandrill after Mailchimp deprecated the service awhile back, because the amount of credits we were offered essentially made it free.
However, following a couple weeks of frequent downtime and poor service transparency from Mandrill, we decided it was time to make the switch. It appears they no longer had any engineers with the ability to identify the core problems.
Mailgun has been more reliable, yet not as reliable as we expected. We still see issues a few times per week with the API failing when we attempt to make a call. The Reporting UI is way better.
This is by far the best way to send emails. I learned the API in under 15 minutes and started sending email right then. And best of all, it's completely free to use them for me! They give you 12,000 emails/month for free. I don't have to send much email, so I've never paid a cent. I highly recommend them.
We use Mandrill to send transactional emails and newsletters. We've just moved from SendGrid as Mandrill has far better support for templates and also integrates really nicely with MailChimp where we can design the emails.
We started off with AWS SES, but found it to be lacking in diagnostics and reporting. Mandrill is a quantum leap forward in this regard. Has some other really neat features carried over from MailChimp (templating).
We use Mandrill to handle all transactional emailing - from welcome letters to password reminders to notifications.
Mandrill is used to send out all e-mail from the application and any tools and services in our infrastructure.