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

Description Usage Arguments Value See Also

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

1
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.