[
https://issues.apache.org/jira/browse/ARROW-17737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
SHIMA Tatsuya reassigned ARROW-17737:
-------------------------------------
Assignee: SHIMA Tatsuya
> [R] Continue to retain grouping metadata even if ungroup arrow dplyr query
> --------------------------------------------------------------------------
>
> Key: ARROW-17737
> URL: https://issues.apache.org/jira/browse/ARROW-17737
> Project: Apache Arrow
> Issue Type: Bug
> Components: R
> Affects Versions: 9.0.0
> Reporter: SHIMA Tatsuya
> Assignee: SHIMA Tatsuya
> Priority: Major
>
> Perhaps {{metadata$r$attributes$.group_vars}} needs to be removed when it
> becomes an arrow dplyr query.
> And it must also be written back again when converted to a Table.
> {code:r}
> mtcars |> dplyr::group_by(cyl) |> arrow::arrow_table() |> dplyr::ungroup() |>
> as.data.frame() |> dplyr::group_vars()
> #> character(0)
> mtcars |> dplyr::group_by(cyl) |> arrow:::as_adq() |> dplyr::ungroup() |>
> as.data.frame() |> dplyr::group_vars()
> #> [1] "cyl"
> {code}
> {code:r}
> mtcars |> dplyr::group_by(cyl) |> arrow::arrow_table() |> dplyr::group_by(vs,
> .add = TRUE) |> dplyr::ungroup() |> dplyr::collect()
> #> # A tibble: 32 × 11
> #> # Groups: cyl [3]
> #> mpg cyl disp hp drat wt qsec vs am gear carb
> #> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
> #> 1 21 6 160 110 3.9 2.62 16.5 0 1 4 4
> #> 2 21 6 160 110 3.9 2.88 17.0 0 1 4 4
> #> 3 22.8 4 108 93 3.85 2.32 18.6 1 1 4 1
> #> 4 21.4 6 258 110 3.08 3.22 19.4 1 0 3 1
> #> 5 18.7 8 360 175 3.15 3.44 17.0 0 0 3 2
> #> 6 18.1 6 225 105 2.76 3.46 20.2 1 0 3 1
> #> 7 14.3 8 360 245 3.21 3.57 15.8 0 0 3 4
> #> 8 24.4 4 147. 62 3.69 3.19 20 1 0 4 2
> #> 9 22.8 4 141. 95 3.92 3.15 22.9 1 0 4 2
> #> 10 19.2 6 168. 123 3.92 3.44 18.3 1 0 4 4
> #> # … with 22 more rows
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
