none
If we use Azure SQL Database as a Pass do we still required HIVE and Map-reduce for Big Data Analytic. RRS feed

  • Question

  • Hi All,

    If we use Azure SQL Database as a Pass do we still required HIVE and Map-reduce for Big Data Analytic. i hope if i use SQL server or Azure Table as Pass it is automatically Scaling.

    Regards,

    Manish

    Monday, June 13, 2016 6:24 AM

Answers

  • This depends entirely on your requirements for your Big Data Analytics system. There are usually 3 components of big data: Velocity, Variety, and Volume.

    For SQL DB

    Velocity:

    As an OLTP database, SQL Azure can handle very high velocity of data. However, it is not a streaming solution. If you want to run a persistent query over a stream of data you'll need azure stream analytics.

    Variety:

    The data needs to be relational. If you have semi-structured data it needs to be converted before.

    Volume:

    The largest Azure SQL Database has 1 TB of storage. If you need more, consider SQL DW which is a PaaS service designed for datawarehousing scenarios.

    Hope that helps.

    -Casey

    Monday, June 13, 2016 3:36 PM
    Moderator