Difference between synapse and hdinsight

Shivam Ramola 71 Reputation points
2021-10-12T12:43:25.457+00:00

What are major difference between synapse and HD insight
and under what circumstances one should use synapse and vice versa

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,013 questions
Azure HDInsight
Azure HDInsight
An Azure managed cluster service for open-source analytics.
215 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MartinJaffer-MSFT 26,106 Reputation points
    2021-10-12T23:08:46.58+00:00

    Hello @Shivam Ramola and welcome to Microsoft Q&A.

    While both HDInsight and Synapse can run Spark, they are very different products.

    HDInsight is always on and requires a great deal of configuration. It is suitable for heavy compute where you have very detailed needs. The learning curve is very steep. Most of HDInsights features are Apache based. There are several cluster types to choose from depending upon your need. HDInsight has been around for a number of years.

    Synapse can be 'paused' , is consumption-based, and has a much more gentle learning curve. Synapse incorporates many other Azure services and is becoming a one-stop hub for Analytics and Data Orchestration. New features are being added faster than I can update this conversation.

    If all your intended users are very technically competent, HDInsight is worth considering. If some of your users are not as technically inclined, Synapse may appear more appealing.

    There is a new (preview) feature which allows some Synapse-HDInsight integrations. share-hive-metastore-with-synapse

    4 people found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.