{"id":15351,"date":"2016-03-22T13:07:16","date_gmt":"2016-03-22T20:07:16","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=15351"},"modified":"2024-01-22T22:50:27","modified_gmt":"2024-01-23T06:50:27","slug":"expanding-the-data-footprint-of-sql-server-2016-with-polybase","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/","title":{"rendered":"Expanding the data footprint of SQL Server 2016 with PolyBase"},"content":{"rendered":"<p><em>This post was authored by Casey Karst, Program Manager, SQL Server.<\/em><\/p>\n<h2>Changing data landscape<\/h2>\n<p>A lot has changed in the world of data over the last 10 years. The rise of connected devices, unstructured event data and ever-decreasing hardware prices has caused a Big Data boom. Solutions built on commodity hardware, such as Hadoop and HDFS (Hadoop Distributed File System), were developed to land machine-born, semi-structured data and deliver insights. This created new opportunities for generating value, but it has come at the cost of added complexity to enterprise data solutions. With the additional data also came the problem of having two or more disjoint datasets, some relational in SQL Server and some non-relational in HDFS. If a data analyst wanted to combine relational data with semi-structured data, they had to spend time and resources copying the data from one environment into the other, ultimately slowing the time to insight.<\/p>\n<p>With PolyBase in SQL Server 2016, the days of disjoint relational and semi-structured data are over. <strong>With the combination of PolyBase and T-SQL, users can query data stored in HDFS as if it is local to the SQL Server, enabling a wide variety of new insights and scenarios.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px; padding-left: 0px; padding-right: 0px; border-width: 0px;\" title=\"PolyBase and T-SQL combo\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/PolyBase-and-T-SQL-combo.png\" srcset=\"\" alt=\"PolyBase and T-SQL combo\" width=\"610\" height=\"309\" border=\"0\" \/><\/p>\n<h2>Key scenarios<\/h2>\n<p>Because PolyBase allows you to interact with both SQL Server and Hadoop, three new scenarios are possible:<\/p>\n<ul>\n<li>Ad hoc query of data stored in Hadoop and SQL Server 2016 using T-SQL<\/li>\n<li>Import data from Hadoop or Azure blob storage into SQL Server 2016<\/li>\n<li>Export \u201ccold\u201d relational data to Hadoop or Azure blob storage while keeping it query-able<\/li>\n<\/ul>\n<p>When you run ad hoc queries over Hadoop data, PolyBase can intelligently leverage the compute resources of Hadoop. PolyBase can make a cost-based decision to push-down computation to Hadoop by generating MapReduce jobs on-the-fly, delivering the most optimal performance for your queries.<\/p>\n<h2>PolyBase: Bringing it all together<\/h2>\n<p>PolyBase extends the data footprint available for T-SQL queries by creating a structured definition in SQL Server of the semi-structured data stored in Hadoop and Azure blob storage. Once the structure is set up, users can interact with the data in nearly* the same way as data stored in SQL Server.<\/p>\n<p>The three new data definition language (DDL) statements needed to structure external data are:<\/p>\n<ul>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-US\/library\/dn935022.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Create External Data Source<\/a>: Hadoop or Azure blob storage? Where is the data source located?<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-US\/library\/dn935026.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Create External File Format<\/a>: What is the layout of the data?<\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn935021.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Create External Table<\/a>: What is the schema?<\/li>\n<\/ul>\n<p>*<em>A notable difference between external tables and local tables is that when an external table is deleted, the data remains intact on the external data source.<\/em><\/p>\n<h4>External data source<\/h4>\n<p>PolyBase supports the latest versions of Hortonworks and Cloudera distributions with SQL Server 2016. PolyBase will also support newer Hadoop versions within 90 days of their general availability. In addition to Hadoop distributions, PolyBase supports Azure storage blobs as external data sources.<\/p>\n<p>For a full list of supported data sources, click <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt143174.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">here<\/a>.<\/p>\n<h4>External file format<\/h4>\n<p>PolyBase supports Text, ORC, RC and Parquet file types in both compressed and uncompressed formats.<br \/>\nFor more details on supported file types, see this <a href=\"https:\/\/msdn.microsoft.com\/en-US\/library\/dn935026.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">how-to<\/a>.<\/p>\n<h4>External table<\/h4>\n<p>PolyBase External Tables reference the data stored in a Hadoop cluster or Azure blob storage. For more details on how to create external tables, reference this <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn935021.aspx\">site<\/a>.<\/p>\n<h2>PolyBase scale-out groups for breakthrough query performance<\/h2>\n<p>For workloads that require querying large datasets in HDFS, it is suggested that you increase the resources on the SQL side for optimal performance. Rather than increasing the size of a single node, SQL Server 2016 introduces PolyBase scale-out groups as a method of distributing a query across multiple SQL Server instances, enabling parallelized computation and data ingestion. A scale-out group is composed of a head node, which users submit queries to and that holds the relational data for the query, and compute nodes, which parallelize the ingestion and computation of the data. Compute nodes are free to process other workloads while also being part of a PolyBase scale-out group.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px; padding-left: 0px; padding-right: 0px; border-width: 0px;\" title=\"Compute Nodes\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/Compute-Nodes.png\" srcset=\"\" alt=\"Compute Nodes\" width=\"610\" height=\"379\" border=\"0\" \/><\/p>\n<h2>Extra resources<\/h2>\n<p>Interested in getting started with all of the capabilities PolyBase for SQL Server 2016 offers? Learn more with the following links to learn how PolyBase enables you to query HDFS using T-SQL directly from SQL Server.<\/p>\n<p>For general knowledge on some of the great enhancements provided by SQL Server 2016, be sure to check out the other posts in the <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2015\/12\/01\/get-the-most-out-of-sql-server-2016.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">SQL Server 2016 blog series<\/a>.<\/p>\n<ul>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt163689.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Getting started with PolyBase<\/a><\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt607030.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">PolyBase groups for scale-out computation<\/a><\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146389.aspx?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">PolyBase troubleshooting with dynamic management views<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/Try-SQL-Server-2016-RC4.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px; padding-left: 0px; padding-right: 0px; border-width: 0px;\" title=\"Try SQL Server 2016 RC\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/Try-SQL-Server-2016-RC4.png\" srcset=\"\" alt=\"Try SQL Server 2016 RC\" width=\"250\" height=\"47\" border=\"0\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post was authored by Casey Karst, Program Manager, SQL Server. Changing data landscape A lot has changed in the world of data over the last 10 years. The rise of connected devices, unstructured event data and ever-decreasing hardware prices has caused a Big Data boom. Solutions built on commodity hardware, such as Hadoop and<\/p>\n","protected":false},"author":1457,"featured_media":49641,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-15351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-sql","product-sql-server-2016","content-type-updates","review-flag-free-1593619513-128","review-flag-gener-1593580750-651","review-flag-lever-1593580264-545","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Expanding the data footprint of SQL Server 2016 with PolyBase - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Expanding the data footprint of SQL Server 2016 with PolyBase - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post was authored by Casey Karst, Program Manager, SQL Server. Changing data landscape A lot has changed in the world of data over the last 10 years. The rise of connected devices, unstructured event data and ever-decreasing hardware prices has caused a Big Data boom. Solutions built on commodity hardware, such as Hadoop and\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-22T20:07:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"120\" \/>\n\t<meta property=\"og:image:height\" content=\"90\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Expanding the data footprint of SQL Server 2016 with PolyBase\",\"datePublished\":\"2016-03-22T20:07:16+00:00\",\"dateModified\":\"2024-01-23T06:50:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/\"},\"wordCount\":738,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/\",\"name\":\"Expanding the data footprint of SQL Server 2016 with PolyBase - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg\",\"datePublished\":\"2016-03-22T20:07:16+00:00\",\"dateModified\":\"2024-01-23T06:50:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg\",\"width\":120,\"height\":90,\"caption\":\"Expanding the data footprint of SQL Server 2016 with PolyBase\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expanding the data footprint of SQL Server 2016 with PolyBase\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Expanding the data footprint of SQL Server 2016 with PolyBase - Microsoft SQL Server Blog","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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/","og_locale":"en_US","og_type":"article","og_title":"Expanding the data footprint of SQL Server 2016 with PolyBase - Microsoft SQL Server Blog","og_description":"This post was authored by Casey Karst, Program Manager, SQL Server. Changing data landscape A lot has changed in the world of data over the last 10 years. The rise of connected devices, unstructured event data and ever-decreasing hardware prices has caused a Big Data boom. Solutions built on commodity hardware, such as Hadoop and","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-03-22T20:07:16+00:00","article_modified_time":"2024-01-23T06:50:27+00:00","og_image":[{"width":120,"height":90,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg","type":"image\/jpeg"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Expanding the data footprint of SQL Server 2016 with PolyBase","datePublished":"2016-03-22T20:07:16+00:00","dateModified":"2024-01-23T06:50:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/"},"wordCount":738,"commentCount":2,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/","name":"Expanding the data footprint of SQL Server 2016 with PolyBase - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg","datePublished":"2016-03-22T20:07:16+00:00","dateModified":"2024-01-23T06:50:27+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/expanding-the-data-footprint-of.jpg","width":120,"height":90,"caption":"Expanding the data footprint of SQL Server 2016 with PolyBase"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Expanding the data footprint of SQL Server 2016 with PolyBase"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/15351"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=15351"}],"version-history":[{"count":2,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/15351\/revisions"}],"predecessor-version":[{"id":50132,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/15351\/revisions\/50132"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/49641"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=15351"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=15351"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=15351"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=15351"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=15351"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=15351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}