Help the communities most affected by the California wildfires in only a few minutes. We'll donate $10 for every review you submit.

Hive

4.2
(31)

Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. At the same time this language also allows traditional map/reduce programmers to plug in their custom mappers and reducers when it is inconvenient or inefficient to express this logic in HiveQL.

Work for Hive?

Learning about Hive?

We can help you find the solution that fits you best.

Find the Right Product

Hive Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 34 Hive reviews
LinkedIn Connections
Hive review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source

"Hive is useful but can be quirky"

What do you like best?

The best thing about HIVE is that anyone that is familiar with SQL can take advantage of HIVE's ability to run map reduce jobs. Newer version of HIVE is getting better at supporting windowing functions and fleshing out any inconsistencies. So far the documentation is good enough for getting me through my tasks and there is still on-going support for this product, which is a pretty good sign to me.

What do you dislike?

Older versions of HIVE sucks. There are lots of limitations that will force you to write HiveQL queries that are not straight forward and, even potentially, inefficient. For example, no support for window functions and no equality comparisons on joins can make your life very difficult so you will need to fall back to using some whacky full joins or self joins to accomplish the same task.

What business problems are you solving with the product? What benefits have you realized?

We are using HIVE as a data warehouse. One of the benefits of HIVE is that it can break your SQL queries into a series of map reduce jobs, so its supposed to speed up your queries if given enough compute nodes.

Sign in to G2 Crowd to see what your connections have to say about Hive
Hive review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Hive review for its use in big data applications"

What do you like best?

Hive is great for handling logs in big data projects. We are using the same in our project and it is great for using joins and grouping which is very difficult and tricky in map reduce. It has a lot of udf packages and it is very easy to add new udfs. We were also using bucketing and clustering to optimize the query. Concept of external tables and the way we can manipulate data even when table is deleted from hive is really amazing. Lot of connectors available in the market for different softwares.

What do you dislike?

The thing which I dislike is latency and the way it saves data. While inserting data I have to wait a lot of few records. Compiler execution plan is very immature as it does not do proper query optimization. Though the community is working fast for overcoming quickly but I think it will take time for hive to be

Recommendations to others considering the product

Yes, I would highly recommend this product as this helps to solve a lot of problems mainly for logs. It has lots of connectors and so compatibility issues are not there. You can use it with hbase , tableau etc.

So, its worth using.

What business problems are you solving with the product? What benefits have you realized?

We are using hive mainly for saving our logs. it helps us to keep track of what records are inserted, which records have failed and what are relationship between them. we are using tableau for analyzing data .

What Other Non-Relational Databases solution do you use?

Thanks for letting us know!
Hive review by Dhharvi S.
Dhharvi S.
Validated Reviewer
Review Source

"Big Data with SQL"

What do you like best?

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?

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.

Recommendations to others considering the product

For storing bulk amount of data in a tabular manner, and where there's no need need of primary key, or just in case, if redundant data is received, it will not cause a problem.

What business problems are you solving with the product? What benefits have you realized?

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.

Hive review by User in Higher Education
User in Higher Education
Validated Reviewer
Review Source

"HIve Review - Data Science Perspective"

What do you like best?

Hive is the best out there for answering ad-hoc queries in parallel paradigm. It works very well with Hadoop Echo system (mainly integrates perfectly with HDFS).

- Easy to use as it implements most of SQL functions.

What do you dislike?

- Needs more optimization for complex queries (like caching, auto-partitioning,etc ...) to speed up the latency of the queries.

- Tuning the hive parameters is really challenging for the users. The default settings don't work with the large queries.

- Hive is perfect if 90-95% of the queries are read-only. It is not suitable for applications with heavily updates

What business problems are you solving with the product? What benefits have you realized?

Get quick insights from big data in case of the customers' data don't fit on one machine. It helps a lot for data preparation (i.e. creating temporary tables), that can be consumed by other machine learning solutions like Spark to build machine learning models that add more business values.

Hive review by Pavlo S.
Pavlo S.
Validated Reviewer
Verified Current User
Review Source

"Hive as the base for BI tools to get data from Hadoop"

What do you like best?

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?

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

Recommendations to others considering the product

The Hive and Hadoop is not a database in classical understanding, and the purpouse is to proceed the big volumes of data. But in case you'll try to query some small table you'll notice that it can take x1000 more time to get resulting the data.

Hive doesn't work with single record and it should not be considered as persisnent arrea for biling like systems.

What business problems are you solving with the product? What benefits have you realized?

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.

Hive review by Pradeepkumar K.
Pradeepkumar K.
Validated Reviewer
Verified Current User
Review Source

"For all the batch operations!"

What do you like best?

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?

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.

Recommendations to others considering the product

If you are looking for some easy to use big data product to run queries and generate reports on batch mode then Hive is the tool!

What business problems are you solving with the product? What benefits have you realized?

Generating datasets from huge files for reporting purposes.

Hive review by Sanjeev C.
Sanjeev C.
Validated Reviewer
Verified Current User
Review Source

"Hive is a great tool to have in a hadoop ecosystem, works great in generating parquet files"

What do you like best?

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

What do you dislike?

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.

Recommendations to others considering the product

Explore other tools like Spark also as many of the features that Hive does is now supported by Spark.

What business problems are you solving with the product? What benefits have you realized?

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.

Hive review by Kevin P.
Kevin P.
Validated Reviewer
Review Source

"Easy intro to big data"

What do you like best?

Ease to get started. Leverages sql knowledge. Has reasonable documentation. Fast to write queries.

What do you dislike?

Documentation sparse in some areas such as datetime formats. Queries run slowly and often fail to complete.

Recommendations to others considering the product

Hive is good for running quick ad hoc queries and performing simple preprocessing.

What business problems are you solving with the product? What benefits have you realized?

Preprocessing for machine learning pipeline. Running ad hoc queries on customer databases to generate high level summaries.

Hive review by Bharadwaj (Brad) C.
Bharadwaj (Brad) C.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"One among many to do ETL"

What do you like best?

Hive syntax is almost like sql, so for someone already familiar with sql it takes almost no effort to pick up hive. But there are other tools that can do the same thing faster these days. Hive initially was really good to have; but more and more projects are now available to do SQL like operations on Big Data (like Drill).

What do you dislike?

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. It also does not have as rich of a scripting language.

Recommendations to others considering the product

Have better tools if you invest some more time/effort

What business problems are you solving with the product? What benefits have you realized?

In Retail, the business partners are more comfortable querying their own data instead of relying on Engineers. Hive solves one of that problems. The main purpouse of using Hive is to building reports and do analysis of data that is stored in the Hadoop file system.

Hive review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Great tool for quick analyses"

What do you like best?

Hive syntax is almost exactly like sql, so for someone already familiar with sql it takes almost no effort to pick up hive. It can perform a wide variety of analyses over very large sets of data and requires very little tuning if you are willing to wait a while for the results.

What do you dislike?

Hive can be a bit slow in comparison to other languages like Pig. It also does not have as rich of a scripting language. This is what makes it the second choice language for most data analysis jobs at LinkedIn.

Recommendations to others considering the product

I'd take a look at the user forums to see all the newest additions to Hive and I'd also consider whether your main use-case is scripting vs on-off analyses. I primarily use hive (so do many devs) to do our analyses since hive is trivially simple to use and it does pretty much everything sql will do, but it's not great for scripts and loading data into files, so if that is your use-case I'd consider looking into other options.

What business problems are you solving with the product? What benefits have you realized?

We are trying to mine data from massive data sets for a wide variety of purposes (debugging production issues, creating business metrics, models, and forecasts among other things). We have been able to do this very easily using our data warehouse and a combo of hive and Pig.

Hive review by Pengcheng X.
Pengcheng X.
Validated Reviewer
Review Source

"Hive is easy to scale."

What do you like best?

Hive is one of the Apache projects. it is a data warehouse software which facilitates querying and managing large datasets residing in distributed storage. It provides a way to enable easy data extract/transform/load (ETL)

Some of the nice features include (1) a simple SQL-like query language, called HiveQL, that enables users familiar with SQL to query the data. But it is a bit different from SQL standard. For example, HiveQL can also be extended with custom scalar functions (UDF's), aggregations (UDAF's), and table functions (UDTF's). (2) You can define your own read or written data format called Hive SerDe. (3) Hive can be run on Hadoop and HDFS. It has very good scalability.

Personally speaking, I use hive mainly for ad hoc quires and reports. For BI reports Hive is the best since you can reuse all the SQL that you have done for traditional data warehouses. Also with Hive Server2 you get a real JDBC support so you can plug your BI tools to it. Many more SQL features like cubes, rollups, windowing, lag, lead, etc are being added to Hive through Hortonworks Stinger initiative. Hive also produces very compact code, which is always good for reading and debugging.

What do you dislike?

Too large code base. It is hard to maintain and support. And, there are too many configurations. If you take a look at the HiveConf.java, you will be confused with so many configurations there. It is easy to get lost when you configure them. And, if you configure some of them in a wrong way, you may suffer from bad query performance.

Recommendations to others considering the product

Strongly recommend.

What business problems are you solving with the product? What benefits have you realized?

We are developing Hive. Hive is part of our product

Hive review by Industry Analyst / Tech Writer in Consumer Services
Industry Analyst / Tech Writer in Consumer Services
Validated Reviewer
Verified Current User
Review Source

"Use it most of the time working with big data"

What do you like best?

It is very simple to use because you fill like you use simple SQL language for querying data.

When I just started I didn't have any experience with Hive and in like one week I was able to query big data and do some analysis. In a month I was able to administrate data and create my own databases with the useful data. . .

What do you dislike?

Not so many implemented functions in the Hive. There are very useful Window functions but it's not enough. . .

It's not that simple to modify data inside a table. . .

Recommendations to others considering the product

Keep your big data on hdfs and setup Hive there.

It's very easy to use and very helpful especially for new users or someone who just started with big data.

. . . . . . . . . . . . . .

What business problems are you solving with the product? What benefits have you realized?

Analyze every day and every hour or even every minute user experience, user behavior in application or web client , etc . . .

Hive review by Abhishek G.
Abhishek G.
Validated Reviewer
Verified Current User
Review Source

"Works great for batch-processing large datasets"

What do you like best?

- 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?

- 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

Recommendations to others considering the product

I only explored this for a personal project in school. Hence this is only a personal view. It's surely good to try out and see for yourself.

What business problems are you solving with the product? What benefits have you realized?

Exploring ways to store and process semantic datasets

Hive review by Anubhav A.
Anubhav A.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Great distributed storage for hadoop"

What do you like best?

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?

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.

Recommendations to others considering the product

Its great but do not use for real time application.

What business problems are you solving with the product? What benefits have you realized?

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.

Hive review by Anusha B.
Anusha B.
Validated Reviewer
Verified Current User
Review Source

"Its good for Business Analysts and its good for pulling the data for analysis from Hadoop "

What do you like best?

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?

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.

Recommendations to others considering the product

Use latest versions of hive, its faster and better for big data analysis

What business problems are you solving with the product? What benefits have you realized?

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

Hive review by Internal Consultant in Internet
Internal Consultant in Internet
Validated Reviewer
Verified Current User
Review Source

"Excellent Batch Query Tool"

What do you like best?

Stable product; Easy to use; Multiple computation engines - Tez, MR; Almost all SQL capabilities;

What do you dislike?

Delete support is still not there even though they are nearly there.

Recommendations to others considering the product

Hive is production ready for all batch queries. But it has more flags than UN building :)

What business problems are you solving with the product? What benefits have you realized?

Primary Querying engine for Data Analytics

Hive review by Prabir G.
Prabir G.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"I am a Premier Support Engineer for Hortonworks. I install, support, and use Hive heavily."

What do you like best?

1) ability to handle PetaByte scale of data

2) ability to work with near SQL query language

3) schema on read capibility

What do you dislike?

1) optimizer technology is still maturing

Recommendations to others considering the product

For the right use cases, there is practically no alternative

What business problems are you solving with the product? What benefits have you realized?

1) handling huge datasets

2) handling semi-structured and structured data sets with the same tool

Hive review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source

"Fast Queries for BI use cases"

What do you like best?

Provides quick results based on a hadoop database, easy to use interface with simple set up steps

What do you dislike?

Some quirks with HiveQL may require referencing the documentation, but there is a lot of similarity with other SQL based languages.

What business problems are you solving with the product? What benefits have you realized?

Data analytics, making vast amounts of data available for general BI uses

Hive review by Siyu Y.
Siyu Y.
Validated Reviewer
Verified Current User
Review Source

"Why I don't like Hive as much (as Pig)"

What do you like best?

Easy SQL like syntax for very short and simple queries

What do you dislike?

No alias for relation. No flow controls as well.

What business problems are you solving with the product? What benefits have you realized?

I build machine learning model for online advertising system. Hive to me is more like a ad-hoc query engine rather than a platform where I can develop complex algorithm on

Hive review by Ankit M.
Ankit M.
Validated Reviewer
Review Source

"Active Hive user since last 2 years"

What do you like best?

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?

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 business problems are you solving with the product? What benefits have you realized?

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

Hive review by User in Higher Education
User in Higher Education
Validated Reviewer
Review Source

"Query Language for Hadoop"

What do you like best?

Hadoop does not have native query language, but Hive is a great addition to use on top of hadoop. I could point to a data stored in hadoop to a specific table and could use normal queries like I usually do in SQL. We can join and do aggregations etc.

Makes life pretty simple.

What do you dislike?

It can be very slow as it runs on map reduce jobs underneath. Data cannot be updated but we will have to do a rewrite.

Recommendations to others considering the product

If you want SQL like data queries in Hadoop and big data, Hive is the way to go.

What business problems are you solving with the product? What benefits have you realized?

For people who are used to write SQL queries would have a very good time using Hive on top of hadoop for files stored in HDFS.

Hive review by Puneet S.
Puneet S.
Validated Reviewer
Review Source

"Hive Review"

What do you like best?

-> 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?

-> 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 business problems are you solving with the product? What benefits have you realized?

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

Hive review by Daryl R.
Daryl R.
Validated Reviewer
Review Source

"It was wonderful! "

What do you like best?

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

What do you dislike?

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 business problems are you solving with the product? What benefits have you realized?

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.

Hive review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"A Great Way to Put Structure on Your Unstructured Data"

What do you like best?

If you know SQL you will be able to get Hive really quickly. Lots of the same functionality but not exactly SQL. Easy to create tables and start writing queries allowing you to dive deeper into your data.

What do you dislike?

As with all Hadoop tools lots of knobs to tweak. Takes a good bit of time optimize and finely tune your Hive install.

Recommendations to others considering the product

If you need to build a data warehouse on lots of data and don't want to pay for the likes of terradata or sql server, Hive is your tool.

What business problems are you solving with the product? What benefits have you realized?

Putting structure on unstructured. Once we chose hive to accomplish the aforementioned task we were able to bring our data to our data scientists quickly. An easier degree of acceptance to the Big Data idea.

Hive review by Administrator in Internet
Administrator in Internet
Validated Reviewer
Review Source

"Used as a way for Data Scientists to easily query HDFS data"

What do you like best?

The ability to view HDFS data in a relational format and easily query it through HiveQL

What do you dislike?

The fact that it uses MapReduce whether you query a pre existing table or a perform a complex query. Tez helps with this issue. Also the inability to delete/update data is a real issue and forces other services to be used eg HBase.

Recommendations to others considering the product

Index index index!

What business problems are you solving with the product? What benefits have you realized?

The ability to use Hive on HUE is perfect. We are building a platform for data scientists (prefer GUI to shell) to perform analysis so removing the need for command line is excellent.

Hive review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Hive - Scalable Query Language for Hadoop"

What do you like best?

performing SQL-like queries, Partitioning Tables, De-normalizing data, Compress map/reduce output are best benefits

What do you dislike?

For some cases you cannot do complicated operations using Hive e.g. when output of one job acts as input to the other job (SequenceFileFormat file) or writing query on an image file, Hive is not useful.

What business problems are you solving with the product? What benefits have you realized?

Hive helps in resolving big data problems

Hive review by Consultant in Education Management
Consultant in Education Management
Validated Reviewer
Review Source

"Hive Review"

What do you like best?

Apache Hive is a tool built on top of Hadoop for analyzing large, unstructured data sets.

Most BI and SQL developer tools can connect to Hive as easily as to any other database.

What do you dislike?

Unable to cancel a running query.

Query tuning is difficult compared to RDBMS

What business problems are you solving with the product? What benefits have you realized?

We had a requiement to scan a large dataset for our predection algorithm. Initially we used RDBMS but the performace was very slow and user where not happy with it. We replaced RDBMS with the Hive and we are able to see a drastic improvment in the performance.

Hive review by User
User
Validated Reviewer
Review Source

"Hive gives you flexibility to query data in hadoop"

What do you like best?

Leverage sql skills to perform operations on data stored in hadoop.

What do you dislike?

Works on map reduce algorithm, so the retrieval of data is a little slow.

What business problems are you solving with the product? What benefits have you realized?

Allowed business users to query data using sql skills.

Hive review by Jiahong Z.
Jiahong Z.
Validated Reviewer
Review Source

"Makes it easy to query large datasets"

What do you like best?

The SQL-like syntax makes it easy to use

What do you dislike?

Its reliance on mapreduce makes it sometimes very slow even for a simple task

What business problems are you solving with the product? What benefits have you realized?

Run specific queries on hadoop files

Hive review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Verified Current User
Review Source

"best for batch processing"

What do you like best?

hiveql is more like SQL and really easy to learn

What do you dislike?

doesnt work good if you want a low latency queries

What business problems are you solving with the product? What benefits have you realized?

performance for 1TB of data

Hive review by User in Computer Software
User in Computer Software
Validated Reviewer
Review Source

"Hive makes query on HDFS much easier, but not optimized nor fast enough"

What do you like best?

Hive can tell us the detailed progress of a query, and can incorporate UDFs in different languages

What do you dislike?

The query speed is way to slow, and it does not support positional arguments in GROUP BY and ORDER BY

Recommendations to others considering the product

Speed, speed, speed

What business problems are you solving with the product? What benefits have you realized?

We use Hive to run our nightly workflows on HDFS in batch for data aggregation and analysis.

Hive review by Consultant in Computer Software
Consultant in Computer Software
Validated Reviewer
Review Source

"Great experience!"

What do you like best?

The progression of features, speed, etc brings me the strategic confidence I need in the SQL in hadoop space.

What do you dislike?

At this point, everything is on pint & theories it is great in hive 1.2

What business problems are you solving with the product? What benefits have you realized?

Deriving value from masses of unstructured & structured data.

Hive review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Used Hive for a Hadoop project"

What do you like best?

Hive has a simple and intuitive interface and gets the job done.

What do you dislike?

So far Hive has met and exceeded all my expectations.

What business problems are you solving with the product? What benefits have you realized?

Working on a Hadoop system to determine recruiters that are spamming members too much.

Hive review by User in Internet
User in Internet
Validated Reviewer
Review Source

"SQL-like syntax makes it easy to use."

What do you like best?

The best part is being able to use a familiar syntax.

What do you dislike?

Doesn't support all MYSQL use-cases (understandably).

What business problems are you solving with the product? What benefits have you realized?

Ad-hoc queries on ETL'd production data.

Kate from G2 Crowd

Learning about Hive?

I can help.
* We monitor all Hive reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.