db_list_tables.PrestoConnection {RPresto}

dbplyr database methods

Description

dbplyr database methods

Usage

## S3 method for class 'PrestoConnection'
db_list_tables(con)

## S3 method for class 'PrestoConnection'
db_has_table(con, table)

## S3 method for class 'PrestoConnection'
db_write_table(
  con,
  table,
  types,
  values,
  temporary = FALSE,
  overwrite = FALSE,
  ...,
  with = NULL
)

## S3 method for class '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 class 'PrestoConnection'
db_compute(
  con,
  table,
  sql,
  temporary = TRUE,
  unique_indexes = list(),
  indexes = list(),
  analyze = TRUE,
  with = NULL,
  ...
)

## S3 method for class 'PrestoConnection'
db_sql_render(con, sql, ..., use_presto_cte = TRUE)

Arguments

con

A PrestoConnection as returned by dbConnect().

table

Table name

types

Column types. If not provided, column types are inferred using dbDataType.

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").