dbCreateTableAs: Create a table in database using a statement

In RPresto: DBI Connector to Presto

Create a table in database using a statement

Description

Create a table in database using a statement

Usage

dbCreateTableAs(conn, name, sql, overwrite = FALSE, with = NULL, ...)

Arguments

conn	a PrestoConnection object, as returned by DBI::dbConnect().
name	The table name, passed on to DBI::dbQuoteIdentifier(). Options are: a character string with the unquoted DBMS table name, e.g. "table_name", a call to DBI::Id() with components to the fully qualified table name, e.g. Id(schema = "my_schema", table = "table_name") a call to DBI::SQL() with the quoted and fully qualified table name given verbatim, e.g. SQL('"my_schema"."table_name"')
sql	a character string containing SQL statement.
overwrite	A boolean indicating if an existing table should be overwritten. Default to FALSE.
with	An optional WITH clause for the CREATE TABLE statement.
...	Other arguments used by individual methods.

RPresto documentation built on April 3, 2025, 11:40 p.m.