IBM Netezza Performance Server vs. Hive

Integrates database, server, storage and analytics into a single system with petabyte scalability. Fast analytics Provides a high-performance, massively parallel system that enables you to gain insight from your data and perform analytics on very large data volumes. Smart, efficient queries Simplifies analytics by consolidating all activity in one place, where the data resides. Simplified infrastructure Easy to deploy and manage; simplifies your data warehouse and analytic infrastructure. Does not require tuning, indexing or aggregated tables and needs minimal administration.

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.