db_load_from_file: Loads a file (typically CSV) from disk to Vertica.

In vertica/vertica.dplyr: A dplyr connector for Vertica

Description

Currently, this will only work for tables that already exist with compatible schema for the table.

Usage

db_load_from_file(dest, table.name, file.name, sep = " ", skip = 1L,
  append = FALSE)

Arguments

dest	Vertica connection src to the DB.
table.name	The name of the table created in Vertica matching the schema of the file.
file.name	Path to file with data.
sep	Delimiter in the file.
skip	Number of lines to skip at the beginning of the file (useful if contains headers).
append	TRUE if copied data will be added to existing data in table. FALSE to overwrite table data.

Details

This loading is fast and is used (by default) in copy_to.

Value

A new tbl_vertica reference to the loaded table.

Examples

## Not run: 
vertica <- src_vertica("VerticaDSN")
foo <- db_load_from_file(vertica,"foo","./foo.csv",sep=",")

## End(Not run)

vertica/vertica.dplyr documentation built on May 3, 2019, 6:11 p.m.