[ARROW-17208] [R] Removing files after reading them in R

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 7.0.1
• Component/s: R
• External issue URL: https://github.com/apache/arrow/issues/32497

Language

R

• Assignee: Unassigned
• Reporter: Wytze Gelderloos
• Created: 26/Jul/22 11:34
• Updated: 11/Jan/23 11:49

Description

In R it's not possible to delete the files eventhough the dataframe is cleared from the R environment. 

write.csv(mtcars, file = "mtcars.csv", quote = FALSE, row.names = FALSE)
df <- arrow::to_duckdb(arrow::open_dataset("mtcars.csv", format = "csv", delimiter = ","))

df <- df %>% select(c("mpg", "disp", "drat", "wt")) %>% collect()

## Do some checks on df.

rm(df)
file.remove("mtcars.csv")

The `file.remove` leads to a Permission Denied error eventhough the dataframe is cleared from the R environment.