Create entry

Hive vs. MySQL

Hive MySQL + Add column
Apache Hive MySQL
Category
Preference 50% votes 50% votes
Website hive.​apache.​org www.​mysql.​com
License
Design
Database model
Data storage
Embeddable Yes Yes
Features
Query language
Data types ?
Conditional entry updates ? Yes
Map and reduce Yes No
Unicode Yes Yes
TTL for entries ? No
Compression Yes Yes
Integrity
Integrity model ?
Atomicity ? Yes
Consistency ? Yes
Isolation ? Yes
Durability (data storage) ? Yes
Transactions ? Yes
Referential integrity ? Yes
Revision control ? Yes
Locking model ?
Indexing
Secondary Indexes ? Yes
Composite keys ? Yes
Full text search ? Yes
Geospatial Indexes No Yes
Graph support ? No
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding Yes Yes
Shared nothing architecture ? Yes
Restrictions
Value size max. ? 10 B
System requirements
Operating system
Native driver
Memory minimum ? 11 MB
Architecture
Programming language
More
Description Big Data Relational database system
Brand
Multi-user system Yes Yes
Software distribution
Free to use Yes Conditional
Active Yes Yes
Real time analytics Yes Conditional
Ease of use ★★★☆☆ ★★★★★
In-Place Update No Yes
Free for commercial use Yes Yes
Open Source Yes Yes
Extension/Plug-in ? Yes
Database ?
Multilingual content ? Yes
Price rating ? ★★★★☆
WYSIWYG-Editor ? No
Standard compliance ? Yes
Object-Relational Mapping (ORM) ? Yes
Documentation level ? ★★★★☆
RESTful ? No
Lines of code ? 1 100 k
Database Connection Pooling ? Yes
Community Driven ? Good
Web interface ? Yes
Cloud platform support ?
Online backup ? Yes
Partial Index ? No
Function Based Index ? No
Key length max ? 255
Log ? Yes
Implementation flexibility (0% global votes) (0% global votes)
Download ? dev.​mysql.​com/​downloads/​
Backup functionality ? Basic
Query Cache ? Yes
Sorts ? Yes
Tuneable write concerns ? Yes
Triggers ? Yes
Perfomance ? ★★★★☆
Multivariate Testing ? No
Pipeline Aggregation ? Yes
Spring Data Support ? Yes
Geospatial ? Yes
Text Analytics ? Yes
Server Side Java Script ? No
JSON ? No
Flexible Table(Schema) ? No
Max rows in query result ? 40 000
Stored Procedure ? Yes
+ Add row ++
Hive MySQL
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    darker
    = better
    Legend
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.

Type
Review
Comment