dbplyr database methods

dbplyr database methods

Usage

# 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)

Arguments

con

A PrestoConnection as returned by dbConnect().

table

Table name

types

Not used. Only NULL is accpeted.

values

A data.frame.

temporary

If a temporary table should be used. Not supported. Only FALSE is accepted.

overwrite

If an existing table should be overwritten.

...

Extra arguments to be passed to individual methods.

with

An optional WITH clause for the CREATE TABLE statement.

unique_indexes, indexes, analyze, in_transaction

Ignored. Included for compatibility with generics.

sql

A SQL statement.

use_presto_cte

A logical value indicating if to use common table expressions stored in PrestoConnection when possible. Default to TRUE. See vignette("common-table-expressions").