collapse.tbl_sql {dbplyr} | R Documentation |
collapse()
creates a subquery; compute()
stores the results in a
remote table; collect()
downloads the results into the current
R session.
## S3 method for class 'tbl_sql' collapse(x, ...) ## S3 method for class 'tbl_sql' compute(x, name = unique_table_name(), temporary = TRUE, unique_indexes = list(), indexes = list(), analyze = TRUE, ...) ## S3 method for class 'tbl_sql' collect(x, ..., n = Inf, warn_incomplete = TRUE)
x |
A |
... |
other parameters passed to methods. |
name |
Table name in remote database. |
temporary |
Should the table be temporary ( |
unique_indexes |
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. |
indexes |
a list of character vectors. Each element of the list will create a new index. |
analyze |
if |
n |
Number of rows to fetch. Defaults to |
warn_incomplete |
Warn if |