Query Big Data using the expanded T-SQL footprint with Polybase in SQL Server 2016
With the growth of connected devices and IOT, there has been a boom in semi-structured data stored in Hadoop that can be used to complement existing relational data stored in Microsoft SQL Server. With the combination of these two datasets, businesses can make smarter decisions faster. In the past, combining these two disjoint datasets required ETL jobs to move the data from one system to another; however, with PolyBase things have changed. Using PolyBase in SQL 2016, you can query both data in SQL Server and Hadoop with T-SQL.N.