DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Hive vs. Microsoft Azure Table Storage vs. Spark SQL

System Properties Comparison Hive vs. Microsoft Azure Table Storage vs. Spark SQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHive  Xexclude from comparisonMicrosoft Azure Table Storage  Xexclude from comparisonSpark SQL  Xexclude from comparison
Descriptiondata warehouse software for querying and managing large distributed datasets, built on HadoopA Wide Column Store for rapid development using massive semi-structured datasetsSpark SQL is a component on top of 'Spark Core' for structured data processing
Primary database modelRelational DBMSWide column storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score77.89
Rank#17  Overall
#11  Relational DBMS
Score5.62
Rank#74  Overall
#5  Wide column stores
Score20.62
Rank#36  Overall
#22  Relational DBMS
Websitehive.apache.orgazure.microsoft.com/­en-us/­services/­storage/­tablesspark.apache.org/­sql
Technical documentationcwiki.apache.org/­confluence/­display/­Hive/­Homespark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperApache Software Foundation infoinitially developed by FacebookMicrosoftApache Software Foundation
Initial release201220122014
Current release3.1.3, April 20223.3.0 ( 2.13), June 2022
License infoCommercial or Open SourceOpen Source infoApache Version 2commercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScala
Server operating systemsAll OS with a Java VMhostedLinux
OS X
Windows
Data schemeyesschema-freeyes
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.nono
Secondary indexesyesnono
SQL infoSupport of SQLSQL-like DML and DDL statementsnoSQL-like DML and DDL statements
APIs and other access methodsJDBC
ODBC
Thrift
RESTful HTTP APIJDBC
ODBC
Supported programming languagesC++
Java
PHP
Python
.Net
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Java
Python
R
Scala
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reducenono
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoImplicit feature of the cloud serviceyes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryes infoimplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.none
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReduceno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanooptimistic lockingno
Concurrency infoSupport for concurrent manipulation of datayesyesyes
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.nono
User concepts infoAccess controlAccess rights for users, groups and rolesAccess rights based on private key authentication or shared access signaturesno

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.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
HiveMicrosoft Azure Table StorageSpark SQL
DB-Engines blog posts

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

show all

Recent citations in the news

Data Management News for the Week of November 25; Updates from Equalum, Safe Software, SnapLogic & More
23 November 2022, Solutions Review

Caltech's ML algorithm can classify 1000 supernovae
1 December 2022, INDIAai

Okera Works to Solve the File Data Access Management Challenge with New Solution
16 November 2022, Datanami

Top 10 Modern AWS Tools that Stormed the Tech Industry in 2022
24 November 2022, Analytics Insight

Global Open-Source Database Software Market Size and Overview Analysis 2022 by Market Dynamics, Emerging Trends, Opportunities and Forecast to 2025
18 November 2022, Digital Journal

provided by Google News

How to use Azure Table storage in .Net
14 January 2019, InfoWorld

How to write data to Azure Table Store with an Azure Function
14 April 2017, Experts Exchange

What is Microsoft Azure and How it works, Azure Cloud Services, Demystifying Cloud Series by Satyen Kumar
16 June 2022, satyenkumar.medium.com

AWS Vs Azure Vs Google Cloud - Which cloud platform should you choose for your enterprise?
12 September 2022, Appinventiv

Microsoft Announces PostgreSQL Option for Cosmos DB
12 October 2022, thenewstack.io

provided by Google News

Mobilize.Net Announces PySpark (Spark Python) to Snowpark Code Conversion Tool
16 November 2022, PR Newswire

Senior Big Data Engineer - Remote in Weehawken, NJ, USA - Apply Today!
2 December 2022, EPAM

Tellius Announces Latest Version of Its Decision Intelligence Platform
9 November 2022, Datanami

A Deep Dive into Custom Spark Transformers for ML Pipelines
27 July 2022, CrowdStrike

Job Update: Computer Science Graduates, Postgraduates Vacancy at Salesforce
26 November 2022, StudyCafe

provided by Google News

Job opportunities

Hive Developer
Cognizant, Hartford, CT

Data Scientist
MARS, Newark, NJ

ODDA Data Scientist Analyst
MARS, Newark, NJ

Data Scientist
MARS, Chicago, IL

Marketing Data Engineer
MARS, Newark, NJ

Azure Developer
Brillio, Edison, NJ

Staff Software Engineer - Geo Spatial Storage (GSS) Platform
Raven Applied Technology Div, Sioux Falls, SD

Office 365, Azure Consultant
Canviz, Kirkland, WA

Application Architect
DMI, Remote

Sr Software Engineer - HIE Azure (6269)
Altera Digital Health, New Hyde Park, NY

Data Scientist
Saatchi & Saatchi Wellness, New York, NY

GIS Specialist
Huntington, Columbus, OH

Global Data Architect
Otis, Farmington, CT

Senior Hadoop Spark Developer (Remote)
cloudteam, Jacksonville, FL

Machine Learning Scientist
PayPal, Scottsdale, AZ

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Redis logo

The world’s most loved real‑time data platform.
Try free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Present your product here