as.data.frame: Convert 'monet.frame' into 'data.frame'.

In MonetDB.R: Connect MonetDB to R

Description

Materialise virtual data object monet.frame into R objects data.frame or vector.

Usage

   ## S3 method for class 'monet.frame'
 as.data.frame(x, row.names, optional, warnSize=TRUE, ... )

Arguments

x	A monet.frame monet.frame virtual data object.
row.names	Unused.
optional	Unused.
warnSize	Prevent user from loading too many tuples from the DB. The limit is calculated by multiplying nrow with ncol. If set to false, the warning is disabled. The current limit is 10.000.000.
...	Unused.

Value

returns a data.frame or vector populated with data from the database table that was wrapped by monet.frame. Note that as.vector can only be used on single-column moent.frame objects.

Examples

## Not run: 
# connect to MonetDB
conn <- dbConnect(MonetDB.R(), "monetdb://localhost/demo")
# write some test data
data(iris)
dbWriteTable(conn, "iris", iris)
# construct monet.frame
frame <- monet.frame(conn,"iris")
# convert to R data.frame
rframe <- as.data.frame(frame)
rvector <- as.vector(frame$sepal_width)


## End(Not run)

MonetDB.R documentation built on May 2, 2019, 5:26 p.m.