我们如何在SQL SERVER 2016中使用SVM模型

I am using SQL Server 2016 R services,

我正在使用SQL Server 2016 R服务，

I searched several documents and links on web but i failed to get complete details on svm in SQL Server 2016, please help to learn

我在网上搜索了几个文档和链接但是我没能在SQL Server 2016中获得有关svm的完整详细信息，请帮助学习

1 个解决方案

#1

Hey V L SUDHAKAR INAMPUDI,

嘿V L SUDHAKAR INAMPUDI，

OK, so rxOneClassSvm is part of MicrosoftML, which ships with the Microsoft R Server version 3.3.2. The version of Microsoft R Server in SQL Server 2016 R Services is 3.2.2. Installing CU4 will not update the R version. To see what version you have, you can run following R code in your SQL Server:

好的，所以rxOneClassSvm是MicrosoftML的一部分，它随Microsoft R Server版本3.3.2一起提供。 SQL Server 2016 R服务中的Microsoft R Server版本为3.2.2。安装CU4不会更新R版本。要查看您的版本，可以在SQL Server中运行以下R代码：

EXEC sp_execute_external_script
@language = N'R' ,
@script = N'print(R.Version()$version)'

You can update the existing version to a later version, but there are some minimum requirements of what service packs etc., you have installed for SQL Server. However, having CU4, you should be golden. This link: https://blogs.msdn.microsoft.com/microsoftrservertigerteam/2017/03/22/running-microsoftml-in-sql-server/ should give you information how to upgrade the R version.

您可以将现有版本更新到更高版本，但是您已为SQL Server安装了哪些Service Pack等的最低要求。但是，拥有CU4，你应该是金色的。此链接：https：//blogs.msdn.microsoft.com/microsoftrservertigerteam/2017/03/22/running-microsoftml-in-sql-server/应该为您提供有关如何升级R版本的信息。

If you want to see what packages you have installed you can run following code:

如果要查看已安装的软件包，可以运行以下代码：

EXEC sp_execute_external_script
    @language = N'R'
    , @script = N'
    OutputDataSet <- data.frame(installed.packages()[,c("Package", "Version", "Depends", 
"License", "Built", "LibPath")]);'
WITH RESULT SETS ((Package nvarchar(255), Version nvarchar(100), 
                   Depends nvarchar(4000), License nvarchar(1000), 
                   Built nvarchar(100), LibPath nvarchar(2000)));

Hope this helps!

希望这可以帮助！

#1