What users are saying about

Amazon RDS

Top Rated
68 Ratings

Apache Hive

63 Ratings

Amazon RDS

Top Rated
68 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Apache Hive

63 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

Add comparison

Likelihood to Recommend

Amazon RDS

Amazon RDS is well suited if you need a highly-available, cloud-hosted, scalable database for websites or web applications. It can grow to serve as many queries as you need (at a cost) and is easy to configure. That being said, RDS can get expensive quickly depending on your use. If you're hosting a simple website or blog, it would be cheaper to stand up a database inside the EC2 instance powering the application. If you're not working with a lot of data, RDS can potentially be overkill for your needs.
Eric Mann profile photo

Apache Hive

Use it for ETL workloads. I prefer repeat the same workload with Spark and decide the better performance
No photo available

Pros

  • Multiple availability zones for high assurance of uptime
  • Both hosted and local management/reporting utilities
  • Integration with CloudWatch and CloudFormation for automated creation and real-time performance metrics
Eric Mann profile photo
  • One of the standard SQL on Hadoop implementations. Comes installed in both HDP and CDH Hadoop distributions.
  • Hive Live Long and Process has made recent significant improvement on long-running queries.
  • Allows BI tools to run analysis over Hadoop data.
  • Allows various relational databases for its metastore. These include MySQL, Postgres, Derby, or Oracle.
Jordan Moore profile photo

Cons

  • Postgres, in particular, is configured in such a way as to prevent access to the `postgres` user. Considering things like database extensions are installed under this user, if extensions ever need to be removed/modified, you have to rebuild and migrate your entire database!
  • Cross-system database migrations are somewhat slow and, in many cases, require a great deal of manual work to ensure data type information (i.e. UUIDs or Integers) is properly set-post migration (otherwise many types are re-cast to strings).
Eric Mann profile photo
  • Joins (especially left join and right join) are very complex, space consuming and time consuming. Improvement in this area would be of great help!
  • Having more descriptive errors help in resolving issues that arise when configuring and running Apache Hive.
Venkata Mallepudi profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Apache Hive10.0
Based on 1 answer
Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
Yinghua Hu profile photo

Usability

No score
No answers yet
No answers on this topic
Apache Hive9.0
Based on 1 answer
Hive's support SQL like queries improves its usability since almost every potential user of Hive would have had experience with SQL.
Tom Thomas profile photo

Alternatives Considered

Our other application components are all hosted within Amazon's systems already, and the tight coupling of RDS with the security groups and virtual private cloud offerings made locking down privacy and security much easier than integrating with an outside provider. The deeper support for Postgres also made it easier to make the decision for Amazon as that database was higher on our wish list.
Eric Mann profile photo
I used Impala when it was still in the bud stage. Apache hive has been very convenient from the very beginning
Venkata Mallepudi profile photo

Return on Investment

  • Our databases are highly reliable, meaning our systems team can focus on other business endeavors rather than maintenance.
Eric Mann profile photo
  • Reduced learning curve for new trainees and users
  • Support for other client server databases provided improved compatibility of systems
Tom Thomas profile photo

Pricing Details

Amazon RDS

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

Apache Hive

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