Questions tagged [r]

This tag is for questions related to the R programming language.

Filter by
Sorted by
Tagged with
1
vote
0answers
10 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 ...
0
votes
0answers
94 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 ...
0
votes
1answer
29 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 ...
2
votes
1answer
130 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 ...
1
vote
0answers
45 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") # ...
4
votes
2answers
787 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 ...
2
votes
0answers
122 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)...
1
vote
1answer
453 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 ...
1
vote
1answer
407 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....
1
vote
1answer
35 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?
5
votes
1answer
32 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 ...
4
votes
1answer
7k 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 running SQL ...
2
votes
1answer
103 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://docs....
1
vote
1answer
93 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 ...
2
votes
2answers
450 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
2answers
2k 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
0answers
312 views

R Services on SQL Server on Amazon RDS

Can R Services be run on a SQLServer provisioned via Amazon RDS?
6
votes
3answers
2k 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
votes
2answers
721 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' ,...
1
vote
0answers
352 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 ...
1
vote
1answer
648 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 ...
2
votes
0answers
692 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 (...
3
votes
1answer
2k 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 ...
2
votes
2answers
774 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 ...
3
votes
1answer
5k 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:...
4
votes
2answers
400 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 ...
3
votes
2answers
702 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 ...
4
votes
1answer
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 ...
2
votes
1answer
926 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 ...
1
vote
1answer
446 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 ...
3
votes
1answer
565 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 ...
2
votes
0answers
302 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 ...
1
vote
1answer
257 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
vote
1answer
49 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 ...
0
votes
2answers
5k 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 ...
4
votes
2answers
2k 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 ...