RMonetLoadDataFrame: Load a data.frame into a MonetDB table

Description Usage Arguments Details Value Note Author(s) See Also Examples

Description

Load a data.frame object into a MonetDB table with automatic schema detection

Usage

1
RMonetLoadDataFrame(con, frame, tablename, drop=FALSE, chunk=500000, tmp.file = FALSE, append = FALSE)

Arguments

con

an Open MonetDB Connection handle

frame

The data.frame to be loaded into a MonetDB table

tablename

The table name to load the data.frame into

drop

optional - flag to indicate to drop the table if it exists before recreating on the load

chunk

optional - the number of records to process in each block - default 500,000

tmp.file

optional - flag to use write.csv and temp file instead of memory for table contents formatting - useful for largedata.frame processing

append

optional - flag to indicate appending dta.frame to an existing table

Details

con <- RMonetConnect("db.yml") res <- RMonetLoadDataFrame(con, craftsmen, "tmp_craftsmen") print(res) RMonetClose(con)

Value

Returns loaded row count - should match the data.frame passed in

Note

Not much to note here.

Author(s)

Piers Harding

See Also

RMonet, RMonetConnect, RMonetGetInfo, RMonetQuery, RMonetLoadDataFrame, RMonetExecute, RMonetClose, RMonetStartTransaction, RMonetCommit, RMonetIsConnected, RMonetQuote, RMonetUnQuote, RMonetExists, RMonetListTables, RMonetListFields

Examples

1
2
3
4
5
## Not run: 
# Close the connection
RMonetLoadDataFrame(con, my.frame, "tmp_tab", drop=TRUE)

## End(Not run)

piersharding/RMonet documentation built on May 25, 2019, 6:09 a.m.