I am using SQL Server 2016 Developer edition. I am trying to install "rtweet", "text2vec" R packages into SQL Server, but it shows
Package ‘rtweet’ is not available (for R version 3.2.2)
How can I solve this problem?
Asked
Active
Viewed 229 times
1
-
Have you tried updating the version of R on SQL-server? Then try installing the packages, sometimes that works. – WJS Jul 23 '17 at 06:17
-
1This answer might be useful https://stackoverflow.com/a/25721890/2026277 – Jaime Caffarel Jul 23 '17 at 06:23
-
Is this the only error? Can you make sure all dependencies are met? – Roman Luštrik Jul 23 '17 at 06:41
-
"text2vec" and "rtweet" shows for R-3.4.0 versions – mzhasan Jul 23 '17 at 06:53
1 Answers
1
What did you do in order to try and install the package @mzhasan? I am asking as there seems to be an issue with trying to install from the MRAN repo (which is default if you run install.packages with no params apart from the package name).
I have SQL Server 2016 Developer Ed. with R Services in-database and I just now successfully installed the rtweet package from the CRAN repo:
I opened
Rterm.exeas admin. You find it in the path to SQL Server R Services directories:C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\R_SERVICES\bin\x64(on my box).Then I ran the the
install.packagescommand for rtweet:
install.packages("rtweet", repos = "https://cloud.r-project.org/", dependencies=TRUE)
That installed quite fine! So try the CRAN repo, and see if it helps.
Niels
Niels Berglund
- 1,713
- 8
- 6