Stack Overflow
Stack Overflow

Questions tagged [revoscaler]

questions relating to the RevoScaleR package for R from Microsoft.

RevoScaleR is a (free but closed-source) machine learning package in R created by Microsoft. It is available as part of Machine Learning Server, Microsoft R Client, and Machine Learning Services in Microsoft SQL Server 2016.

27 questions
0
votes
1 answer

No parallel processing happens with rxExec from RevoScaleR

Testing the parallel processing brought by the RevoScaleR package with SQL Server 2016 R Services (In-Database). Following the example provided by Microsoft here…
Fugui
  • 91
  • 9
0
votes
1 answer

rxDataStep failing to load the data in SQL Server table

I am trying to load the SQL query result to a new table after some transformation. But even the simplest script is failing. DECLARE @inquery nvarchar(max) = N' SELECT TOP 2000000 * from SQL Table' DECLARE @Rscript nvarchar(max) = N' …
Ashish Tripathi
  • 339
  • 4
  • 4
0
votes
1 answer

RStudio - RevoScaleR (Windows)

Can this package be used for either (1) RStudio Desktop/Open; and/or (2) RStudio Server (also using SQL Server 2017 Enterprise)? I'm primarily interested in RStudio Desktop, however can't appear to find anything online after about one hour of…
theemperor
  • 1
  • 3
0
votes
1 answer

RxCrossTable: transformation doesn't work

I am doing this exercise and I can't find the error. The data is a subsample of the New York taxi dataset (mht_lab2.zip on Github). In this current exercise I am supposed to tabulate short and long duration taxi trips against short/long distance…
5th
  • 2,097
  • 3
  • 22
  • 41
0
votes
2 answers

Group by on XDF file?

Say I have a huge source XDF file generated with RevoScaleR. I want to create a new target XDF by grouping the source entries on columns A, B, C and compute the sum, min, max, avg, std deviation on column D. Let's assume the target data is too big…
Jérôme Verstrynge
  • 57,710
  • 92
  • 283
  • 453
0
votes
1 answer

revoscaler sqlServerdData rxImport uniqueidentifier column failed

I'm trying to import data from SQL Server, but I'm having issues importing a table which consists of uniqueidentifier column type. I'm using R Client 3.3.2.0 to query database. Database table: Code: sqlConnString = "DRIVER=ODBC Driver 11 for SQL…
Joan Dimko
  • 115
  • 7
0
votes
1 answer

I am unable to use dplyrXdf in hdinsights due to old libraries

I wrote a script using RevoScaleR and dplyrXdf, to my surprise when using HDInsights (Microsoft Azure managed Spark cluster service) I get an installation of R 3.3.3 and I can't install dplyrXdf, neither is the package in the repository nor can I…
Rodrigo Rodrigues
  • 108
  • 8
0
votes
1 answer

Using revoscalepy to insert data into a database

Ahoi there, is there a possibility of using the revoscalepy package to insert values into a table? I would expect something along the lines of: import pandas as pd from revoscalepy import rx_write_to_db, RxOdbcData a_df = pd.DataFrame([[0, 1], [2,…
muma
  • 345
  • 3
  • 10
0
votes
1 answer

RevoScaleR rxDataStep rowselection fails when using variable

I am trying to perform a selection on a xdf file with rxDataStep. I am using rowSelection and it works when I use explicit values but not when I use a variable, e.g.: this works: tmp <- rxDataStep(alias.Xdf, transforms = list(TT_AMOUNT = DC_AMOUNT *…
Rodrigo Rodrigues
  • 108
  • 8
0
votes
1 answer

How to use RevoScaleR to read SAS data chunk-by-chunk and output into a format other than xdf?

I am trying to develop some code using RevoScaleR and noticed that it has options like rowsPerRead and can output xdf files in chunks using the rxImport method. However my use cases I want to apply some custom transformation (to the entire chunk;…
xiaodai
  • 14,889
  • 18
  • 76
  • 140
0
votes
1 answer

Azure / R-server - rxKmeans write file with no header

I'm doing a kmeans clustering in Azure / R-server and need to be able to write a file that does not have a header. So far I've tried: k1 <- rxKmeans(formula = ~ var1 + var2 + var3, data = df, seed = 10, numClusters = 5 , outFile =…
screechOwl
  • 27,310
  • 61
  • 158
  • 267
-1
votes
1 answer

Microsoft ML server /R client package issue

I have microsoft ML server/ R Client installed in my system. But when I try to load packages, it is giving version errors like the following : namespace ‘stringi’ 1.1.6 is being loaded, but >= 1.1.7 is required namespace ‘Rcpp’ 0.12.14 is already…
Dom Jo
  • 320
  • 1
  • 3
  • 13
1
2