20th October 2020, Tuesday
 

Hive System Properties

Home > System Comparision

Hive System Properties

Please Choose another system to see its propertiess Click here

Editorial information provided by DB-Tools
 System Hive
  Db-Tools Ranking

Trend Rank   

Score : #12.34

Rank :  #4  Overall
       #2  Database
 Version 3.1.2
 Drawbacks Can run only on Hadoop with mapreduce
 Advantages A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported --
 Website https://hive.apache.org
 XML Support no
 JSON Support yes
 Brief description The Apache Hive data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive

The Apache Hive data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive

 Database Model Tabular Data Model
 Technical Documentation --
 License --
 Cloud-based / SaaS --
 Implementation Language C,C++
 Operating System Supported Linux, OS X,
 Options for Integration / Access API -
 Consistency Highly Consistent
 Foreign Keys No
 Streaming Support Yes
 Analytics Support --
 Data Storage Schema --
 Notable Users -
 Key Differentiator Probably most Widely used reporting database in big data ecosystem . Has a web front end
 Concurrency Yes
 Partitioning Yes
 Replication Yes
 Secondary Indexes Yes
 SchemaLess --
 SQL Query No