MonetDB.R (version 0.8.0)

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

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, \dots )

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

# 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)