Description Usage Arguments Details Value Note Author(s) See Also Examples
Load a data.frame object into a MonetDB table with automatic schema detection
1 |
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 |
con <- RMonetConnect("db.yml") res <- RMonetLoadDataFrame(con, craftsmen, "tmp_craftsmen") print(res) RMonetClose(con)
Returns loaded row count - should match the data.frame passed in
Not much to note here.
Piers Harding
RMonet
, RMonetConnect
, RMonetGetInfo
, RMonetQuery
, RMonetLoadDataFrame
, RMonetExecute
, RMonetClose
, RMonetStartTransaction
, RMonetCommit
, RMonetIsConnected
, RMonetQuote
, RMonetUnQuote
, RMonetExists
, RMonetListTables
, RMonetListFields
1 2 3 4 5 | ## Not run:
# Close the connection
RMonetLoadDataFrame(con, my.frame, "tmp_tab", drop=TRUE)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.