Overall Satisfaction with Apache Hive
I have used Hive at an enterprise company where I interned. It was being used by the IT department to improve analysis of large datasets stored in the company's Hadoop HDFS. It was also being used because of its support for HiveQL which is a SQL like language enabling queries on large datasets. It also reduced the learning curve for handling big data because of HiveQL's similarity to SQL.
- Supports SQL like queries
- Various storage types including RCFile, HBase, ORC, etc.
- Supports indexing for acceleration
- HiveQL does not have all the features of SQL
- No support for transactions
- Reduced learning curve for new trainees and users
- Support for other client server databases provided improved compatibility of systems
Using Apache Hive
Pros | Cons |
---|---|
Like to use Relatively simple Easy to use Well integrated Consistent Quick to learn Convenient Feel confident using | Requires technical support Lots to learn |