在R中创建到DBMS的连接 [英] Create a connection to a DBMS in R
问题描述
我使用库 DBI
创建了一个连接到R中的 monetdblite
数据库,同样的错误。这里是可重现的示例和错误消息我得到。关于如何解决这个问题的任何想法?
#加载包
/ pre>
库(MonetDB.R)
库(monetDBLite)
库(调查)
库(DBI)
#加载数据
数据(api)
#create survey design
dclus1< - svydesign(id =〜dnum,weights =〜pw,data = apiclus1,fpc =〜fpc)
#create Temp dir。
dbfolder < - tempdir()
#create connection
db < - dbConnect(MonetDBLite(),dbfolder)
错误MonetDBLite :: monetdb_embedded_startup(embedded,!getOption(monetdb.debug.embedded,:
unused参数(getOption(monetdb.sequential,TRUE))
作为附加信息,我使用的是:
- R 3.2.4修订
- 最新Rstudio 0.99.893
- Windows 10
请更新您的MonetDB.R和MonetDBLite包,
install.packages(c(MonetDB.R,MonetDBLite),
repos = c https://dev.monetdb.org/Assets/R/,http://cran.rstudio.com/))
I'm using the libraries DBI
to create a connection to a monetdblite
database in R but I keep getting the same error. Here is the reproducible example and the error message I get. Any ideas on how to solve this ?
# Load Packages
library(MonetDB.R)
library(MonetDBLite)
library(survey)
library(DBI)
# Load Data
data(api)
# create survey design
dclus1 <- svydesign(id=~dnum, weights=~pw, data=apiclus1, fpc=~fpc)
# create Temp dir.
dbfolder <- tempdir()
# create connection
db <- dbConnect( MonetDBLite() , dbfolder )
Error in MonetDBLite::monetdb_embedded_startup(embedded, !getOption("monetdb.debug.embedded", : unused argument (getOption("monetdb.sequential", TRUE))
As additional info, I'm using:
- R 3.2.4revised
- latest Rstudio 0.99.893
- Windows 10
please update your MonetDB.R and MonetDBLite packages, there has been a recent API change
install.packages(c("MonetDB.R", "MonetDBLite"),
repos=c("https://dev.monetdb.org/Assets/R/", "http://cran.rstudio.com/"))
这篇关于在R中创建到DBMS的连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!