dbCreateTable: dbCreateTable()

Description Usage Arguments See Also Examples

Description

Creates a new table

Usage

1
2
dbCreateTable(conn, name, fields, ..., row.names = NULL,
  temporary = FALSE)

Arguments

conn

an object of [KineticaConnection-class]

name

character string for table name or [KineticaId-class] object

fields

either a named character vector or a data frame

...

Other parameters passed on to methods.

row.names

Must be 'NULL'.

temporary

logical flag value whether table should be temporary

See Also

Other KineticaConnection methods: dbAppendTable, 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, dbWriteTable, show,KineticaDriver-method, sqlCreateTable,KineticaConnection-method, transactions

Examples

1
2
3
4
5
6
7
8
## Not run: 
con <- dbConnect(Kinetica(), url = "http://localhost:9191")
dbCreateTable(con, "tableA", data.frame(a = 1))
dbExistsTable(con, "tableA")
# TRUE
dbDisconnect(con)

## End(Not run)

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