Skip to content

machine-learning-services.md

Latest commit

 

History

History
83 lines (56 loc) · 3.3 KB

machine-learning-services.md

File metadata and controls

83 lines (56 loc) · 3.3 KB
title Machine Learning Services (Python, R)
titleSuffix SQL Server Big Data Clusters
description Learn how you can run Python and R scripts on the master instance of a SQL Server Big Data Clusters with Machine Learning Services.
author dphansen
ms.author davidph
ms.date 11/04/2019
ms.topic conceptual
ms.prod sql
ms.technology machine-learning

Run Python and R scripts with Machine Learning Services on SQL Server Big Data Clusters

[!INCLUDEtsql-appliesto-ssver15-xxxx-xxxx-xxx]

You can run Python and R scripts on the master instance of SQL Server Big Data Clusters with Machine Learning Services.

Note

You can also run Java code on the master instance with SQL Server Language Extensions. Following the steps below will also enable Language Extensions.

Enable Machine Learning Services

Machine Learning Services is installed by default on Big Data Clusters and does not require separate installation.

To enable Machine Learning Services, run this statement on the master instance:

EXEC sp_configure 'external scripts enabled', 1
RECONFIGURE WITH OVERRIDE
GO

Enable Always On Availability Groups

If you are using SQL Server Big Data Clusters with Always On Availability Groups, you need to perform a few extra steps to enable Machine Learning Services.

  1. Connect to the master instance and run this statement:

    SELECT @@SERVERNAME

    Note down the server name. In this example, the server name for the master instance is master-2.

  2. On each replica on the Always On Availability Group in the Big Data Cluster, run these kubectl commands:

    kubectl -n bdc expose pod master-0 --port=1533 --name=mymaster-0 --type=LoadBalancer

kubectl -n bdc expose pod master-1 --port=1533 --name=mymaster-1 --type=LoadBalancer

kubectl -n bdc expose pod master-2 --port=1533 --name=mymaster-2 --type=LoadBalancer

    You should see an output similar to this:

    service/mymaster-0 exposed

service/mymaster-1 exposed

service/mymaster-2 exposed

  3. Connect to each master replica endpoint and enable script execution.

    Run this statement:

    EXEC sp_configure 'external scripts enabled', 1
RECONFIGURE WITH OVERRIDE
GO

You are now ready to run Python and R scripts on the master instance of Big Data Clusters. See the quickstarts below to run your first script.

Next steps