Skip to content

polybase-linux-setup.md

Latest commit

 

History

History
358 lines (235 loc) · 11.2 KB

polybase-linux-setup.md

File metadata and controls

358 lines (235 loc) · 11.2 KB
title Install PolyBase on Linux
titleSuffix SQL Server
description Learn how to install SQL Server PolyBase on Linux. PolyBase enables you to run external queries against remote data sources.
author MikeRayMSFT
ms.author mikeray
ms.reviewer dakryze, hudequei, randolphwest
ms.date 09/12/2025
ms.service sql
ms.subservice linux
ms.topic install-set-up-deploy
ms.custom
intro-installation
linux-related-content
monikerRange >=sql-server-linux-ver15 || >=sql-server-ver15

Install PolyBase on Linux

[!INCLUDE sqlserver2019-linux]

The following steps install PolyBase (mssql-server-polybase and mssql-server-polybase-hadoop) on Linux. PolyBase enables you to run external queries against remote data sources.

Prerequisites

Before you install PolyBase, first install SQL Server. This step configures the keys and repositories that you use when installing the mssql-server-polybase and mssql-server-polybase-hadoop package.

Limitations

The length of the hostname where [!INCLUDE ssnoversion-md] is installed needs to be 15 characters or less.

PolyBase isn't supported on [!INCLUDE sssql17-md] for Linux.

Scale-out for PolyBase on Linux is currently unavailable.

Hadoop isn't supported on [!INCLUDE sssql22-md] and later versions.

Install PolyBase

Install PolyBase for your operating system:

  • Red Hat Enterprise Linux (RHEL)
  • Ubuntu
  • SUSE Linux Enterprise Server (SLES)

Red Hat Enterprise Linux (RHEL)

Install on RHEL

Applies to: [!INCLUDE sssql19-md] and later versions.

  1. Download the Microsoft Red Hat repository configuration file.

    For RHEL 10 (in preview):

    sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/10/mssql-server-2025.repo

    For RHEL 9:

    sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/9/prod.repo

    For RHEL 8:

    sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/8/prod.repo

    For RHEL 7:

    sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo

  2. Use the following command to install the mssql-server-polybase on Red Hat Enterprise Linux.

    sudo yum install -y mssql-server-polybase

  3. You're prompted to restart the [!INCLUDE ssnoversion-md] instance. Use the following command to do so.

    sudo systemctl restart mssql-server

Note

After installation, you must enable the PolyBase feature.

::: moniker range="<=sql-server-linux-ver15 || <=sql-server-ver15"

Install Hadoop on RHEL

Applies to: [!INCLUDE sssql19-md] only.

  1. Use the following command to install the mssql-server-polybase-hadoop.

    sudo yum install -y mssql-server-polybase-hadoop

    The PolyBase Hadoop package has dependencies on the following packages:

    • mssql-server
    • mssql-server-polybase
    • mssql-server-extensibility
    • mssql-zulu-jre-11

  2. Installation prompts to restart launchpadd. Use the following command to do so.

    sudo systemctl restart mssql-launchpadd

Note

After installation, you must set the Hadoop connectivity level.

If you need an offline installation, locate the PolyBase package download in the Release notes for SQL Server 2019 on Linux. Then use the same offline installation steps described in the article Install SQL Server.

::: moniker-end

Ubuntu

Install on Ubuntu

Applies to: [!INCLUDE sssql19-md] and later versions.

  1. Register the Microsoft Ubuntu repository.

    For Ubuntu 16.04:

    curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

    For Ubuntu 18.04:

    curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

    For Ubuntu 20.04:

    curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

    For Ubuntu 22.04:

    curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

  2. Use the following command to install the mssql-server-polybase on Ubuntu.

    sudo apt-get install mssql-server-polybase

  3. When prompted, restart the [!INCLUDE ssnoversion-md] instance.

    sudo systemctl restart mssql-server

Note

After installation, you must enable the PolyBase feature.

If you need an offline installation, locate the PolyBase package download in the Release notes for SQL Server 2019 on Linux. Then use the same offline installation steps described in the article Install SQL Server.

::: moniker range="<=sql-server-linux-ver15 || <=sql-server-ver15"

Install Hadoop on Ubuntu

Applies to: [!INCLUDE sssql19-md] only.

  1. Use the following command to install the mssql-server-polybase-hadoop.

    sudo apt-get install mssql-server-polybase-hadoop

    The PolyBase Hadoop package has dependencies on the following packages:

    • mssql-server
    • mssql-server-polybase
    • mssql-server-extensibility
    • mssql-zulu-jre-11

  2. Installation prompts to restart launchpadd. Use the following command to do so.

    sudo systemctl restart mssql-launchpadd

Note

After installation, you must set the Hadoop connectivity level. This step only applies to [!INCLUDE sssql19-md].

::: moniker-end

SUSE Linux Enterprise Server (SLES)

Install on SLES

Applies to: [!INCLUDE sssql19-md] and later versions.

  1. Add the Microsoft [!INCLUDE ssnoversion-md] repository to Zypper.

    For SLES 12:

    sudo zypper addrepo -fc https://packages.microsoft.com/config/sles/12/prod.repo
sudo zypper --gpg-auto-import-keys refresh

    For SLES 15:

    sudo zypper addrepo -fc https://packages.microsoft.com/config/sles/15/prod.repo
sudo zypper --gpg-auto-import-keys refresh

  2. Use the following commands to install the mssql-server-polybase on SUSE Linux Enterprise Server.

    sudo zypper install mssql-server-polybase

  3. You're prompted to restart the [!INCLUDE ssnoversion-md] instance. Use the following command to do so.

    sudo systemctl restart mssql-server

Note

After installation, you must enable the PolyBase feature.

If you need an offline installation, locate the PolyBase package download in the Release notes for SQL Server 2019 on Linux. Then use the same offline installation steps described in the article Install SQL Server.

Enable PolyBase

After installation, PolyBase must be enabled to access its features. Connect to the installed [!INCLUDE ssnoversion-md] instance and use the following Transact-SQL command to enable.

EXECUTE sp_configure
    @configname = 'polybase enabled',
    @configvalue = 1;

RECONFIGURE WITH OVERRIDE;

Trace flag

Applies to: [!INCLUDE sssql22-md]

To use PolyBase capabilities on Linux, you must enable trace flag 13702 during SQL Server start up. For more information, see Configure SQL Server on Linux with the mssql-conf tool.

Update PolyBase

If you already have mssql-server-polybase installed, you can update to the latest version with the following commands:

Red Hat Enterprise Linux (RHEL)

RHEL with Hadoop

Applies to: [!INCLUDE sssql19-md] only.

sudo yum remove -y mssql-server-polybase-hadoop
sudo yum remove -y mssql-server-polybase
sudo yum check-update
sudo yum install -y mssql-server-polybase
sudo yum install -y mssql-server-polybase-hadoop

RHEL without Hadoop

sudo yum remove -y mssql-server-polybase
sudo yum check-update
sudo yum install -y mssql-server-polybase

You're prompted to restart the [!INCLUDE ssnoversion-md] instance. Use the following command to do so.

sudo systemctl restart mssql-server

Ubuntu

Ubuntu with Hadoop

Applies to: [!INCLUDE sssql19-md] only.

sudo apt-get remove mssql-server-polybase-hadoop
sudo apt-get remove mssql-server-polybase
sudo apt-get update
sudo apt-get install mssql-server-polybase
sudo apt-get install mssql-server-polybase-hadoop

Ubuntu without Hadoop

sudo apt-get remove mssql-server-polybase
sudo apt-get update
sudo apt-get install mssql-server-polybase

You're prompted to restart the [!INCLUDE ssnoversion-md] instance. Use the following command to do so.

sudo systemctl restart mssql-server

SUSE Linux Enterprise Server (SLES)

SLES

sudo zypper remove mssql-server-polybase
sudo zypper refresh
sudo zypper install mssql-server-polybase

You're prompted to restart the [!INCLUDE ssnoversion-md] instance. Use the following command to do so.

sudo systemctl restart mssql-server

Note

After installation, you must enable the PolyBase feature.

Related links

PolyBase on Linux can access the following data sources. Follow the provided links for more information on how to create an external table from these sources on PolyBase is enabled.

Related content