Hive Pros and Cons

File formats for optimizations, external Review collected by and hosted on G2.com.

cannot analyse unstructured data, not much faster when it comes to complex operations on very huge data Review collected by and hosted on G2.com.

The data distribution and data processing in hive is very good in hive. DDL and DML functions in hive are better than conventional sql databases. Hive is better known for fault resistance. Review collected by and hosted on G2.com.

The data output on hive is very slow. The data processing is very slow and the output is delayed due to this slow processing. Also the syntax is bit complex than conventional sql language. Review collected by and hosted on G2.com.

Best thing about Hive is it alows us to write the code in sql for processing and managing the data. It allows us to partition and distribut the data among the cluster machines. We can also choose execution engine like spark, tez,mapredice while rinning in hive. If you your processing and analysing the bulk volume of batch data then hive is best. Review collected by and hosted on G2.com.

It supports only structure data and we can't do updates too. Only supports OLAP. Review collected by and hosted on G2.com.

The friendliness of the data warehouse tool for the database developers Review collected by and hosted on G2.com.

Not inclusion of acid properties, it doesn't have the acid properties as in the databases Review collected by and hosted on G2.com.

Apache Hive supports the analysis of large datasets stored under Hadoop's HDFS and in compatible systems like the Amazon file system. Review collected by and hosted on G2.com.

Ofrece muchas herramientas, tiene un gran potencial de crecimiento. Review collected by and hosted on G2.com.

the ease of use and its interface is best Review collected by and hosted on G2.com.

running of queries in slow mode of map-reduced Review collected by and hosted on G2.com.

Good querying on hive databases.and easy to create schemas Review collected by and hosted on G2.com.

It does not allow datatypes conversion.

As it will result in lost of data Review collected by and hosted on G2.com.

It's performance using distributed computation Review collected by and hosted on G2.com.

Limited options for query performance optimization Review collected by and hosted on G2.com.

Schema on any format HDFS files. Easy to download the data. A complete tool similar to database tool like toad. Review collected by and hosted on G2.com.

Performance,sometime it is very difficult to run queries. Gui can be improved with more user friendly options Review collected by and hosted on G2.com.

Otherwise, if you write it as a normal SQL, it can take hours to process. But it is a bit different from standard SQL. Personally speaking, I use Hive mainly for ad hoc queries and reports. It is a data warehousing software that facilitates querying and managing large datasets residing in distributed storage. Review collected by and hosted on G2.com.

Performance tuning is difficult and becomes challenging for complex queries, it still has some bugs, such as all data going to a single reducer, which can slow down query results. -> Some SQL operations do not work in Hive, such as inequality joins, data cannot be updated, but we will have to rewrite. Review collected by and hosted on G2.com.