Skip to content

sql-server-linux-setup-machine-learning-sql-2022.md

Latest commit

 

History

History
250 lines (174 loc) · 9.63 KB

sql-server-linux-setup-machine-learning-sql-2022.md

File metadata and controls

250 lines (174 loc) · 9.63 KB
title Install on SQL Server 2022 for Linux
titleSuffix SQL Server Machine Learning Services
description Learn how to install SQL Server 2022 Machine Learning Services on Linux: Red Hat, Ubuntu, and SUSE.
author WilliamDAssafMSFT
ms.author wiassaf
manager rothja
ms.date 05/24/2022
ms.topic how-to
ms.prod sql
ms.technology machine-learning-services
monikerRange >=sql-server-ver16||>=sql-server-linux-ver16
ms.custom
intro-installation
event-tier1-build-2022

Install SQL Server 2022 Machine Learning Services (Python and R) on Linux

[!INCLUDE SQL Server 2022 - Linux]

This article guides you in the installation of SQL Server Machine Learning Services on Linux. Python and R scripts can be executed in-database using Machine Learning Services.

You can install Machine Learning Services on Ubuntu. Currently, Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES) are unsupported.

You can install ML Services on a Docker container running a Linux distribution. Inside the Docker container, the steps would be the same as below.

For more information, see the Supported platforms section in the installation guidance for SQL Server on Linux.

Important

This article refers to [!INCLUDEsssql22-md]. For SQL Server 2019 on Linux, see to Install SQL Server 2019 Machine Learning Services (Python and R) on Linux.

Pre-install checklist

  • Install SQL Server on Linux and verify the installation.

  • Check the SQL Server Linux repositories for the Python and R extensions. If you already configured source repositories for the database engine install, you can run the mssql-server-extensibility package install commands using the same repo registration.

  • You should have a tool for running T-SQL commands.

    • You can use Azure Data Studio, a free database tool that runs on Linux, Windows, and macOS.

Package list

On an internet-connected device, packages are downloaded and installed independently of the database engine using the package installer for each operating system. The following table describes all available packages, but for R and Python, you specify packages that provide either the full feature installation or the minimum feature installation.

Available installation packages for [!INCLUDE sssql22-md] on Linux:

Package name Applies-to Description
mssql-server-extensibility All Extensibility framework used to run Python and R.

Setup R support

The following commands register the repository providing the R language platform.

  1. Configure Linux Repositories corresponding to the Linux distribution. Install the SQL Server extensibility feature with the package mssql-server-extensibility.

    Ubuntu

    apt-get install mssql-server-extensibility

    Redhat

    yum install mssql-server-extensibility

  2. Accept the EULA for SQL ML Services

    sudo /opt/mssql/bin/mssql-conf set EULA accepteulaml Y

  3. Download and install the version of R that is desired. Choose a version of R 4.2 or higher, available for download directly from cran.r-project.org. Follow the instructions for the desired runtime.

  4. Install CompatibilityAPI and RevoScaleR dependencies. From the R terminal of the version you have installed, run the following:

    # R Terminal
install.packages("iterators")
install.packages("foreach")
install.packages("R6")
install.packages("jsonlite")

  5. Download and Install CompatibilityAPI for Linux.

    install.packages("https://aka.ms/sqlml/r4.2/linux/CompatibilityAPI_1.1. 0_R_x86_64-pc-linux-gnu.tar.gz", repos=NULL)

  6. Download and Install RevoScaleR for Linux.

    install.packages("https://aka.ms/sqlml/r4.2/linux/RevoScaleR_10.0.1_R_x86_64-pc-linux-gnu.tar.gz", repos=NULL)

  7. Verify RevoScaleR installation from the R terminal.

    library("RevoScaleR")

  8. Configure the installed R runtime with SQL Server for Linux, where path/to/ is the file path to the R binary, and RFolderVersion is the version-specific folder name for your installation of R runtime, for example, R4.2.

    /opt/mssql/bin/mssql-conf set extensibility rbinpath /path/to/RFolderVersion/lib/R/bin/R
/opt/mssql/bin/mssql-conf set extensibility datadirectories /path/to/RFolderVersion/

  9. Restart the Launchpad service.

    systemctl restart mssql-launchpadd.service

  10. Configure SQL Server for Linux to allow external scripts using the sp_configure system stored procedure.

    EXEC sp_configure 'external scripts enabled', 1;
GO
RECONFIGURE
GO

  11. Verify the installation by executing a simple T-SQL command to return the version of R:

    EXEC sp_execute_external_script @script=N'print(R.version)',@language=N'R';
GO

Setup Python support

  1. Configure Linux Repositories corresponding to the Linux distribution. Install the SQL Server extensibility feature with the package mssql-server-extensibility.

    Ubuntu

    apt-get install mssql-server-extensibility

    Redhat or SLES

    yum install mssql-server-extensibility

  2. Accept the EULA for SQL ML Services

    sudo /opt/mssql/bin/mssql-conf set EULA accepteulaml Y

  3. Download and install the version of Python that is desired. Choose a version of Python 3.10 or higher, available for download directly from python.org. Follow the instructions for the desired runtime.

  4. Download and Install revoscalepy for the root user.

    pip install https://aka.ms/sqlml/python3.10/linux/revoscalepy-10.0.1-py3-none-any.whl

  5. Verify the revoscalepy installation from the python terminal. Verify the library can be imported.

    import revoscalepy

  6. Configure the installed Python runtime with SQL Server, where /path/to is the path to the python installation binary, and pythonFolderVersion is the desired version of Python installed, for example, python3.10. Use the following script with your actual installation path:

    /opt/mssql/bin/mssql-conf set extensibility pythonbinpath /path/to/pythonFolderVersion
/opt/mssql/bin/mssql-conf set extensibility datadirectories /path/to/:/path/to/lib/pythonFolderVersion/dist-packages/

  7. Restart the Launchpad service.

    systemctl restart mssql-launchpadd.service

  8. Configure SQL Server for Linux to allow external scripts using the sp_configure system stored procedure.

    EXEC sp_configure 'external scripts enabled', 1;
GO
RECONFIGURE
GO

  9. Verify the installation by executing a simple T-SQL command to return the version of python:

    EXEC sp_execute_external_script @script=N'import sys;print(sys.version)',@language=N'Python';
GO

Install Java

To install the Java language extension, see Install SQL Server Java Language Extension on Linux.

Verify installation

To validate installation:

  • Run a T-SQL script that executes a system stored procedure invoking Python or R using a query tool.

  • Execute the following SQL command to test R execution in SQL Server. Errors? Try a service restart, sudo systemctl restart mssql-server.service.

    EXEC sp_execute_external_script   
@language =N'R', 
@script=N' 
OutputDataSet <- InputDataSet', 
@input_data_1 =N'SELECT 1 AS hello' 
WITH RESULT SETS (([hello] int not null)); 
GO

  • Execute the following SQL command to test Python execution in SQL Server.

    EXEC sp_execute_external_script  
@language =N'Python', 
@script=N' 
OutputDataSet = InputDataSet; 
', 
@input_data_1 =N'SELECT 1 AS hello' 
WITH RESULT SETS (([hello] int not null)); 
GO

Offline installation

Follow the Offline installation instructions for steps on installing the packages. Find your download site, and then download specific packages using the package list below.

Tip

Several of the package management tools provide commands that can help you determine package dependencies. For yum, use sudo yum deplist [package]. For Ubuntu, use sudo apt-get install --reinstall --download-only [package name] followed by dpkg -I [package name].deb.

Next steps

Python developers can learn how to use Python with SQL Server by following these tutorials:

R developers can get started with some simple examples, and learn the basics of how R works with SQL Server. For your next step, see the following links: