Questions tagged [r]
This tag is for questions related to the R programming language.
42
questions
1
vote
0
answers
67
views
Machine Learning Services fails from Secondary Node of SQL Failover Cluster Instance
There was a planned cluster failover to the secondary node of our FCI. Afterwards, sp_execute_external_script stopped working.
Examples with error messages are below:
EXEC sp_execute_external_script @...
- 875
0
votes
0
answers
6
views
Help with Data input project
I am relatively very new to R so apologies for the redundancy.
I have a file with trade data from Can to USA for a few years. The data shows exact amounts from two points example ( Ontario-Alabama, ...
0
votes
0
answers
176
views
Avoiding Conversions (or an EAV model)
I was given the task to turn some really messy data into a database. Coming from an Stats/R/Data Science background, I took Hadley Wickham's philosophy of tidy data as a starting point.
However, when ...
- 101
1
vote
1
answer
161
views
Would you recommend to use PL/R in 2021 or is it dead? [closed]
And for many years there exists a PostgreSQL extension to use GNU-R directly in the database: https://www.joeconway.com/plr/
Ubuntu packages are also provided and updated for latest PG: https://...
- 787
2
votes
1
answer
278
views
Incompatibility between unixODBC and Firebird ODBC driver
I'm currently developing a application based in Rcode, ODBC and Firebird.
For that, first I've installed firebird server and unixODBC (both 64 bits since my machine OS is 64-bits). I tried with 32-...
- 63
0
votes
1
answer
87
views
Will creating reports on R using MySQL Database update my database on MySQL?
I use MySQL to store my data. To analyze the data I want to be able to generate monthly reports on R. So far I was able to connect to MySQL using dbConnect but I want to make sure that none of the ...
1
vote
0
answers
40
views
Custom Export from power BI service
I'm trying to make a custom button that exports filtered tables to a csv and downloads them to my computer. I am aware that you can do this with the '...' button but this functionality is for other ...
- 11
0
votes
0
answers
393
views
SQL Server 2016 R Statistics: can't find function
I'm trying to get R Statistics running on my Dev server. I'm using this microsoft tutorial.
I have the default installation of R Analytics as provided my the SQL Server installation:
C:\Program ...
- 3,185
0
votes
1
answer
38
views
How to best manage a queue of external processes
My scenario is a web app that creates jobs that need to be processes by an R script. We are currently have the web app execute a SQL stored proc that executes the R script. However, we quickly ...
- 143
5
votes
1
answer
2k
views
System configuration to address poor PostgreSQL INSERT performance
Problem Symptom
High CPU usage by postmaster child process associated with client connections attempting to INSERT low-volume rows (results in rows INSERTed 25x slower than using COPY ... FROM STDIN ...
- 189
1
vote
0
answers
111
views
better format using nanodbc R on Windows
Using R-3.5 and odbc (which uses nanodbc), I connect via ODBC and the ODBC Driver 13 for SQL Server ODBC driver on windows 10.
DBI::dbGetQuery(odbccon, "select SYSDATETIMEOFFSET() as now")
# ...
- 131
4
votes
2
answers
1k
views
What are exact benefits of using R services on Enterprise vs Standard?
I am currently using SQL Server 2016 SP standard edition and want to install R services. In the documentation is said that a stand alone installation is allowed only on Enterprise (Machine Learning ...
- 3,741
3
votes
0
answers
1k
views
View(df) in R throw (function(x, df1, df2, ncp, log = FALSE))
I connected R with SQL Server (in Visual Studio 2017) the connection succeeded this is Setting.R
settings <- as.environment(list())
dbConnection1 <- 'Driver={SQL Server};Server=
(local)...
- 43
1
vote
1
answer
915
views
connect SQL server file (mdf) with R tool [closed]
It's possible to connect SQL server file (mdf) with R tool in visual studio 2017? I tried that many times but the connection failed.
From visual studio2017, I want to connect R with Sql server ...
- 7
2
votes
1
answer
847
views
How to prevent SQLite from blocking while using R?
I am doing an infinity loop to keep gathering data from database db, rework it and send it to another database db1
library(DBI)
library(RSQLite)
while(1==1){
db = dbConnect(SQLite(), dbname="Data....
- 141
1
vote
1
answer
39
views
Is there a document that specifies un-installation of SQL server 2016 R server [closed]
Basically I want to remove all components of R server from SQL Server 2016 install?
- 11
5
votes
1
answer
42
views
Lifespan of Launchpad-Launched Exterrnal Runtime Processes
When SQL Server uses SQL Launchpad to launch an external runtime (e.g. R or Python) when sp_execute_external_script is used, what's the lifespan of the external runtime process?
Does each ...
- 649
5
votes
3
answers
18k
views
SQL Server LaunchPad "The service did not respond in a timely fashion" + No Log in ExtensibilityLog
I'm trying to start LaunchPad service but it fails to start with:
Error 1053: "The service did not respond in a timely fashion"
I've been reading this was common in RC versions but I'm ...
- 151
2
votes
1
answer
154
views
The R-code in SQL Server won't find package psych
I tried to run R code in SQL Server but it won't run although it runs or R. How can I get R running properly on SQL Server such that it finds the package psych? I tested examples in https://learn....
- 123
1
vote
1
answer
150
views
How one can install a given R package in SQL Server
I was asked to write a R code to do computations. I managed to do it such that it works well in R. Next, I was asked to do the same function in SQL Server. I was unable to do it as it requires a ...
- 11
3
votes
2
answers
1k
views
How to TRIGGER/RETURNING this generator function in PostgreSQL?
I am providing a key table to my users in various categories so I am thinking how to TRIGGER/RETURNING the function with each SELECT.
Functions to generate shorthand unique IDs
The thread answer ...
0
votes
2
answers
4k
views
How to SELECT with two CSV files/... on PostgreSQL? [closed]
I have two CSV files which you can insert into the following PostgreSQL schema.
However, I cannot \COPY the data into the tables.
Pseudocode
Let data_id=1
Show name and event_value from data.csv and ...
1
vote
0
answers
411
views
R Services on SQL Server on Amazon RDS
Can R Services be run on a SQLServer provisioned via Amazon RDS?
- 111
7
votes
4
answers
3k
views
Upgrade SQL Server 2016 R Service (in-database)
I am just wondering whether this is doable. I have installed R service (in-database) together with SQL Server 2016 (patched at SP1+ CU1).
I notice R service version is at 3.2.2, which you can run the ...
- 2,993
2
votes
2
answers
1k
views
Bug with sp_execute_external_script
I think I encountered a bug with sp_execute_external_script, so here is the replay.
I will get an error if I run the following script:
-- error occurs
exec sp_execute_external_script @language=N'R'
,...
- 2,993
1
vote
0
answers
629
views
Teradata SQL Assistant - CALL Failed HY000: User Defined Function source on the client is not supported by the driver
Using Teradata SQL Assistant to install a user defined R script fails with an error.
The call looks like this:
SET SESSION SEARCHUIFDBPATH = demouser; -- Tells the linux user tduser, where to find ...
- 11
1
vote
2
answers
1k
views
Parallel PostgreSQL Queries with R
I'm running a large query that for various reasons, I've broken into a series of smaller queries. The example below is just to show how the query is broken up by id; the actual query is much more ...
- 261
3
votes
0
answers
1k
views
execute R script using a postgresql trigger:
This is my first question here, so excuse me if it does not look well organized:
I want to call a R script from a trigger (postgresql) so this script will be executed after an INSERT on my table (...
- 31
3
votes
1
answer
4k
views
How do you set the working directory to a mapped network drive for R language in SSMS?
So I'm messing around with the new "Integration with R" feature in SQL 2016. However, having trouble setting the working directory to a mapped network drive (Z:) within SSMS.
Here's my code:
EXEC ...
- 611
2
votes
2
answers
921
views
Is there a way to pass two SQL tables w/o JOIN for processing into R using MS SQL Server 2016?
Is there a way to pass two SQL Server tables without a JOIN for processing into R using MS SQL Server 2016?
For Example, @input_data_1=TABLE, passes the 'TABLE' as a dataframe into R with default ...
- 121
3
votes
2
answers
7k
views
SQL Server 2016 Install - R Server and R Services Install Failed
I just installed SQL Server 2016 Developer and included R Server and R Services to get installed as well. Everything installed correctly except the R Server and R Services. The log file contained this:...
- 1,972
4
votes
2
answers
460
views
Can SQL Server R Services be enabled on a readable secondary?
To avoid excess load on the primary SQL Server, I'd like to install and enable R Services on a secondary replica of the primary server. Is this possible?
Also, can I push computations from a remote R ...
- 391
3
votes
2
answers
1k
views
SQL Server R Services - Could not find stored procedure 'master..xp_ScaleR_init_job'
I'm trying to run a data science experiment as explained in this tutorial.
The tutorial has 5 lessons, and each lesson has a few sub-sections in it.
For this tutorial, I am using
a SQL Server 2016 ...
- 391
4
votes
1
answer
1k
views
Connecting a standalone Microsoft R Server to a SQL Server with R Services and a SQL Server without R Services
Let's assume I have 3 machines with me.
My first machine has SQL Server 2016 with R Services installed on it.
My second machine has SQL Server 2016 without R services enabled on it.
My third ...
- 391
2
votes
1
answer
956
views
SQL Server 2016 - Is the Microsoft R Client any different from a standalone Microsoft R Server?
Along with the integrated R services on SQL Server 2016, Microsoft is also offering enterprise level Microsoft R Server as a standalone installation.
Some of the documentation on MSDN shows that the ...
- 391
1
vote
1
answer
472
views
Can SQL Server 2016 R Services be used to connect to Hadoop data?
I've only been experimenting with SQL Server 2016 recently. So, please correct me if my assumptions are incorrect:
From some research on SQL Server R Services, I see that RxHDFSConnect and ...
- 391
3
votes
1
answer
604
views
Using SQL Server 2016 R Services over a standalone installation of Microsoft R Server
I've been experimenting with SQL Server 2016 and its R Services. I also have a standalone Microsoft R Server installed on my machine.
What is a good use-case to use SQL Server R Services over a ...
- 391
2
votes
0
answers
332
views
Can SQL Server 2016 R Services connect to SAS, SPSS, URLs etc?
The RevoScaleR package of SQL Server R Services (Microsoft R Server) has functions that allow you to connect to SAS, SPSS, HDFS and text files.
My question is:
Can R Services connect to SAS/SPSS to ...
- 391
1
vote
1
answer
364
views
Slow-running query returns incomplete resultset
So I'm trying to get some data from an SQL Server 2008 instance, the query is quite simple in structure but it has an extremely poor performance, it takes just under a minute to retrieve a bit over 1,...
- 1,689
1
vote
1
answer
58
views
Is this work flow suitable for Amazon RDS?
I am considering to set up a MySQL database via amazon web services (AWS). Consider the following steps which characterize my workflow:
There is a daily data inflow into several AWS EC2 instances
On ...
- 113
0
votes
2
answers
6k
views
Connecting to SQL Server from R which is Running on Remote UNIX Machine
We have a UNIX machine which includes R engine on it and installed SQL Server ODBC Driver 11.
We need to connect R to SQL Server. SQL Server currently works on another machine, so we tried to connect ...
- 111
4
votes
2
answers
3k
views
Msg 39011, SQL Server was unable to communicate with the LaunchPad service
We have just installed SQL Server Enterprise 2016 CTP 3.3 on a server that already had SQL 2012 Standard installed. We installed SQL2016 as a Named Instance and have been trying to get the R ...
- 141