Hive background blur
Hive logo
Hive
4.2
(59)
by Hive Technology, Inc.
Why Findstack is free?
Findstack is free for users because vendors pay us when they receive web traffic and sales opportunities. Findstack directories list all vendors — not just those that pay us so that you can make the best-informed purchase decision possible.
Unclaimed: Are are working at Hive?
Findstack offers objective, independent research and verified user reviews. We may earn a referral fee when you visit a vendor through our links. Learn more

Hive Reviews & Product Details

Hive Overview
What is Hive?

Hive is an all-in-one project management tool developed to “help teams move faster” regardless of how they work. Features are created based on users’ requests and are updated weekly, making Hive the world’s first democratic software platform. It’s best known for its capabilities in project management, time management, team collaboration, automation, and an array of integrations with third-party software. Hive is free to use for solo users and with premium versions available to teams and enterprises.

Company Hive Technology, Inc.
Year founded 2015
Company size 11-50 employees
Headquarters New York, NY, United States
Social Media
Hive Categories on Findstack
Hive Product Details
Capabilities
API
Segment
Small Business
Mid Market
Enterprise
Deployment Cloud / SaaS / Web-Based, Mobile Android, Mobile iPad, Mobile iPhone
Support 24/7 (Live rep), Chat, Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support
Training Documentation
Languages English
Hive Features
Templates
Creation & Assignment
To-Do Lists
Recurring Tasks
Due Dates
Dependecies
Task Prioritization
Drag & Drop
Planning
Views
Project Map
Calendar View
Dashboards
Mass Updates
GANTT
Hive Media
Hive 0
Hive 1
Hive 2
Hive 3
Hive 4
Hive Screenshots
Disclaimer
Our research is curated from diverse authoritative sources and meant to offer general advice. We don’t guarantee that our suggestions will work best for each use-case, so consider your unique needs when choosing products and services. Feel free to share your feedback.
Last updated: May 20, 2024
Hive logo
59 Hive Reviews
4.2 out of 5
Small Business (50 or fewer emp.)
Jul 13, 2015
 Source
Overall Rating:
4.5
DR
Daryl R.
Admissions Data Processor School Of Education And Counseling Psychology
Share
"It was wonderful! "
What do you like best about Hive?

Its very user friendly. Easy to install and use. I like the interface very much .

What do you dislike about Hive?

Nothing I can think of. I had a great experience working on HIVE and was satisfied with all the features as it met all my requirements.

What problems is Hive solving and how is that benefiting you?

I was working on a school project as a part of Big Data course and executing queries with HIVE made the whole project lot more simpler.

Enterprise (> 1000 emp.)
Apr 24, 2015
 Source
Overall Rating:
4.5
PK
Pradeepkumar K.
Big Data Engineer
Share
"For all the batch operations!"
What do you like best about Hive?

The syntax of hive! Its almost SQL so its easy to use. External tables, partitions, buckets, UDFs all the features I like to use with hive. ORC data format occupying lesser space and retrieving the data much faster. Learning curve looks easier as it is similar to SQL but hold on! you must learn all the features of hive before writing a big hql to join multiple hundreds GBs tables and fetch results. Otherwise if you write it like a regular SQL it may take hours to process. So hive is always at its best when you set the optimization parameters before you run your scripts. Also its complex datatypes make hive more useful than other RDBMS.

What do you dislike about Hive?

Hive is comparatively slower than its competitors. Its easy to use but that comes with the cost of processing, If you are using it just for batch processing then hive is well and fine.

What problems is Hive solving and how is that benefiting you?

Generating datasets from huge files for reporting purposes.

Enterprise (> 1000 emp.)
Jun 27, 2017
 Source
Overall Rating:
4.0
DS
Dhharvi S.
System Engineer
Share
"Big Data with SQL"
What do you like best about Hive?

Hive provides an ease to the user who wants to store bulk data, in a tabular manner. It works on the same queries like SQL, making it easy for using the traditional database system. Because of this reason, people need not have to study some new language and can still adapt to the Big Data Culture. Also it has features like partition, and bucketing, helping in segregation of data. Data can directly be loaded into hive, by HDFS, using the CSV files of the same format, or from Hbase by making a pointer to the Hbase table, providing a link within Hadoop.

What do you dislike about Hive?

For small amount of data also, it runs map reduce job, which consumes some time, and thus is not efficient for the same. We do not have a concept of primary key in Hive, so we can have redundant entries. Also till the older version, update and delete were not possible, and now also in the new version, if we want to use the update and delete commands, the performance of the tool gets degraded.

What problems is Hive solving and how is that benefiting you?

We are using Hive for storing logs, of data, being generated, in our business. Further we will be using these logs for reconciliation purpose, helping in keeping a track of data.

Mid Market (51-1000 emp.)
Jul 15, 2015
 Source
Overall Rating:
4.0
PS
Pavlo S.
Senior Software Engeneer
Share
"Hive as the base for BI tools to get data from Hadoop"
What do you like best about Hive?

The Hive is intended to simplify your experience with Hadoop and allows developers and business analyst apply their SQL knowledge to query data, build reports, build etl etc.

What do you dislike about Hive?

As the open source software it has common issues with support. Also Hive doesn't support many features that traditional SQL has.

What problems is Hive solving and how is that benefiting you?

The main purpouse of using Hive is to building reports and do analysis of data that is stored in the Hadoop file system. As for now it is the only one framework that can be used by all most popular BI tools to read the data from the HDFS.

Small Business (50 or fewer emp.)
Jul 09, 2015
 Source
Overall Rating:
4.0
AA
Anubhav A.
Big Data Engineer
Share
"Great distributed storage for hadoop"
What do you like best about Hive?

Ease of use as well as ability to scale. It has proven its reliability. They have continued to add more features and increased its speed at the same time.

What do you dislike about Hive?

Speed is still slower compared to newer distributed warehouses. Also, it still uses mapreduce behind the scene which is very slow in the present days.

What problems is Hive solving and how is that benefiting you?

Storing large amount of data that could not fit in to any relational database system. Being able to derive valuable insight into our data by running mapreduce jobs on data stored in Hive.

Enterprise (> 1000 emp.)
Jul 09, 2015
 Source
Overall Rating:
4.0
AM
Ankit M.
Software Developer
Share
"Active Hive user since last 2 years"
What do you like best about Hive?

The best part about hive is that it easy to master because of its SQL like interfacing. Also very handy tool for ETL and DW functions.

What do you dislike about Hive?

Not too good with setting up optimization parameters. Need to remember a lot of console settings. Index doesnt turn out to be very useful. CRUD functions have many pre-requisites like the table must be bucketed, etc.

What problems is Hive solving and how is that benefiting you?

we are trying to create a standard ETL pipelining tool that would support standard BI/Reporting utilities.

Mid Market (51-1000 emp.)
Jul 08, 2015
 Source
Overall Rating:
4.0
SC
Sanjeev C.
Director Of Engineering, Analytics
Share
"Hive is a great tool to have in a hadoop ecosystem, works great in generating parquet files"
What do you like best about Hive?

To be able to run map reduce jobs using json parsing and generate dynamic partitions in parquet file format.

What do you dislike about Hive?

It is slow compared to Spark/Impala for most operations. Also, it throws Out of Memory if multiple partitions are updated containing many parquet files.

What problems is Hive solving and how is that benefiting you?

Events are gathered in HDFS by flume and needs to be processed into parquet files for fast querying. The input data contains variable attributes in the json payload as each customer could define custom attributes. It is part of the ETL pipeline, where hive jobs read json data and generates parquet files that would be queried using impala/spark. Using views, each customer queries only the relevant data.

Enterprise (> 1000 emp.)
Apr 07, 2015
 Source
Overall Rating:
4.0
PS
Puneet S.
Software Engineer Ii
Share
"Hive Review"
What do you like best about Hive?

-> Easy to configure/create a table for Big data or Streaming data -> Fast and easy to Query. Business/non-technical folks can use HUE for more interactive Querying on Hive tables -> HUE can have saved results and old queries along with exporting results in Excell.CSV

What do you dislike about Hive?

-> Joining and parsing multiple tables with huge sizes still remain a challenge. -> Some of SQL operations doesn't work in hive like non equality joins,

What problems is Hive solving and how is that benefiting you?

Dumping Site activity Big Data streaming data as well as data logs in Hive

Small Business (50 or fewer emp.)
Jul 28, 2023
 Source
Overall Rating:
3.5
NG
Nishu G.
Test Engineer
Share
"Data warehouse"
What do you like best about Hive?

Open source framework allows to read and write and manage tha data like sql , HQl which makes it easy to use.

What do you dislike about Hive?

The latency in Apache hive is very high.

What problems is Hive solving and how is that benefiting you?

It provides SQL like query language called HQl with schema on read and transparently convert queries to map reduce.

Enterprise (> 1000 emp.)
Feb 16, 2023
 Source
Overall Rating:
3.5
BA
Balaji A.
Data Engineering Analyst
Share
"About Apache Hive"
What do you like best about Hive?

I like the most in Apache Hive supports partitioning and bucketing for fast data retrieval. We can create custom UDF as per the requirements to perform data cleansing and filtering. It supports HQL similar to SQL which gives easy for the people who comes from SQL background.

What do you dislike about Hive?

Doesn't support OLTP and also doesn't support delete or update actions.

What problems is Hive solving and how is that benefiting you?

We have created a semantic layer in Hive that helps us to process the terabytes of data and generate the reports faster. it also helped us fault tolerance and high availability of the data

Small Business (50 or fewer emp.)
Nov 10, 2022
 Source
Overall Rating:
3.5
Cherukumalli S. avatar
Cherukumalli S.
Administration
Share
"It works fine but needs improvements"
What do you like best about Hive?

Flexible and easy to understand loved it

What do you dislike about Hive?

Not compatible with multiple platforms hence mostly plotform depend

What problems is Hive solving and how is that benefiting you?

Works best with ETL related works or tasks

Enterprise (> 1000 emp.)
Aug 22, 2022
 Source
Overall Rating:
3.5
Aditya K. avatar
Aditya K.
Lead Software Engineer
Share
"Hive review"
What do you like best about Hive?

It is easy to run query in hive as hive uses hql which is very similar to sql. Hive has hivemetastore service to save the metadata and hiveserver2 to serve the client requests so the segregation here helps in proper resource distribution. Hive is also fault tolerant which makes it ideal to run ETL long running batches

What do you dislike about Hive?

Hive has a problem of cold start and since it used mapreduce algorithm at the backend, it is way slower than spark which made us move to spark from hive as the job completion time after switching to spark got reduced by 70-80%

What problems is Hive solving and how is that benefiting you?

Informatica data ingestion Abinitio data ingestion and modifications Data formatting (as it provides option such as csv,parauet etc) Data transformation using hive query Data pipelines

Enterprise (> 1000 emp.)
Jul 03, 2022
 Source
Overall Rating:
3.5
kirankumar k. avatar
Kirankumar K.
Big Data Engineer
Share
"Hive Review for big data"
What do you like best about Hive?

The friendliness of the data warehouse tool for the database developers

What do you dislike about Hive?

Not inclusion of acid properties, it doesn't have the acid properties as in the databases

What problems is Hive solving and how is that benefiting you?

I usually use hive for my big data [data migration problems], the speed at which the query operates, and the option to choose various engines

Enterprise (> 1000 emp.)
Apr 22, 2015
 Source
Overall Rating:
3.5
AB
Anusha B.
Teaching Assistant For Big Data Systems
Share
"Its good for Business Analysts and its good for pulling the data for analysis from Hadoop "
What do you like best about Hive?

If you know how to write sql statements you can write hiveql and it doesn't require you to learn anything new,its pretty straightforward

What do you dislike about Hive?

Performance tuning is difficult and becomes hard for complex queries, it still has a few bugs like all the data going to single reducer, which might lead to slow down the query results.

What problems is Hive solving and how is that benefiting you?

For developing reports for business analysts, lot of them know sql statements so its easy to write and pull information for analysis

Mid Market (51-1000 emp.)
Apr 02, 2015
 Source
Overall Rating:
3.5
AG
Abhishek G.
Senior Software Engineer
Share
"Works great for batch-processing large datasets"
What do you like best about Hive?

- Easy to learn - Can query complex data including nested structures. - Flexible (wrt data schema) - With ORC SerDe, I/O can be reduced drastically - by reading only what is required (columnar formats).

What do you dislike about Hive?

- Needs schema to be defined in prior. - Not ANSI SQL compliant. - Not suitable for fast interactive queries, even on moderate size datasets. - Works only with Hadoop (not an independent query-processing tool) - Not enterprise grade w.r.t quality of documentation, error messages, support

What problems is Hive solving and how is that benefiting you?

Exploring ways to store and process semantic datasets