What users are saying about
81 Ratings
Top Rated
222 Ratings
81 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100
Top Rated
222 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Likelihood to Recommend

Apache Hive

Apache Hive shines for ad-hoc analysis and plugging into BI tools. Its SQL-like syntax allows for ease of use not for only for engineers but also for data analysts. Through our experience, there are probably more desirable tools to use if you are planning on integrating Hive into your processing pipeline.
Anonymous | TrustRadius Reviewer

PostgreSQL

I don't know anyone who would choose another RDBMS other than PostgreSQL for a new project. Thanks to the wealth of field types, it can even function in situations where you might choose a document-based "NoSQL" db. Its indexing is excellent, meaning that high-performance applications with low thresholds for latency can benefit from it. It is the primary datastore that I recommend to anyone starting a new project which has relational data
Don Burks | TrustRadius Reviewer

Pros

Apache Hive

  • Hive syntax is almost like SQL, so for someone already familiar with SQL it takes almost no effort to pick up Hive.
  • To be able to run map reduce jobs using json parsing and generate dynamic partitions in parquet file format.
  • Simplifies your experience with Hadoop especially for non-technical/coding partners.
Bharadwaj (Brad) Chivukula | TrustRadius Reviewer

PostgreSQL

  • Advanced spatial capabilities by using PostGIS extension
  • Very fast data processing and support of native ANSI SQL language syntax allows maintaining capability and scalability of database
  • Fast data aggregation, even by SQL or stored routines/functions
  • Well documented, free for use, great community. A lot of examples, and for this reason - lesser threshold for junior developers to start with
Vladimir Salnikov | TrustRadius Reviewer

Cons

Apache Hive

  • Use Hive for analytical work loads. Write once and read many scenarios. Do not prefer updates and deletes.
  • Behind scenes Hive creates map reduce jobs. Hive performance is slow compared to Apache Spark.
  • Map reduce writes the intermediate outputs to dial whereas Spark operates in in-memory and uses DAG.
Anonymous | TrustRadius Reviewer

PostgreSQL

  • The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
  • The replication services could be done directly within the database, and more easily.
  • The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).
Javier Blanque | TrustRadius Reviewer

Likelihood to Renew

Apache Hive

Apache Hive 10.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 | TrustRadius Reviewer

PostgreSQL

PostgreSQL 9.0
Based on 1 answer
As a needed software for day to day development activities
Ojoswi Basu | TrustRadius Reviewer

Usability

Apache Hive

Apache Hive 8.5
Based on 9 answers
Thanks to its high usability Apache Hive enables users to craft extensive queries really efficiently and at the same time to how to hold response times very low. HiveQL simplicity makes it super easy to manage large datasets, what was almost an impossible task before introduction of Apache Hive data warehousing platform in our company.
Anonymous | TrustRadius Reviewer

PostgreSQL

PostgreSQL 9.0
Based on 6 answers
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
Anonymous | TrustRadius Reviewer

Reliability and Availability

Apache Hive

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 2 answers
PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
Ojoswi Basu | TrustRadius Reviewer

Performance

Apache Hive

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 7.0
Based on 2 answers
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
Ojoswi Basu | TrustRadius Reviewer

Support Rating

Apache Hive

Apache Hive 7.1
Based on 8 answers
Hive also has a community platform of its own just like other Hadoop frameworks. Most of the queries/problems are resolved in the community itself. We can just post our problems or get in touch with a specific user and get the issue resolved. Otherwise there is always the product support team for any resolution.
Partha Protim Pegu | TrustRadius Reviewer

PostgreSQL

PostgreSQL 9.3
Based on 13 answers
AWS, Heroku, and Digital Ocean all provide Postgres-as-a-service, where you pretty much never need to administrate it yourself but they do it for you. The Postgres community also has developed awesome and reasonably priced extensions, such as Citus DB and CockroachDB in case you need additional support for running it. If you need documentation, Postgres's docs are super thorough and their official forms are active.
Anonymous | TrustRadius Reviewer

Online Training

Apache Hive

No answers on this topic

PostgreSQL

The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Ojoswi Basu | TrustRadius Reviewer

Implementation Rating

Apache Hive

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 3 answers
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
Ojoswi Basu | TrustRadius Reviewer

Alternatives Considered

Apache Hive

Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed.Amazon Redshift is the another product, I used in my recent organisation.Both Redshift and BigQuery are managed solution whereas Hive needs to be managed
Manjeet Singh | TrustRadius Reviewer

PostgreSQL

Compared to MySQL, it works well if you need to extend to your use caseCompared to Spark, it works better w.r.t development time in a central database settingLike Redis, it cannot be used for caching and quick access of non-structured data
Nitin Pasumarthy | TrustRadius Reviewer

Scalability

Apache Hive

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 8.0
Based on 1 answer
The DB is reliable, scalable, easy to use and resolves most DB needs
Ojoswi Basu | TrustRadius Reviewer

Return on Investment

Apache Hive

  • It exposes the distributed calculation world (Hadoop) to the users but doesn't require the user to have the in-depth understanding of boilerplate details, it reduces the time of learning and let the data analyst can focus their efforts on the core business.
Anonymous | TrustRadius Reviewer

PostgreSQL

  • By pushing a lot of logic into database views and triggers, PostgreSQL provides the ability to write much slimmer and more maintainable controller code, reducing development costs.
  • PostgreSQL's upsert capabilities enabled us to go to scale much more easily and quickly, allowing us to increase our number of customers.
David McCann | TrustRadius Reviewer

Pricing Details

Apache Hive

General

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

PostgreSQL

General

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

Add comparison