collapse()
creates a subquery; compute()
stores the results in a
remote table; collect()
downloads the results into the current
R session.
# S3 method for tbl_sql
collapse(x, ...)# S3 method for tbl_sql
compute(x, name = unique_table_name(),
temporary = TRUE, unique_indexes = list(), indexes = list(),
analyze = TRUE, ...)
# S3 method for tbl_sql
collect(x, ..., n = Inf, warn_incomplete = TRUE)
A tbl_sql
other parameters passed to methods.
Table name in remote database.
Should the table be temporary (TRUE
, the default) or persistent (
FALSE`)?
a list of character vectors. Each element of the list will create a new unique index over the specified column(s). Duplicate rows will result in failure.
a list of character vectors. Each element of the list will create a new index.
if TRUE
(the default), will automatically ANALYZE the
new table so that the query optimiser has useful information.
Number of rows to fetch. Defaults to Inf
, meaning all rows.
Warn if n
is less than the number of result rows?