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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

-> 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 Review collected by and hosted on G2.com.

-> 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, Review collected by and hosted on G2.com.

The SQL-like syntax makes it easy to use Review collected by and hosted on G2.com.

Its reliance on mapreduce makes it sometimes very slow even for a simple task Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Unable to cancel a running query.

Query tuning is difficult compared to RDBMS Review collected by and hosted on G2.com.

The progression of features, speed, etc brings me the strategic confidence I need in the SQL in hadoop space. Review collected by and hosted on G2.com.

At this point, everything is on pint & theories it is great in hive 1.2 Review collected by and hosted on G2.com.

Hive has a simple and intuitive interface and gets the job done. Review collected by and hosted on G2.com.

So far Hive has met and exceeded all my expectations. Review collected by and hosted on G2.com.

The best part is being able to use a familiar syntax. Review collected by and hosted on G2.com.

Doesn't support all MYSQL use-cases (understandably). Review collected by and hosted on G2.com.

Hive can tell us the detailed progress of a query, and can incorporate UDFs in different languages Review collected by and hosted on G2.com.

The query speed is way to slow, and it does not support positional arguments in GROUP BY and ORDER BY Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

As with all Hadoop tools lots of knobs to tweak. Takes a good bit of time optimize and finely tune your Hive install. Review collected by and hosted on G2.com.

hiveql is more like SQL and really easy to learn Review collected by and hosted on G2.com.

doesnt work good if you want a low latency queries Review collected by and hosted on G2.com.