{"id":14162,"date":"2019-12-09T06:47:08","date_gmt":"2019-12-09T06:47:08","guid":{"rendered":"https:\/\/dbtut.com\/?p=14162"},"modified":"2020-10-22T13:15:17","modified_gmt":"2020-10-22T13:15:17","slug":"what-is-polybase-and-how-to-install-polybase-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/","title":{"rendered":"What is PolyBase and How To Install PolyBase in SQL Server"},"content":{"rendered":"<h2>What is PolyBase?<\/h2>\n<p>This article contains information about PolyBase in sql server. Use cases, installation steps,configuring polybase cluster.<\/p>\n<p>With PolyBase;<\/p>\n<ul>\n<li>We can bridge between SQL Server and Hadoop, PDW, Azure Blob Storage, or Azure Data Lake Store.<\/li>\n<li>We can access SQL Server from the above mentioned environments outside of SQL Server using TSQL.<\/li>\n<li>With SQL Server 2019, we can now use Polybase to access Oracle, Teradata and MongoDB.<\/li>\n<\/ul>\n<p>With the use of different technologies according to the need, we need to query both relational and non-relational data at the same time. Polybase is a bridge between these two types of systems.<\/p>\n<h3>PolyBase Use Cases<\/h3>\n<ul>\n<li>We can query the data on Hadoop using TSQL over SQL Server or PDW.<\/li>\n<li>We can query the data on Azure Blob Storage using TSQL over SQL Server.<\/li>\n<li>We can import data to SQL Server through Hadoop, Azure Blob Storage, or Azure Data Lake Store.<\/li>\n<li>We can export data from SQL Server to Hadoop, Azure Blob Storage, or Azure Data Lake Store.<\/li>\n<li>We can use PolyBase with third party tools supported by Microsft BI or SQL Server.<\/li>\n<li>We can use PolyBase to access Oracle,Teradata or MongoDB<\/li>\n<\/ul>\n<h3>PolyBase Installation Requirements<\/h3>\n<p>To install PolyBase, your server must have the following components.<\/p>\n<ul>\n<li>64-bit SQL Server Instance<\/li>\n<li>Microsoft .NET Framework 4.5<\/li>\n<li>Oracle Java SE RunTime Environment (JRE) (at least version 7.51)<\/li>\n<li>Minimum 4 GB memory<\/li>\n<li>Minimum 2 GB disk<\/li>\n<li>The TCP \/ IP protocol must be enabled. You can find the required information in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/23\/sql-server-configuration-manager-settings\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Configuration Manager Settings<\/a>&#8220;.<\/li>\n<li>Systems such as Azure, HADOOP. Because we will use PolyBase with SQL Server and other external systems.<\/li>\n<\/ul>\n<h2>Install PolyBase<\/h2>\n<p>During SQL Server Installation, we need to select PolyBase Query Service for External Data in the Feature Selection screen as follows. For detailed information about the installation, please read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/09\/how-to-install-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Install SQL Server<\/a>&#8220;.<\/p>\n<p id=\"zhTHldx\"><img loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"264\" class=\"size-full wp-image-14163 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de612ab1faf0.png\" alt=\"\" \/><\/p>\n<p>After the above screen, we see a screen like the one below.<\/p>\n<p><strong>Use this SQL Server as standalone PolyBase-enabled instance:<\/strong><\/p>\n<p>This means that we have selected SQL Server Intance as the Standalone head node. This means that we will process the data read from Hadoop on a single instance.<\/p>\n<p><strong>Use this SQL Server as a part of PolyBase scale-out group:<\/strong><\/p>\n<p>We may experience performance problems when processing large data on a single instance. By selecting this option, we select the instance we are installing as a Compute node in a cluster of SQL Server Instances to process large data with PolyBase Group feature.<\/p>\n<p>If your organization has a firewall, you will need to open the ports specified in the following screenshot among all nodes in the PolyBase scale-out group. Here you can also specify the port range yourself. The port range you specify must be minimum 6. Even if it is more than 6, SQL Server will use the first 6 ports during the installation.<\/p>\n<p>The following screenshot from Microsoft&#8217;s website summarizes the situation very well.<\/p>\n<p id=\"YvINygw\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14166 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de6168c7fb61.png\" alt=\"\" width=\"666\" height=\"545\" \/><\/p>\n<p>You can see the options mentioned above in the screenshot below.<\/p>\n<p id=\"iErANFN\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14167 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de616a87dc8b.png\" alt=\"\" width=\"644\" height=\"470\" \/><\/p>\n<p>On the next screen, the Server Configuration screen, we need to specify accounts for the SQL Server PolyBase Engine and SQL Server PolyBase Data Movement services.<\/p>\n<p>If we use the PolyBase scale-out group in the second option above, the PolyBase engine and PolyBase data movement services on all nodes must use the same domain account.<\/p>\n<p id=\"rLjSKaV\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14168 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de616f2ac70e.png\" alt=\"\" width=\"665\" height=\"262\" \/><\/p>\n<p>Click Next, Next and Finish to complete the installation.<\/p>\n<p>If PolyBase is not installed on Instance, clicking on the + sign on PolyBase via SSMS will throw an error as follows.<\/p>\n<p><span style=\"color: #ff0000;\"><em>The PolyBase feature must be installed on the server instance before you can create a PolyBase group on this instance.<\/em><\/span><\/p>\n<p id=\"nihfYSH\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14169 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de6172fa49ae.png\" alt=\"\" width=\"602\" height=\"149\" \/><\/p>\n<p>After the installation is complete, you must configure SQL Server to connect to external sources such as Azure, HADOOP.<\/p>\n<p>With the following command, you can configure as follows to connect to Azure Blob Storage. By default, this setting is 7 after installation. You can set one of the following options for another connection type.<\/p>\n<pre class=\"lang:default decode:true\">sp_configure 'hadoop connectivity',7\r\nGO  \r\nRECONFIGURE  \r\nGO<\/pre>\n<p>Option 0: Disable Hadoop connectivity<\/p>\n<p>Option 1: Hortonworks HDP 1.3 on Windows Server<\/p>\n<p>Option 1: Azure blob storage (WASB[S])<\/p>\n<p>Option 2: Hortonworks HDP 1.3 on Linux<\/p>\n<p>Option 3: Cloudera CDH 4.3 on Linux<\/p>\n<p>Option 4: Hortonworks HDP 2.0 on Windows Server<\/p>\n<p>Option 4: Azure blob storage (WASB[S])<\/p>\n<p>Option 5: Hortonworks HDP 2.0 on Linux<\/p>\n<p>Option 6: Cloudera 5.1, 5.2, 5.3, 5.4, 5.5, 5.9, 5.10, 5.11, 5.12, and 5.13 on Linux<\/p>\n<p>Option 7: Hortonworks 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.0 on Linux<\/p>\n<p>Option 7: Hortonworks 2.1, 2.2, and 2.3 on Windows Server<\/p>\n<p>Option 7: Azure blob storage (WASB[S])<\/p>\n<p>To improve performance, copy the value of the yarn.application.classpath configuration key in the yarn-site.xml file in the HADOOP configuration directory and paste to yarn.application.classpath property in the yarn-site.xml.<\/p>\n<p id=\"UCzOyCr\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14171 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de61d98498f9.png\" alt=\"\" width=\"674\" height=\"176\" \/><\/p>\n<h2>Configure PolyBase Cluster<\/h2>\n<p>You can configure polybase cluster after installation as below.<\/p>\n<p id=\"csWTSfl\"><img loading=\"lazy\" decoding=\"async\" width=\"384\" height=\"86\" class=\"size-full wp-image-14172 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de61dc8c987c.png\" alt=\"\" \/><\/p>\n<p>You will see a screen like the one below. You can add the desired instances to this group by clicking the + sign.<\/p>\n<p id=\"vgVWBTT\"><img loading=\"lazy\" decoding=\"async\" width=\"682\" height=\"544\" class=\"size-full wp-image-14173 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de61e12266bd.png\" alt=\"\" \/><\/p>\n<p>After defining the head node after installation, we can set other nodes as compute nodes.<\/p>\n<p>&#8212; head node server name, head node dms control channel port, head node sql server instance name<\/p>\n<pre class=\"lang:default decode:true\">EXEC sp_polybase_join_group 'MyServer', 16450, 'MSSQLSERVER';<\/pre>\n<p id=\"iwygWXD\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14175 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de61e77a0a4c.png\" alt=\"\" width=\"672\" height=\"190\" \/><\/p>\n<p>After performing these operations, disable PolyBase Engine Service and restart Data Movement Service on Compute Nodes.<\/p>\n<p><strong>Remove a Compute Node From PolyBase Cluster<\/strong><\/p>\n<p>You can remove a compute node from the cluster with the following script.<\/p>\n<pre class=\"lang:default decode:true \">EXEC sp_polybase_leave_group;<\/pre>\n<p><strong>Note:<\/strong> SQL Server installed in Head Node must be Enterprise Edition.<\/p>\n<p>You can also transfer data between Azure or Hadoop and SQL Server using the links below.<\/p>\n<p>https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-t-sql-objects<\/p>\n<p>https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-queries<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14162\" class=\"pvc_stats all  \" data-element-id=\"14162\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is PolyBase? This article contains information about PolyBase in sql server. Use cases, installation steps,configuring polybase cluster. With PolyBase; We can bridge between SQL Server and Hadoop, PDW, Azure Blob Storage, or Azure Data Lake Store. We can access SQL Server from the above mentioned environments outside of SQL Server using TSQL. With SQL &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14162\" class=\"pvc_stats all  \" data-element-id=\"14162\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":14177,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[6565,6567,6569,6559,6560,6571,6554,6555,6579,6557,10227,6575,6574,6576,6553,6558,6583,6584,6577,6581,6552,6568,6556,6566,6570,6582,6585,6586,6580,6573,6578,6564,6563,6562,6561,6572,6551],"class_list":["post-14162","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-configure-polybase-cluster","tag-exec-sp_polybase_join_group","tag-exec-sp_polybase_leave_group","tag-how-to-access-external-data-from-sql-server","tag-how-to-access-external-system-from-sql-server","tag-how-to-install-polybase","tag-install-polybase","tag-install-polybase-in-sql-server","tag-microsoft-polybase-tutorial","tag-polybase","tag-polybase-cluster","tag-polybase-configuration-sql-server","tag-polybase-configuration-sql-server-2017","tag-polybase-external-table","tag-polybase-installation-requirements","tag-polybase-query-service-for-external-data","tag-polybase-sql","tag-polybase-sql-server","tag-polybase-tutorial","tag-polybase-tutorial-azure","tag-polybase-use-cases","tag-remove-a-compute-node-from-polybase-cluster","tag-setup-polybase","tag-sp_polybase_join_group","tag-sp_polybase_leave_group","tag-sql-polybase-tutorial","tag-sql-server-2016-polybase-tutorial","tag-sql-server-2019-polybase","tag-sql-server-polybase","tag-sql-server-polybase-engine","tag-sql-server-polybase-tutorial","tag-the-polybase-feature-must-be-installed-on-the-server-instance","tag-the-polybase-feature-must-be-installed-on-the-server-instance-before-you-can-create-a-polybase-group-on-this-instance","tag-use-this-sql-server-as-a-part-of-polybase-scale-out-group","tag-use-this-sql-server-as-standalone-polybase-enabled-instance","tag-what-is-polybase-in-sql-server","tag-what-is-polybase"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is PolyBase and How To Install PolyBase in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about PolyBase in sql server. use cases, installation steps,configuring polybase cluster.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is PolyBase and How To Install PolyBase in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about PolyBase in sql server. use cases, installation steps,configuring polybase cluster.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-09T06:47:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-22T13:15:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"506\" \/>\n\t<meta property=\"og:image:height\" content=\"335\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is PolyBase and How To Install PolyBase in SQL Server\",\"datePublished\":\"2019-12-09T06:47:08+00:00\",\"dateModified\":\"2020-10-22T13:15:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/\"},\"wordCount\":903,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png\",\"keywords\":[\"Configure PolyBase Cluster\",\"EXEC sp_polybase_join_group\",\"EXEC sp_polybase_leave_group;\",\"How To Access External Data from SQL Server\",\"How To Access External System from SQL Server\",\"how to install PolyBase\",\"Install PolyBase\",\"install polybase in sql server\",\"microsoft polybase tutorial\",\"PolyBase\",\"PolyBase Cluster\",\"polybase configuration sql server\",\"polybase configuration sql server 2017\",\"polybase external table\",\"PolyBase Installation Requirements\",\"PolyBase Query Service for External Data\",\"polybase sql\",\"polybase sql server\",\"polybase tutorial\",\"polybase tutorial azure\",\"PolyBase Use Cases\",\"Remove a Compute Node From PolyBase Cluster\",\"Setup PolyBase\",\"sp_polybase_join_group\",\"sp_polybase_leave_group;\",\"sql polybase tutorial\",\"sql server 2016 polybase tutorial\",\"sql server 2019 polybase\",\"sql server polybase\",\"sql server polybase engine\",\"sql server polybase tutorial\",\"The PolyBase feature must be installed on the server instance\",\"The PolyBase feature must be installed on the server instance before you can create a PolyBase group on this instance\",\"Use this SQL Server as a part of PolyBase scale-out group:\",\"Use this SQL Server as standalone PolyBase-enabled instance:\",\"What is PolyBase in SQL Server\",\"What is PolyBase?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/\",\"name\":\"What is PolyBase and How To Install PolyBase in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png\",\"datePublished\":\"2019-12-09T06:47:08+00:00\",\"dateModified\":\"2020-10-22T13:15:17+00:00\",\"description\":\"This article contains information about PolyBase in sql server. use cases, installation steps,configuring polybase cluster.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png\",\"width\":506,\"height\":335},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is PolyBase and How To Install PolyBase in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is PolyBase and How To Install PolyBase in SQL Server - Database Tutorials","description":"This article contains information about PolyBase in sql server. use cases, installation steps,configuring polybase cluster.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"What is PolyBase and How To Install PolyBase in SQL Server - Database Tutorials","og_description":"This article contains information about PolyBase in sql server. use cases, installation steps,configuring polybase cluster.","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-09T06:47:08+00:00","article_modified_time":"2020-10-22T13:15:17+00:00","og_image":[{"width":506,"height":335,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is PolyBase and How To Install PolyBase in SQL Server","datePublished":"2019-12-09T06:47:08+00:00","dateModified":"2020-10-22T13:15:17+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/"},"wordCount":903,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png","keywords":["Configure PolyBase Cluster","EXEC sp_polybase_join_group","EXEC sp_polybase_leave_group;","How To Access External Data from SQL Server","How To Access External System from SQL Server","how to install PolyBase","Install PolyBase","install polybase in sql server","microsoft polybase tutorial","PolyBase","PolyBase Cluster","polybase configuration sql server","polybase configuration sql server 2017","polybase external table","PolyBase Installation Requirements","PolyBase Query Service for External Data","polybase sql","polybase sql server","polybase tutorial","polybase tutorial azure","PolyBase Use Cases","Remove a Compute Node From PolyBase Cluster","Setup PolyBase","sp_polybase_join_group","sp_polybase_leave_group;","sql polybase tutorial","sql server 2016 polybase tutorial","sql server 2019 polybase","sql server polybase","sql server polybase engine","sql server polybase tutorial","The PolyBase feature must be installed on the server instance","The PolyBase feature must be installed on the server instance before you can create a PolyBase group on this instance","Use this SQL Server as a part of PolyBase scale-out group:","Use this SQL Server as standalone PolyBase-enabled instance:","What is PolyBase in SQL Server","What is PolyBase?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/","name":"What is PolyBase and How To Install PolyBase in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png","datePublished":"2019-12-09T06:47:08+00:00","dateModified":"2020-10-22T13:15:17+00:00","description":"This article contains information about PolyBase in sql server. use cases, installation steps,configuring polybase cluster.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-2.png","width":506,"height":335},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/what-is-polybase-and-how-to-install-polybase-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is PolyBase and How To Install PolyBase in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14162"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14162\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14177"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}