DB-EnginesArangoDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Hive vs. Microsoft SQL Server vs. MySQL

System Properties Comparison Hive vs. Microsoft SQL Server vs. MySQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHive  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonMySQL  Xexclude from comparison
Descriptiondata warehouse software for querying and managing large distributed datasets, built on HadoopMicrosofts relational DBMSWidely used open source RDBMS
Primary database modelRelational DBMSRelational DBMSRelational DBMS infoKey/Value like access via memcached API
Secondary database modelsKey-value storeDocument store
Graph DBMS
Key-value store
Document store
Key-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score57.40
Rank#18  Overall
#11  Relational DBMS
Score1095.51
Rank#3  Overall
#3  Relational DBMS
Score1226.40
Rank#2  Overall
#2  Relational DBMS
Websitehive.apache.orgwww.microsoft.com/­en-us/­sql-serverwww.mysql.com
Technical documentationcwiki.apache.org/­confluence/­display/­Hive/­Homedocs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentationdev.mysql.com/­doc
DeveloperApache Software Foundation infoinitially developed by FacebookMicrosoftOracle infosince 2010, originally MySQL AB, then Sun
Initial release201219891995
Current release2.3.0, July 2017SQL Server 2017, October 20178.0.11, April 2018
License infoCommercial or Open SourceOpen Source infoApache Version 2commercial inforestricted free version is availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are available
Cloud-based infoOnly available as a cloud servicenonono
DBaaS offerings infoDatabase as a Service, sponsored linksGoogle Cloud SQL: A fully-managed database service for the Google Cloud Platform
Implementation languageJavaC++C and C++
Server operating systemsAll OS with a Java VMLinux
Windows
FreeBSD
Linux
OS X
Solaris
Windows
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yesyes
Secondary indexesyesyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsyesyes infowith proprietary extensions
APIs and other access methodsJDBC
ODBC
Thrift
OLE DB
Tabular Data Stream (TDS)
ADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
Supported programming languagesC++
Java
PHP
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reduceTransact SQL and .NET languagesyes infoproprietary syntax
Triggersnoyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingtables can be distributed across several files (horizontal partitioning); sharding through federationhorizontal partitioning, sharding with MySQL Cluster or MySQL Fabric
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryes, but depending on the SQL-Server EditionMaster-master replication
Master-slave replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReducenono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyes infonot for MyISAM storage engine
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID infonot for MyISAM storage engine
Concurrency infoSupport for concurrent manipulation of datayesyesyes infotable locks or row locks depending on storage engine
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlAccess rights for users, groups and rolesfine grained access rights according to SQL-standardUsers with fine-grained authorization concept infono user groups or roles

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

3rd party products and services
3rd partiesDremio is like magic for Hive accelerating your analytical queries up to 1,000x with Apache Arrow.
» more

Progress DataDirect: Data connectivity across standard SQL and REST
» more
Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

Alibaba Cloud - ApsaraDB for RDS: On-demand Database Hosting Service for MySQL, SQL Server and PostgreSQL.
» more

Progress DataDirect: Data connectivity across standard SQL and REST
» more

Dremio is like magic for SQL Server accelerating your analytical queries up to 1,000x.
» more

DBHawk is a web-based data management Tool for a SQL Server database.
» more
Dremio is like magic for MySQL accelerating your analytical queries up to 1,000x.
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

MONYOG: Monitor standard & hosted MySQL database servers.
» more

Progress DataDirect: Data connectivity across standard SQL and REST
» more

Alibaba Cloud - ApsaraDB for RDS: On-demand Database Hosting Service for MySQL, SQL Server and PostgreSQL.
» more

We invite representatives of 3rd party vendors to contact us for presenting information about their offerings here.

More resources
HiveMicrosoft SQL ServerMySQL
DB-Engines blog posts

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Conferences and events

PASS Summit 2018
Seattle, Washington, USA, 6-9 November 2018

Recent citations in the news

Big Data Information Access: Spark, Presto and Apache Hive (Oh My)
18 April 2018, ChannelE2E

Presto Use Surges, Qubole Finds
18 April 2018, Datanami

Here are five key things happening in the global Big Data market
19 April 2018, YourStory.com

Qubole Releases First Big Data Activation Report Highlighting How Today's Companies Are Putting Data Into Active Use
17 April 2018, GlobeNewswire (press release)

Celebrus Advances CDP Leadership Further With New Product Features
19 April 2018, MarTech Series

provided by Google News

Microsoft offers limited-time 30 percent discount on SQL Server on Linux
19 April 2018, ZDNet

SQL Server with Mr. Denny
23 April 2018, TechTarget

Get the MCSA SQL Server Certification Training Bundle for just $19
20 April 2018, Neowin

GeekDad Daily Deal: The MCSA SQL Server Certification Training Bundle
21 April 2018, GeekDad (blog)

Microsoft SQL Server
3 April 2018, TechTarget

provided by Google News

MySQL 8.0 now available
20 April 2018, SDTimes.com

Help Canonical Test GNOME Patches, Android Apps Illegally Tracking Kids, MySQL 8.0 Released and More
19 April 2018, Linux Journal

Database Administrator (MySQL)
3 April 2018, Built In Austin

Take the Hassle Out of MySQL and MariaDB Documenting with All-New dbForge Documenter for MySQL
21 April 2018, PR.com (press release)

Mysql selecting data from multiple table
19 April 2018, SitePoint

provided by Google News

Job opportunities

Data Engineer
McKinsey & Company, San Jose, CA

Data Engineer
Paycom, Oklahoma City, OK

Data Engineer
Boeing Intelligence & Analytics, Crystal City, VA

Data Engineer
John Hancock, Boston, MA

Data Engineer
Manulife Financial, Boston, MA

Senior Database Engineer
Visa, Bellevue, WA

SQL Database Developer
TableSafe Inc., Kirkland, WA

SQL BI Developer
Horizon Consulting, Redmond, WA

REF8352V - Senior MSSQL Staff Database Engineer
Visa, Bellevue, WA

Database Administrator
Seattle Seahawks, Renton, WA

Entry Level Back End Developer / DB Admin
Woodinville, WA, Woodinville, WA

Junior Analyst
Domino's, Ann Arbor, MI

Junior PHP Laravel Developer
Home Alliance, Los Angeles, CA

IT Web Developer
Gearbox Software, Frisco, TX

Entry Level Software Engineer
HCL America Inc., Redmond, WA

jobs by Indeed




Share this page

Featured Products

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

Neo4j logo

New to the world of graph databases? Become an expert today with your copy of the Graph Databases for Beginners ebook.

Datastax logo

Datastax delivers Apache Cassandra as part of a database platform purpose built for IOT, Web and Mobile Apps. Download now.

RavenDB logo

.NET & Linux,
try the next level in performance with RavenDB 4.0 where Speed meets ACID.
Free download.

Present your product here