dbWriteTable: dbWriteTable()

In kineticadb/RKinetica: Kinetica DBI datasource

Description

Writes a dataset into Kinetica DB, appending, creating or overwriting a table as indicated by flags.

Usage

dbWriteTable(conn, name, value, ...)

Arguments

conn	an object of [KineticaConnection-class]
name	character string for table name or [KineticaId-class] object
value	a [data.frame] (or object coercible to data.frame)
...	Other arguments omitted in generic signature
row.names	a logical flag, NULL or chaacter value to create extra row_names column
overwrite	a logical flag to overwrite existing table with new columns and values
append	a logical flag to preserve existing data and append new records
field.types	a named character vector of value field names and types
temporary	a logical flag to create table as temporary storage

See Also

[dbCreateTable()] [dbAppendTable()] [dbRemoveTable()]

Other KineticaConnection methods: dbAppendTable, dbCreateTable, dbDataType,KineticaConnection-method, dbDisconnect,KineticaConnection-method, dbExecute,KineticaConnection,character-method, dbExistsTable, dbGetInfo, dbGetQuery,KineticaConnection,character-method, dbIsValid, dbListFields, dbListObjects,KineticaConnection-method, dbListResults,KineticaConnection-method, dbListTables,KineticaConnection-method, dbReadTable, dbRemoveTable, dbSendQuery,KineticaConnection,character-method, dbSendStatement,KineticaConnection,character-method, show,KineticaDriver-method, sqlCreateTable,KineticaConnection-method, transactions

Examples

## Not run: 
con <- dbConnect(Kinetica(), url = "http://localhost:9191")
dbWriteTable(con, "test", data.frame(a = 1L:3L, b = 2.1:4.2), row.names = FALSE)
dbDisconnect(con)

## End(Not run)

kineticadb/RKinetica documentation built on Sept. 29, 2020, 5:38 p.m.