PolyBase is a New technology …
- Integrates Microsoft product with Hadoop
- Installing this feature requires Oracle Java JRE 7.
- Previously a Parallel Datawarehouse feature only, now its part of standard SQL Server product 2016.
So, With the help of PolyBase, you can,
- Fetch the data from Hadoop and even allow that data to be joined with native relational tables, means we can get the integrated results from each source.
- Join structured and semi-structured data seamlessly.
- Import data from HDFS to relational tables.
- Export data from relational tables to HDFS.
Go through the below artifactes which may give some insights on PolyBase