DBMS > Hive vs. UniData,UniVerse
System Properties Comparison Hive vs. UniData,UniVerse
Please select another system to include it in the comparison.
Our visitors often compare Hive and UniData,UniVerse with Microsoft SQL Server, Oracle and IBM Db2.
|Editorial information provided by DB-Engines|
|Name||Hive Xexclude from comparison||UniData,UniVerse Xexclude from comparison|
|Description||data warehouse software for querying and managing large distributed datasets, built on Hadoop||MultiValue database and application server with SQL mapping layer and meta database capabilities|
|Primary database model||Relational DBMS||Multivalue DBMS|
|Developer||Apache Software Foundation initially developed by Facebook||Rocket Software|
|Current release||3.1.3, April 2022|
|License Commercial or Open Source||Open Source Apache Version 2||commercial|
|Cloud-based only Only available as a cloud service||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||All OS with a Java VM||AIX|
|Typing predefined data types such as float or date||yes||optional|
|SQL Support of SQL||SQL-like DML and DDL statements||yes|
|APIs and other access methods||JDBC|
|Java API JPA|
RESTful HTTP API
|Supported programming languages||C++|
Basic U2 Basic
|Server-side scripts Stored procedures||yes user defined functions and integration of map-reduce||yes|
|Triggers||no||yes U2 Basic|
|Partitioning methods Methods for storing different data on different nodes||Sharding||none|
|Replication methods Methods for redundantly storing data on multiple nodes||selectable replication factor||Source-replica replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes query execution via MapReduce||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency|
|Foreign keys Referential integrity||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID configurable|
|Concurrency Support for concurrent manipulation of data||yes||yes|
|Durability Support for making data persistent||yes||yes|
|User concepts Access control||Access rights for users, groups and roles||Access rights according to SQL-standard and operating system based|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Why is Hadoop not listed in the DB-Engines Ranking?
|Recent citations in the news|
Apache Hive. Apache Hive is an open-source data… | by Abinaya ...
Replacing Apache Hive, Elasticsearch and PostgreSQL with Apache ...
Metis: Building Airbnb's Next Generation Data Management Platform
Project Scheduling System Market 2023 Growth Drivers and Future ...
Cloudera creates observability tool to help enterprises manage ...
provided by Google News
Unidata uses Jetstream to make geoscience data available to ...
Unidata, admission to trading on Euronext Milan
Remote Monitoring System for Aquaculture Market 2031 Key ...
WA’s 170 DPIRD weather stations are in for an upgrade to 4G with minimal disruption for users expected
COVID-19 Impact Analysis of Water Level and Storage Monitoring ...
provided by Google News
Professional Services | Contract | Fulltime
Senior Data Engineer
Data Scientist - Battlefield
GCP Druid Sr. Engineer
FT Administrative Systems Manager/Student Systems
FT Student Services Data and Applications Analyst
Share this page