SQL Server 2016 – PolyBase教程

介绍 (Introduction)

This article will teach you how to install PolyBase and will show you a simple example to start.

本文将教您如何安装PolyBase，并向您展示一个简单的示例。

PolyBase is a new feature in SQL Server 2016. It is used to query relational and non-relational databases (NoSQL). You can use PolyBase to query tables and files in Hadoop or in Azure Blob Storage. You can also import or export data to/from Hadoop.

PolyBase是SQL Server 2016中的新功能。它用于查询关系数据库和非关系数据库（NoSQL）。 您可以使用PolyBase查询Hadoop或Azure Blob存储中的表和文件。 您还可以向Hadoop导入数据或从Hadoop导出数据。

In this example, we will show how to query a CSV file stored in Azure Blob storage from SQL Server 2016 using PolyBase.

在此示例中，我们将展示如何使用PolyBase从SQL Server 2016查询存储在Azure Blob存储中的CSV文件。

要求 (Requirements)

1. A subscription to Azure Portal.
   订阅Azure门户。
2. SQL Server installed.
   已安装SQL Server。
3. MASE installed. MASE 。
4. SQL Server Management Studio (SSMS) installed.
   已安装SQL Server Management Studio（SSMS）。

入门 (Getting Started)

We will first show how to install PolyBase and next, we will show an example in Azure to query a CSV file from SSMS 2016.

我们将首先展示如何安装PolyBase，接下来，我们将展示Azure中从SSMS 2016查询CSV文件的示例。

安装 (Installation)

PolyBase is included in the SQL Server 2016 installer. It is a new feature. When you install it or when you want to add this feature, you need to select the New SQL Server stand-alone installation or add feature to an existing installation:

PolyBase包含在SQL Server 2016安装程序中。 这是一个新功能。 在安装时或想要添加此功能时，需要选择“ 新建SQL Server独立安装”或将功能添加到现有安装中：

Run the installer until the Feature Selection and make sure that PolyBase Query Service for External Data is selected:

运行安装程序，直到选择“功能”，并确保已选择“用于外部数据的PolyBase查询服务”：

If it was not installed before, the setup will ask you the Oracle Java Runtime Environment 7. JR7 or later is required, because PolyBase uses Java to connect to Hadoop:

如果之前未安装过，安装程序将询问您Oracle Java Runtime Environment7。由于PolyBase使用Java连接到Hadoop，因此需要JR7或更高版本