dbplyr database methods
# S3 method for PrestoConnection
db_list_tables(con)# S3 method for PrestoConnection
db_has_table(con, table)
# S3 method for PrestoConnection
db_write_table(
con,
table,
types,
values,
temporary = FALSE,
overwrite = FALSE,
...,
with = NULL
)
# S3 method for PrestoConnection
db_copy_to(
con,
table,
values,
overwrite = FALSE,
types = NULL,
temporary = TRUE,
unique_indexes = NULL,
indexes = NULL,
analyze = TRUE,
...,
in_transaction = TRUE,
with = NULL
)
# S3 method for PrestoConnection
db_compute(
con,
table,
sql,
temporary = TRUE,
unique_indexes = list(),
indexes = list(),
analyze = TRUE,
with = NULL,
...
)
# S3 method for PrestoConnection
db_sql_render(con, sql, ..., use_presto_cte = TRUE)
A PrestoConnection
as returned by dbConnect()
.
Table name
Column types. If not provided, column types are inferred using dbDataType.
A data.frame
.
If a temporary table should be used. Not supported. Only FALSE is accepted.
If an existing table should be overwritten.
Extra arguments to be passed to individual methods.
An optional WITH clause for the CREATE TABLE statement.
Ignored. Included for compatibility with generics.
A SQL statement.
A logical value indicating if to use common table expressions stored in
PrestoConnection when possible. Default to TRUE. See
vignette("common-table-expressions")
.