monet.read.csv: Try to read CSV files directly into MonetDB from R. Can be...

In RMonetDB: Provides access to MonetDB through the JDBC interface

Description

This function reads the initial lines of a CSV file to attempt to work out column classes, uses dbWriteTable to create an empty table, and then calls the MonetDB bulk input statement to read the file.

Usage

monet.read.csv(connection, files, tablename, nrows, header = TRUE, locked = FALSE, na.strings = "", ..., nrow.check = 500)

Arguments

connection	Connection to a MonetDB database
files	Vector of one or more filenames, for files to be put in the same table.
tablename	Character string giving the table to be created
nrows	Approximate number of rows in the file (to reduce copying)
header	as in read.csv
locked	If TRUE, lock the table while loading the data (faster)
na.strings	A single character string denoting missing values, to be converted to SQL NULL.
...	Other arguments to read.csv, in particular, colClasses
nrow.check	Number of rows to read while attempting to work out variable types.

Value

Called for its side-effect

See Also

dbWriteTable

RMonetDB documentation built on May 2, 2019, 6:08 p.m.