Stack Overflow
Stack Overflow

Questions tagged [revoscalepy]

Python package that integrates python and R with SQL (starting from SQL Server 2017).

8 questions
2
votes
2 answers

Installing microsoftml and revoscalepy for SQL Machine Learning

I'm trying to install microsoftml and revoscalepy. These packages are developed by microsoft and can be used (apparently) for scoring python models in SQL server 2017. I'm using an anaconda environment with python 3.7 installed. The intuitive does…
Roelant
  • 4,508
  • 1
  • 32
  • 62
1
vote
0 answers

SQL Server 2017 MLS - Installing New Python Packages

I'm running SQL Server 2017 developer edition with Machine Learning Services (python V3.5.2). I got everything set up today and can successfully run sp_execute_external_script like the following: EXEC sp_execute_external_script @language…
Chris
  • 21
  • 2
1
vote
0 answers

"type object argument after * must be an iterable, not NoneType" error using RxSqlServerData & rx_featurize while inserting data into the database

I am using SQL Server 2017 in-database Machine Learning Services with python (revoscalepy,microsoftml) for creating a model with Jupyter Server notebook. I am able to set my compute_context using revoscalepy and successfully run a model and store…
Shreyas Moolya
  • 339
  • 4
  • 19
1
vote
0 answers

ODBC Error in SQLDisconnect following Microsoft Tutorial

I am currently trying SQL Server's new Machine Learning Services for Python by following Microsoft's tutorial. I am on a Win10 x64, SQL Server 2017 x64, using Jyputer Notebook and RevoScalepy. Connection to the database is not a problem, as…
Sindre E. de Lange
  • 11
  • 2
0
votes
0 answers

SQl Server, No module named 'revoscalepy.computecontext'

I followed the steps here to install Python and configure Python runtime with SQL Server. When I ran this script EXEC sp_execute_external_script @script=N'import sys;print(sys.version)',@language=N'Python' GO this error popped up: Msg 39012, Level…
KoalaJ
  • 145
  • 2
  • 11
0
votes
0 answers

How to fix "RuntimeError: revoscalepy function failed."

I try to run the example in https://learn.microsoft.com/vi-vn/sql/advanced-analytics/tutorials/sqldev-py3-explore-and-visualize-the-data?view=sql-server-2017 EXEC [dbo].[PyPlotMatplotlib] GO I got error, I don't know how to fix it. Msg 39004, Level…
Anh Nguyet
  • 1
  • 1
0
votes
1 answer

SQL server python service-"DECLARE @myscript NVARCHAR(MAX) = N' " gives syntax error, what could be the possible mistake?

I am using SQL Server 2017 with in-database Machine Learning with python scripts with a goal to run Machine Learning models. While following a tutorial on PluralSight 'Getting started with Python on SQL Server' within a sql file, I Declare a…
Shreyas Moolya
  • 339
  • 4
  • 19
0
votes
0 answers

XDF file not saved in RxOptions "OutDataPath"

I am running a small Python RevoscalePy script to import a file into an XDF file. # [RESULTS_LOCATION] = ['C:\\\\Temp\\\\Data\\\\Results'] RxOptions.set_option("OutDataPath", [RESULTS_LOCATION]) ... infile =…
Jérôme Verstrynge
  • 57,710
  • 92
  • 283
  • 453