polybase配置 sql_在 Windows 上安装 PolyBase

在 Windows 上安装 PolyBaseInstall PolyBase on Windows

09/24/2018

本文内容

适用于：Applies to:SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions)-仅限 Windows适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) - Windows only

若要安装 SQL Server 试用版，请转到 SQL Server 评估。To install a trial version of SQL Server, go to SQL Server evaluations.

先决条件Prerequisites

64 位 SQL Server 评估版。64-bit SQL Server Evaluation edition.

Microsoft .NET Framework 4.5。Microsoft .NET Framework 4.5.

最小内存：4 GB。Minimum memory: 4 GB.

最小硬盘空间：2 GB。Minimum hard-disk space: 2 GB.

建议：至少 16 GB 的 RAM。Recommended: Minimum of 16-GB RAM.

必须启用 TCP/IP 才能使 PolyBase 正常工作。TCP/IP must be enabled for PolyBase to function correctly. SQL Server 的所有版本均默认启用 TCP/IP，Developer 和 Express SQL Server 版本除外。TCP/IP is enabled by default on all editions of SQL Server except for the Developer and Express SQL Server editions. 若要使 PolyBase 在 Developer 和 Express 版本上正常工作，必须启用 TCP/IP 连接。For PolyBase to function correctly on the Developer and Express editions, you must enable TCP/IP connectivity.

备注

在每台计算机上仅可在一个 SQL Server 实例上安装 PolyBase。PolyBase can be installed on only one SQL Server instance per machine.

备注

若要使用 PolyBase，必须对数据库具有 sysadmin 或 CONTROL SERVER 级别的权限。In order to use PolyBase you must have sysadmin or CONTROL SERVER level permissions on the database.

重要

若要对 Hadoop 使用计算下推功能，目标 Hadoop 群集必须具有 HDFS、YARN 和 MapReduce 的核心组件且已启用作业历史记录服务器。To use the computation pushdown functionality against Hadoop, the target Hadoop cluster must have the core components of HDFS, YARN and MapReduce, with the job history server enabled. PolyBase 通过 MapReduce 提交下推查询，并且从作业历史记录服务器拉取状态。PolyBase submits the pushdown query via MapReduce and pulls status from the job history server. 缺少任一组件，查询都会失败。Without either component, the query fails.

单节点或 PolyBase 横向扩展组Single node or PolyBase scale-out group

在 SQL Server 实例上安装 PolyBase 之前，决定是需要单节点安装还是需要 PolyBase 横向扩展组。Before you install PolyBase on your SQL Server instances, decide whether you want a single node installation or a PolyBase scale-out group.

对于 PolyBase 横向扩展组，请确保：For a PolyBase scale-out group, make sure that:

所有计算机都位于同一域中。All the machines are on the same domain.

在 PolyBase 安装期间使用相同的服务帐户和密码。You use the same service account and password during PolyBase installation.

SQL Server 实例彼此之间可以通过网络进行通信。Your SQL Server instances can communicate with one another over the network.

SQL Server 实例的 SQL Server 版本相同。The SQL Server instances are all the same version of SQL Se