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?