Hive Reviews & Product Details

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 allows us to write the code in SQL for processing and managing the data. It allows us to partition and distribute the data among the cluster machines. We can also choose execution engines like Spark, Tez, MapReduce while running in Hive. If you are processing and analyzing the bulk volume of batch data, then Hive is best. Review collected by and hosted on G2.com.

It supports only structured 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.

Hive is a data warehousing infrastructure built on top of Hadoop to provide data grouping, querying, and analysis. Apache Hive supports the analysis of large datasets stored under Hadoop's HDFS and in compatible systems like the Amazon file system. It offers a SQL-based query language called HiveQL5 with schemas to transparently read and convert queries in MapReduce, Apache Tez6, and Spark tasks. All three execution engines can run under YARN. To speed up queries, Hive provides indexes, which include bitmap indexes. Review collected by and hosted on G2.com.

Offers many tools, has great growth potential 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, sometimes 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 may 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 non-equality joins, data cannot be updated, but we will have to rewrite. Review collected by and hosted on G2.com.