monetdb.read.csv: Import a CSV file into MonetDB

In MonetDB/MonetDB.R: R DBI interface to MonetDB

Description

Instruct MonetDB to read a CSV file, optionally also create the table for it. Note that this causes MonetDB to read a file on the machine where the server is running, not on the machine where the R client runs.

Usage

   monetdb.read.csv (conn, files, tablename, header=TRUE, 
   best.effort=FALSE, delim=",",
  newline = "\\n", quote = "\"", create=TRUE, col.names=NULL, lower.case.names=FALSE, 
  sep=delim, ...)

Arguments

conn	A MonetDB.R database connection. Created using dbConnect with the MonetDB.R database driver.
files	A single string or a vector of strings containing the absolute file names of the CSV files to be imported.
tablename	Name of the database table the CSV files should be imported in. Created if necessary.
header	Whether or not the CSV files contain a header line.
best.effort	Use best effort flag when reading csv files and continue importing even if parsing of fields/lines fails.
delim	Field separator in CSV file.
newline	Newline in CSV file, usually \n for UNIX-like systems and \r\r on Windows.
quote	Quote character(s) in CSV file.
create	Create table before importing?
lower.case.names	Convert all column names to lowercase in the database?
col.names	Optional column names in case the ones from CSV file should not be used
sep	alias for delim
...	Additional parameters. Currently not in use.

Value

Returns the number of rows imported if successful.

See Also

dbWriteTable in DBIConnection-class

Examples

## Not run: 
library(DBI)
# connect to MonetDB
conn <- dbConnect(MonetDB.R::MonetDB(), dbname = "demo")
# write test data to temporary CSV file
file <- tempfile()
write.table(iris, file, sep=",", row.names=F)
# create table and import CSV
MonetDB.R::monetdb.read.csv(conn, file, "iris")

## End(Not run)

MonetDB/MonetDB.R documentation built on Dec. 31, 2020, 3:18 p.m.