Hadoop vs Microsoft SQL Server

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Hadoop
Hadoop

1K
826
+ 1
48
Microsoft SQL Server
Microsoft SQL Server

3.6K
2.5K
+ 1
520
Add tool

Hadoop vs Microsoft SQL Server: What are the differences?

Developers describe Hadoop as "Open-source software for reliable, scalable, distributed computing". The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage. On the other hand, Microsoft SQL Server is detailed as "A relational database management system developed by Microsoft". Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

Hadoop and Microsoft SQL Server can be primarily classified as "Databases" tools.

"Great ecosystem" is the top reason why over 34 developers like Hadoop, while over 134 developers mention "Reliable and easy to use" as the leading cause for choosing Microsoft SQL Server.

Hadoop is an open source tool with 9.26K GitHub stars and 5.78K GitHub forks. Here's a link to Hadoop's open source repository on GitHub.

According to the StackShare community, Microsoft SQL Server has a broader approval, being mentioned in 478 company stacks & 443 developers stacks; compared to Hadoop, which is listed in 237 company stacks and 127 developer stacks.

- No public GitHub repository available -

What is Hadoop?

The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Hadoop?
Why do developers choose Microsoft SQL Server?

Sign up to add, upvote and see more prosMake informed product decisions

What are the cons of using Hadoop?
What are the cons of using Microsoft SQL Server?
    Be the first to leave a con
    What companies use Hadoop?
    What companies use Microsoft SQL Server?

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Hadoop?
    What tools integrate with Microsoft SQL Server?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Hadoop and Microsoft SQL Server?
    Cassandra
    Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
    MongoDB
    MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
    Elasticsearch
    Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
    Splunk
    Splunk Inc. provides the leading platform for Operational Intelligence. Customers use Splunk to search, monitor, analyze and visualize machine data.
    HBase
    Apache HBase is an open-source, distributed, versioned, column-oriented store modeled after Google' Bigtable: A Distributed Storage System for Structured Data by Chang et al. Just as Bigtable leverages the distributed data storage provided by the Google File System, HBase provides Bigtable-like capabilities on top of Apache Hadoop.
    See all alternatives
    Decisions about Hadoop and Microsoft SQL Server
    No stack decisions found
    Interest over time
    Reviews of Hadoop and Microsoft SQL Server
    No reviews found
    How developers use Hadoop and Microsoft SQL Server
    Avatar of Pinterest
    Pinterest uses HadoopHadoop

    The MapReduce workflow starts to process experiment data nightly when data of the previous day is copied over from Kafka. At this time, all the raw log requests are transformed into meaningful experiment results and in-depth analysis. To populate experiment data for the dashboard, we have around 50 jobs running to do all the calculations and transforms of data.

    Avatar of Brillium, Inc.
    Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

    We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

    Avatar of Yelp
    Yelp uses HadoopHadoop

    in 2009 we open sourced mrjob, which allows any engineer to write a MapReduce job without contending for resources. We’re only limited by the amount of machines in an Amazon data center (which is an issue we’ve rarely encountered).

    Avatar of Andrew Miller
    Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

    Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

    Avatar of Pinterest
    Pinterest uses HadoopHadoop

    The massive volume of discovery data that powers Pinterest and enables people to save Pins, create boards and follow other users, is generated through daily Hadoop jobs...

    Avatar of David Flynn
    David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

    Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

    Avatar of Olo
    Olo uses Microsoft SQL ServerMicrosoft SQL Server

    Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

    Avatar of Robert Brown
    Robert Brown uses HadoopHadoop

    Importing/Exporting data, interpreting results. Possible integration with SAS

    Avatar of Rohith Nandakumar
    Rohith Nandakumar uses HadoopHadoop

    TBD. Good to have I think. Analytics on loads of data, recommendations?

    Avatar of Arbor Health, LLC
    Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

    Managing script output and input, as well as data cleansing.

    How much does Hadoop cost?
    How much does Microsoft SQL Server cost?
    Pricing unavailable
    Pricing unavailable