Create a table — dbCreateTable,TrinoConnection-method • RTrino

Trino has no temporary tables, so temporary = TRUE is an error rather than being silently ignored.

Usage

# S4 method for class 'TrinoConnection'
dbCreateTable(conn, name, fields, ..., row.names = NULL, temporary = FALSE)

Arguments

conn: A TrinoConnection object.
name: Table name, in any form dbExistsTable() accepts.
fields: Either a named character vector of Trino types, one per column, or a data frame whose columns' R types are mapped to Trino types with dbDataType().
...: Unused, for compatibility with the generic.
row.names: Unused: RTrino never writes row names as a column.
temporary: Must be FALSE.

Value

TRUE, invisibly.

Examples

if (FALSE) { # nzchar(Sys.getenv("RTRINO_TEST_URL"))
con <- DBI::dbConnect(RTrino::Trino(), host = Sys.getenv("RTRINO_TEST_URL"),
                      catalog = "memory", schema = "default")
DBI::dbCreateTable(con, "sales", c(id = "bigint", label = "varchar"))
DBI::dbListFields(con, "sales")
DBI::dbRemoveTable(con, "sales")

# The column types can also follow a data frame's
DBI::dbCreateTable(con, "sales", data.frame(id = 1L, label = "a"))
DBI::dbRemoveTable(con, "sales")

DBI::dbDisconnect(con)
}