Nothing
Code
lazy_frame(x = 1) %>% reframe()
Condition
Error in `reframe()`:
! `reframe()` is not supported on database backends.
Code
(expect_error(summarise(lf1, a_sum = sum(a), issue_col = sum(a_sum))))
Output
<error/rlang_error>
Error in `summarise()`:
i In argument: `issue_col = sum(a_sum)`
Caused by error:
! In dbplyr you cannot use a variable created in the same `summarise()`.
x `a_sum` was created earlier in this `summarise()`.
i You need an extra `mutate()` step to use it.
Code
(expect_error(summarise(lf1, across(c(a, b), list(sum = sum)), issue_col = sum(
a_sum))))
Output
<error/rlang_error>
Error in `summarise()`:
i In argument: `issue_col = sum(a_sum)`
Caused by error:
! In dbplyr you cannot use a variable created in the same `summarise()`.
x `a_sum` was created earlier in this `summarise()`.
i You need an extra `mutate()` step to use it.
Code
(expect_error(summarise(lf1, across(c(a, b), list(sum = sum)), issue_col = sum(
b_sum))))
Output
<error/rlang_error>
Error in `summarise()`:
i In argument: `issue_col = sum(b_sum)`
Caused by error:
! In dbplyr you cannot use a variable created in the same `summarise()`.
x `b_sum` was created earlier in this `summarise()`.
i You need an extra `mutate()` step to use it.
Code
(expect_error(summarise(lf1, a_sum = sum(a), issue_col = across(a_sum, sum))))
Output
<error/rlang_error>
Error in `summarise()`:
i In argument: `issue_col = across(a_sum, sum)`
Caused by error:
! In dbplyr you cannot use a variable created in the same `summarise()`.
x `a_sum` was created earlier in this `summarise()`.
i You need an extra `mutate()` step to use it.
Code
eval_bare(expr(lazy_frame(x = 1, y = 2) %>% dplyr::group_by(x, y) %>% dplyr::summarise() %>%
remote_query()), env(global_env()))
Message
`summarise()` has grouped output by "x". You can override using the `.groups` argument.
Output
<SQL> SELECT `x`, `y`
FROM `df`
GROUP BY `x`, `y`
Code
df %>% summarise(.groups = "rowwise")
Condition
Error in `summarise()`:
! `.groups` can't be "rowwise" in dbplyr
i Possible values are NULL (default), "drop_last", "drop", and "keep"
Code
(result1 <- lf %>% group_by(g) %>% summarise(g = g + 1))
Output
<SQL>
SELECT `g` + 1.0 AS `g`
FROM `df`
GROUP BY `g`
Code
(result2 <- lf %>% group_by(g) %>% summarise(x = x + 1, g = g + 1))
Output
<SQL>
SELECT `g` + 1.0 AS `g`, `x` + 1.0 AS `x`
FROM `df`
GROUP BY `g`
Code
df %>% group_by(g) %>% summarise(across(.fns = ~0))
Output
<SQL>
SELECT `g`, 0.0 AS `x`
FROM `df`
GROUP BY `g`
.by
with .groups
Code
summarise(df, .by = x, .groups = "drop")
Condition
Error in `summarise()`:
! Can't supply both `.by` and `.groups`.
.by
with grouped-dfCode
summarise(gdf, .by = x)
Condition
Error:
! Can't supply `.by` when `.data` is a grouped data frame.
Code
out %>% sql_render
Output
<SQL> SELECT `x`, COUNT(*) AS `n`
FROM `verb-summarise`
GROUP BY `x`
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.