[ARROW-16038] [R] different behavior from dplyr when mutate's `.keep` option is set

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 7.0.0
• Fix Version/s: 8.0.0
• Component/s: R
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/31457
• Assignee: Sam Albers
• Reporter: SHIMA Tatsuya
• Created: 27/Mar/22 15:20
• Updated: 11/Jan/23 11:41
• Resolved: 07/Apr/22 21:07

Description

The order of columns when `dplyr::mutate`'s `.keep` option is set to "none", etc. has been changed in dplyr 1.0.8 and differs from the current behavior of the arrow package.

For more information, please see the following issues.

https://github.com/tidyverse/dplyr/pull/6035
https://github.com/tidyverse/dplyr/issues/6086
https://github.com/tidyverse/dplyr/pull/6087

library(dplyr, warn.conflicts = FALSE)

df <- tibble::tibble(x = 1:3, y = 4:6)

df |>
  transmute(x, z = x + 1, y)
#> # A tibble: 3 × 3
#>       x     z     y
#>   <int> <dbl> <int>
#> 1     1     2     4
#> 2     2     3     5
#> 3     3     4     6

df |>
  mutate(x, z = x + 1, y, .keep = "none")
#> # A tibble: 3 × 3
#>       x     y     z
#>   <int> <int> <dbl>
#> 1     1     4     2
#> 2     2     5     3
#> 3     3     6     4

df |>
  arrow::arrow_table() |>
  mutate(x, z = x + 1, y, .keep = "none") |>
  collect()
#> # A tibble: 3 × 3
#>       x     z     y
#>   <int> <dbl> <int>
#> 1     1     2     4
#> 2     2     3     5
#> 3     3     4     6

Issue Links

• links to: GitHub Pull Request #12818