With data acquisition, we frequently face situations when data is not available in the SQL Server, and for our analysis, we usually import or query data from various other database platforms or other systems. SQL Server 2016 has introduced a new feature called PolyBase, which can help us with accessing external data from the SQL Server. PolyBase is able to access Hadoop-type file systems to query external data and to push the computation to Hadoop so that the SQL Server does not get overloaded while accessing large amounts of data.
The great benefit of PolyBase is the unification of two very different worlds: structured data and unstructured data. Hadoop is a collection of open source utilities, which includes a distributed file system called hdfs. This data distribution is a challenge for data analysis, since the data is distributed and located in...
