In focus

SQL Server PolyBase supports Now

PolyBase in SQL Server 2016 and later can now connect to Hadoop clusters with the configuration.

Kopal Chaube Dutta Sep 25, 2017

Casey Karst, Program Manager II; Data Systems, announced in a post that "PolyBase in SQL Server 2016 and later can connect to Hadoop clusters with the configuration set to Integrity, Privacy or Authentication."
Supporting this configuration allows PolyBase to connect and query Hadoop clusters that have wire encryption turned on. This enables a secure connection between Hadoop and SQL Server; as well as, among the Hadoop Data Nodes.
To connect to a Hadoop cluster with the set to privacy or integrity, user will need to alter the core-site.xml file that is installed with PolyBase. This file is generally found at C:\ProgramFiles\MicrosoftSQLServer\MSSQL13.MSSQLSERVER\MSSQL\Binn\Polybase\Hadoop\conf.
Users are required to add a new property with the name that is set to a a value of either privacy or integrity, so as to utilize this new configuration.
As per the blog post,
"These values must match the configuration on your Hadoop cluster.
  2. <property>  
  3. <name></name>  
  4. <value>privacy</value>  
  5. </property>  
When changing XML files it is important to ensure that input value is correct and maintain the validity of the XML file format. If the changes are invalid, PolyBase will not run."
Casey informed that this functionality is available by default in all SQL Server installations that currently have PolyBase installed, so it does not require a fresh update. However, currently, the functionality is not available in Azure SQL Data Warehouse, Azure SQL Database, or Analytics Platform System.

Kopal Chaube Dutta
Kopal Chaube Dutta

Racing up to the finish line of my doctorate degree, i am a passionate researcher and writer in search of new challenges. Totally in love with technology and in constant pursuit of new knowledge, my flight brings me to ... Read more